Writing Macros

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