Set range still shows nothing

**whiteheadw** · 08-18-2009, 06:22 PM

Hi All,

I have the following code:

Please Login or Register  to view this content.

Here is my debug:

Sheet1
sheet1.therowstart: 3
colindex: 17
rowcount: 3
value:
3
17

My issue is that somehow, even though I'm telling Excel to go to cells(3,17) on the active sheet (wsheet), it's not seeing a value (or much less anything else). Consequently, I am unable to identify a range.

I can't even add cells(1,1).select to my code without getting a 1004 error.

Does anyone have any idea what might be causing this and how I can go about fixing it?

Thanks.

Regards,

William

**romperstomper** · 08-18-2009, 06:28 PM

If your code is located in a worksheet code module rather than a normal module, then any reference to Cells or Range that is not explicitly qualified with a worksheet object will refer to the sheet containing the code. (Since that is not the active sheet, you cannot select a cell that way.) You need to use:

Please Login or Register  to view this content.

for example (or a With...End With block for neatness)

**whiteheadw** · 08-18-2009, 07:18 PM

Perfect.

Thank you.

Regards,

William

Set range still shows nothing

LinkBack

Thread Tools

Rate This Thread

Display

Set range still shows nothing

Re: Set range still shows nothing

Re: Set range still shows nothing

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions