Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find first empty cell in column J. Copy, paste special, value from
Hi,
I have searched this site for several hours, but I am not able to find the answer I am looking for. I'm a novise om VBA - maybe that's why? I need to [copy + paste special, value] the value of K1 [=NOW()] down to the first empty cell in column J. Column J has got blank cells so the code needs to ignore these blanks. Please explain as for a VBA novise. Like: Where to put the code... Full-text-code... Just to explain the purpose: (I know how to do the following): Finally I want to make a button assigned to this macro to enable a one-click operation to paste the date/time value in the bottom of my continuously expanding list. -- Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy column, paste special formulas & number formats doesn't work | Excel Discussion (Misc queries) | |||
How to set macro to Paste Special Value to next empty column | Excel Worksheet Functions | |||
copy, find next blank row, paste special location | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Find Empty Column and paste cell values | Excel Programming |