About Us

Don Guillett

Glad to help
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sgwapt" wrote in message
...
Leave it up to the guru's
Way to go Don

LOL
--
George G

"Don Guillett" wrote:

one way. Didn't test
lri=cells(rows.count,"i").end(xlup).row+1
lrh=cells(rows.count,"h").end(xlup).row
range(cells(lri,"i"),cells(lrh,"i")=date

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mikerobe" wrote in message
...
Hi
I have recently asked a similar question but having thought about it
there may be an easier solution to what i want. I have a worksheet
where rows of data are added daily. The data goes to column H
inclusive. I would like to add todays date to column "I" when data is
added. So I was guessing it might be possible to create a macro to add
that days date based on the fact that if Column "I" is blank down as
far as there is data in column H. This would then build up a new
column "Date data added".

Can anyone help me with code for this?

Much appreciated

Eddie

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding entries if date entered in another column	Jen	Excel Worksheet Functions	6	February 17th 09 07:23 PM
Column Chart - Adding text in the column in Excel 2007	Jennifer	Charts and Charting in Excel	2	July 26th 08 02:58 PM
Adding a date timestamp to the last column of a spreadsheet	[email protected]	Excel Programming	6	August 9th 06 04:48 PM
Adding a date stamp to each cell in column - after the fact	[email protected]	Excel Discussion (Misc queries)	1	April 24th 06 10:28 PM
Adding a column based on greater than a date	Toni G.	Excel Worksheet Functions	4	March 17th 05 08:06 PM