Can hidden cells still be selected via range and cell?

[Granite-Granny]

I'm trying to debug some vba code I'm working on and I not 100% sure that any VBA code I write referencing hidden cells using the range and cell operators will work. Is there anything I need to know about using range or cell on hidden cells?

Cheers,

GG

[6StringJazzer]

You can reference and select hidden cells in VBA. Feel free to share the actual code (entire file is best) with a description of what you expect the code to do, and the bug you are seeing.

[Granite-Granny]

6StringJazzer,

Thanks. That was my understanding but I had a little niggling in the back of my mind that perhaps that was the reason my code was failing. However within the last 30 minutes I've just found the issue and it works well now.

This is quite a big project for me and I'm trying to go from zero to hero in VBA coding while doing this project with only a mechanical engineering background so there is a good chance I'll be back with more questions. I'm getting particularly stressed about writing data outputs to files and/or the screen in legible format but that's still a way down the road.

It's nice to know there are great forums like this around and people like you to help.
What would we have done before the net?

Cheers,

GG