HELLO ALL, Can someone tell me how to write the following in VBA?
I have data in a range, lets say it is range A10:Y90
Note that row 9 includes headers to the data does begin on row 10.
I want to sort the range by the values in column C.
Secondly, be abkle to filer only those rows where column C >= the value 50.
Thanks in advance
Lucy
You could record those steps and you'll have the VBA code.
- Start recording
- Select A9:Y90 (include the headers)
- Select from the menu Data\Sort
- Sort on column C
- Okay
- Select Data\Filter\Autofilter
- Autofilter on column C
- Custom >=50
- Stop Recording
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks