I am having troubles deleting below a certain point when writing macros using
seperate worksheets with varying data amounts.
Is there a way to identify a non-specific point? Instead of a cell specific
point when writing the code, ie (A203:A205)?
I am having troubles deleting below a certain point when writing macros using
seperate worksheets with varying data amounts.
Is there a way to identify a non-specific point? Instead of a cell specific
point when writing the code, ie (A203:A205)?
Maybe this line in your code will help......
Range("A203:A205").ClearContents
Vaya con Dios,
Chuck, CABGx3
"sportsbarn" wrote:
> I am having troubles deleting below a certain point when writing macros using
> seperate worksheets with varying data amounts.
>
> Is there a way to identify a non-specific point? Instead of a cell specific
> point when writing the code, ie (A203:A205)?
Hi sportsbarn
Not entirely sure what you're after but:
LastRow = Range("A65536").End(xlup).Row
will give you the last used row in column A.
Always delete from bottom to top.
Regards
Steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks