I found a bunch of functions in the User Defined Function section of the Function wizard.
One is
IsSheetEmpty()
thinking it might be useful, I experimented...and fell flat.
I can't find any info about the argument needed.
I looked in VB Editor but found no code.
Google provided several VBA approaches but the function in my workbooks is a mystery.
Can anybody help me to find the code for this UDF (I didn't code it)
This is a little puzzle, because typically a UDF creates a function you use IN a cell. But if you put a function IN a cell to somehow test if the sheet is empty, wouldn't it ALWAYS answer "not empty" because of the cell you put the IsSheetEmpty() function into?
Sort of catch-22.
Now, if you want a normal MACRO you can run to determine if a worksheet is empty, that makes more sense to me.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hi My911,
No Code in the modules ?
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
JBeaucaires Excel Files
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks