Posted to microsoft.public.excel.programming

Steve[_4_] Steve[_4_] is offline

external usenet poster

Posts: 184

ActiveSheet in formula

Hi All,

I have the following formula in vba:

..Formula = "=COUNTIFS('[" & strName & "]Sheet1'!$E:$E,A2,'[" & strName & "]Sheet1'!$H:$H,""0"")"

The file I am referencing via the variable strName only has one sheet...but what I am finding is that the sheet name is not always Sheet1. How can I modify the formula to select the only sheet in the workbook?

Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vba Formula To Include Activesheet Name	LuisE	Excel Programming	3	March 25th 09 02:57 AM
Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect?	Jim K.	Excel Programming	2	June 2nd 08 08:09 PM
Copying new activesheet after other activesheet is hidden?	Simon Lloyd[_790_]	Excel Programming	1	June 20th 06 10:02 AM
activesheet	Jim at Eagle	Excel Programming	1	April 6th 05 12:21 AM
ActiveSheet	Ron de Bruin	Excel Programming	0	July 29th 03 04:59 PM

All times are GMT +1. The time now is 05:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us