how do i get a macro to search for the first blank cell in column A and then insert yesterdays date into that first blank cell and the next 5 cells below.
for the date, i thought i could use
and for the find empty cell, i thought i could use
Please Login or Register to view this content.
but i am having some problems ironing it out and fitting it all togetherPlease Login or Register to view this content.
Last edited by ~Lews Therin~; 02-16-2009 at 09:45 PM.
Hi there,
Not sure how lines of data you have in Column A, but nonetheless the following should do the job:
HTHPlease Login or Register to view this content.
Robert
Another way:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
thats awesome, thanks
just one more thing-that enters the time as well, any way i can make it only insert the date?
Try mine ...?
Or just format the date to suit, i.e.:
Though I'd actually suggest using shg's codePlease Login or Register to view this content.
Last edited by Trebor76; 02-16-2009 at 09:12 PM.
yours returns an error after using it twice
how do i adapt the one by trebor to search for the first blank cell in column B but put the date into A?
why is shg's better? is his adaptable to what i said one post earlier??
I hadn't tested shg's post (code) but one line of code would always be preferrable to multiple lines.
To put the date in Column A when the first blank is found in Column B, try this:
Please Login or Register to view this content.
Last edited by Trebor76; 02-16-2009 at 09:17 PM.
thanks its what i needed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks