| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA loop
Hi again,
I have another problem, can someone give me a code that can copy a date from one cell and drop it into the first empty cell down a column Many thanks in advance John PS Thanks to Tom Ogilvy for last problem solved |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA loop
Cells(Rows.Count,"A").End(xlup).Offset(1,0).Value = Range("B1").Value
-- HTH RP (remove nothere from the email address if mailing direct) "JohnUK" wrote in message ... Hi again, I have another problem, can someone give me a code that can copy a date from one cell and drop it into the first empty cell down a column Many thanks in advance John PS Thanks to Tom Ogilvy for last problem solved |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA loop
John:
How are you getting to the cell with the date? Will it be the same cell every time? Will the date be dynamic (changing every time you open the workbook on a different day to reflect the actual date) or static and never changing? Are you inserting this date as the start of a larger macro filling in a row of data? Ed "JohnUK" wrote in message ... Hi again, I have another problem, can someone give me a code that can copy a date from one cell and drop it into the first empty cell down a column Many thanks in advance John PS Thanks to Tom Ogilvy for last problem solved |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find loop doesn't loop | Excel Discussion (Misc queries) | |||
| How do I create a For loop within a For loop? | Excel Programming | |||
| For/Loop skipping one value in loop only | Excel Programming | |||
| Worksheet_Change - loop within a loop | Excel Programming | |||
| HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
Linear Mode
