Date and Data

  • Thread starter Thread starter Wayne Burritt
  • Start date Start date
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
 
Hi
maybe
Range("C3").End(xlDown).Offset(1, 0).Value = _
worksheets("Trades").Range("B217").Value
 
Back
Top