Current cell position for a non Active worksheet

**Wizz** · 12-15-2009, 06:26 PM

Hi,
I need the cell address where the cursor is (in a non active worksheet).

Every help appreciated.

Thanks

**rwgrietveld** · 12-15-2009, 06:33 PM

Every sheet has it's own selection (cursor position). When Sheet1 is active, Sheet2 still (also) has a cursor position.

Each TAB (Sheet) has its cursor position (selection)

To find these

Please Login or Register  to view this content.

**Wizz** · 12-15-2009, 06:40 PM

Gracias Ricardo,
Is there any way to get that address without activating the sheet?
I have a procedure perform some tasks in a specific worksheet. The problem is that that procedure is called from any worksheet. I would like to perform the complete procedure without having to switch sheets. Every sheet has some onActivate procedures.

Thanks again

**broro183** · 12-15-2009, 06:43 PM

hi,

Here's a link to another thread with examples that are similar to Ricardo's one, & also has some discussion.
http://www.eggheadcafe.com/software/...cted-rang.aspx

Edit: Note Dave's use of ".enableevents = false"

hth
Rob

**Wizz** · 12-15-2009, 08:01 PM

Thanks a lot Ricardo and Rob,
Unfortunately there is no single command or code line for that matter.

Thanks again.

**broro183** · 12-15-2009, 08:40 PM

Yep, I thought it was an interesting question & had a brief look in VBE's Object Browser before Googling for an answer. I'm surprised that shorter code/a single command doesn't seem to exist, but at least with the enable events & screen updating turned off, there shouldn't be much impact.

If you're happy with our suggestions can you please mark the post as Solved?

Thanks
Rob