Referencing cell contents giving incorrect result.

[pongmeister]

I am trying to reference a cell on the active worksheet and I know the cell has a value of 10 but when I single step thru in VBA and hover over the cell name (BS3) It displays 'empty'.

Don't know how that can happen please see attachment. Not sure If I'm referring to the cell correctly. I tried referencing the cell as R3C71 also but got the same result.

Thanks for any help or ideas

[TMS]

Look at the difference between the Select and the If. BS3 refers to an undefined variable, not the Range("BS3")


Regards, TMS

[FDibbins]

If you already have the workbook, why not upload a sample of that, rather than (maybe?) a pic in a word document?

[pongmeister]

Actually, this was simpler since my workbook is way to large to load to the forum and I'd need to cut it down in size, which I can do if necessary but I believe TMS has given the solution. If not I will take your advice and cut down the size and number of worksheets and send that in.

Thanks

[pongmeister]

Thanks for the heads up, I made the change per your advice and it works perfectly. I will close the thread now.

[TMS]

You're welcome. Thanks for the rep.