The syntax doesn't make sense..
First:
Do you have a Sheet called "Adjustments"?
if the date in D1 is 10/1/2011,
then the value you're placing in cell B3 is ">=40817"
which really makes no sense.
Did you intend to make it a formula of some sort?
Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
________________________________
From: BarryN <brnaugle@yahoo.com>
To: ExcelVBA@yahoogroups.com
Sent: Tue, November 1, 2011 10:15:36 AM
Subject: [ExcelVBA] Assigning value to a cell
I've done this dozens of times but when I step through a function to this line
of code:
Sheets("Adjustments").cells(3,2)=">=" & D1
where D1 is a date, the yellow line disappears and the function stops.
Obvious solution but I can't see it - thanks!
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar