bokenrosie
New Member
- Joined
- Jun 13, 2014
- Messages
- 48
Hi All,
Seems pretty like a pretty simple macro recording task but I cannot seem to get to where I want to be.
I have a report that comes in by CSV monthly. I have started a recording macro but cannot get the delete range part right.
After I sort my sheet I need to search for a value in a column. When I get down to the row in the search I need to delete all rows from the row to the top (except the top row).
The number of rows will change monthly.
Would somebody help me with the costruction of this in VBA, I assume recording is not going to work because that takes
I think
Range("Your Range”).Delete Shift:=xlUp
does the deleting but how do I get my range in there?
TIA
Seems pretty like a pretty simple macro recording task but I cannot seem to get to where I want to be.
I have a report that comes in by CSV monthly. I have started a recording macro but cannot get the delete range part right.
After I sort my sheet I need to search for a value in a column. When I get down to the row in the search I need to delete all rows from the row to the top (except the top row).
The number of rows will change monthly.
Would somebody help me with the costruction of this in VBA, I assume recording is not going to work because that takes
I think
Range("Your Range”).Delete Shift:=xlUp
does the deleting but how do I get my range in there?
TIA