Selasa, 01 November 2011

[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!

__._,_.___
Recent Activity:
----------------------------------
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

----------------------------------
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar