Hi all,
I am trying to make a formula which will use values off of over 40 different sheets in the same workbook. I have made the SheetName macro and wish to use the name that this macro gives me inside other functions such as:
Example:
SheetName(1) = Sheet1
COUNTIF(SheetName(1)!A1:A250,crtieria)
This returns an error. Can anyone help me solve this issue? The major problem here is the name of each sheet will differ on a regular basis as this is for a weekly report generation.
Thank you
Re: Using SheetName macro inside a COUNTIF function
Hi,
use the & operator to concatenate the strings …
Could you give me an example it doesn't seem to work. I have tried to concatenate the strings within the COUNTIF and it still gives me an error message for the formula.
Last edited by Pi_Tremb; 11-19-2022 at 04:23 PM.
Re: Using SheetName macro inside a COUNTIF function
"text1" & "text2" like explained in VBA help …
I have tried and it still does not work the COUNTIF does not recognize the input.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks