| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '1004' for looking up date in worksheet
Got the hint from Jim's code and it did the trick. Thanks Jim and Tom
both of you for looking into my problem. Tom Ogilvy wrote: For i = 1 To lRow If Sheets("DB").Range("A" & rCount).Value = aEmpID.Value Then aName.Value = Sheets("DB").Range("A" & lRow).Offset(0, 1).Value End If rCount = rCount + 1 Next i -- Regards, Tom Ogilvy wrote in message oups.com... Forgot to mention one thing. DB is not the active sheet. It is hidden and for some reason I want it to be hidden. My active sheet is BLANK with no data in it. I want to finish this asap. Any urgent help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-Time error '1004: Unable to get the PivotTables property of the worksheet class | Excel Programming | |||
| Run-time error 1004: Cannot shift nonblank cells off the worksheet | Excel Discussion (Misc queries) | |||
| run time error 1004 on protected worksheet when I try to run macro | Excel Programming | |||
| Run Time Error 1004 Copy method of Worksheet class failed | Excel Programming | |||
| Run Time error 1004 Paste Method of Worksheet Class Failed | Excel Programming | |||
Threaded Mode
