Writing Macros

S

sportsbarn

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)?
 
C

CLR

Maybe this line in your code will help......

Range("A203:A205").ClearContents

Vaya con Dios,
Chuck, CABGx3
 
S

Scoops

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
 
Top