activecell

Bugs

Board Regular
Joined
Aug 21, 2002
Messages
100
I need some code that will give me the contents of a active cell on a hidden sheet
without activating the sheet
Is this possible?
Can you help?
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,222
My understanding of ActiveCell is that it cannot be used for a particular worksheet; it is a property defined for the Application and Window objects. If you want to determine the active cell contents for a given sheet, you must first make that worksheet active in the current window. If there is no worksheet displayed in the active window for the application object, ActiveCell would return nothing.
 

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
You could try something like this:

Dim Info as Whatever
Info = Sheets("Hidden Sheet").ActiveCell

Is that what you were looking for? If not, will you offer a bit more information?
 

yosi

Board Regular
Joined
May 14, 2002
Messages
67
i understand that you mean contents of a cell in hidden sheet
apply name to the cell before hiding the sheet than you don't need to unhide the sheet, insert the name you apply to a formula.

_________________
This message was edited by yosi on 2002-09-15 01:54
 

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,004
Members
412,304
Latest member
citrus
Top