VBA loop

  • Thread starter Thread starter JohnUK
  • Start date Start date
J

JohnUK

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
 
Cells(Rows.Count,"A").End(xlup).Offset(1,0).Value = Range("B1").Value

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Looping 3
Problem with a loop and column references 27
comparing two columns in vba 2
Loop from left to the right 5
Counting Criteria Values with For Loop 3
Loop 1

Back
Top