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?
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,257
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
 

Forum statistics

Threads
1,148,030
Messages
5,744,406
Members
423,868
Latest member
Junior107

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top