Hello All -

I'm a VBA beginner, and new to the boards. I've written a program in
VBA (Excel) and everything is going well...except one thing, even after
searching all over the place.
I refer to my worksheets by their codename ( as a good practice).
Excel gives me a 1004 error, "Application-defined or object-defind
error" on both of these these lines (not together in the code):

shInput.Cells(15, 2).Offset(0, varEnabledCount).Select

varNumber = shInput.Cells(18, varActiveCellCol).Value

where shInput is a sheet codename in the workbook where the module
resides, and I already used ThisWorkbook.Activate. However, this line
of code works juuust fine:

shInput.Cells(65,2).Value = 777

Furthermore, they -all- work if I have the shInput sheet activated
before I run the procedure! Why won't they work if I am looking at any
sheet while executing the procedure? Am I nuts? Is VBA broken? Am I
missing something very simple? (I really hope it's the last one).

::kicks Excel::

Thanks in advance!


--
EphesiansSix
------------------------------------------------------------------------
EphesiansSix's Profile: http://www.excelforum.com/member.php...o&userid=35721
View this thread: http://www.excelforum.com/showthread...hreadid=555046