Date and Data

W

Wayne Burritt

Hi: I was given the following code that works great adding today's date and
the value in D2. It adds to a progressive list. The problem now is that D2
no longer contains the data I want to list. Rather the data is now at
another sheet called "Trades" at cell B217. Can anyone help?

Thanks, Wayne

Range("B3").End(xlDown).Offset(1, 0).Value = Date
Range("C3").End(xlDown).Offset(1, 0).Value = Range("D2").Value
 
F

Frank Kabel

Hi
maybe
Range("C3").End(xlDown).Offset(1, 0).Value = _
worksheets("Trades").Range("B217").Value
 

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

Complex date VBA - insert a certain weekday 8
Event recognition. 11
Horizontal and Vertical lookup 2
If cancel list box don't enter FALSE in list 2
Conditional If/Else statement 2
Mapping integers to strings 6
Ambiguous name detected: worksheet_change 2
Saving a range for later reference 0

Top