I'm a newbie to excel macro's, i know enough to get into trouble.
What i have is a macro that when I run it i need it to find the first
row of data, But if that row happens to be A3 I need it to leave a
statment "No exceptions as of" in A4 since A3 is my header row.

I believe

Dim rng1 As Range
Set rng1 = wstest.Range("A65536").End(xlUp)

is used to find the first row with data working from the bottom of the
column and working up. what is needed after this to place my comment?

thanks for your assistance.


--
duhrl
------------------------------------------------------------------------
duhrl's Profile: http://www.thecodecage.com/forumz/member.php?userid=126
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73880