Hi
I'm really struggling with an earlier macro and not understanding why macro is not working, so will have to create a workaround.
I need to apply a countif formula to count the number of blank rows in a range B16 to B22 and return the count in cell B1 in each worksheet. There will be numerous worksheets in each workbook.
Is this easy to do?
many thanks
Gary
Last edited by WeeG; 10-31-2012 at 09:57 AM.
You can do this manually or you can do this via macro.
If you want to do it manually, do the following -
Select all the sheets in your file. While keeping them selected, enter this formula in B1Formula:
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
thanks, how would i input the code if i wanted it inserted into a macro?
thanks
Gary
Here you go -
Put it in a standard module.
Please Login or Register to view this content.
Last edited by arlu1201; 10-31-2012 at 08:07 AM.
Hi
thanks for this.
I did get an error - run time error 438 - object doesn't supprt this property or method.
with this line
Worksheets(i).Range("B1").FormulaR1C1 "=COUNTBLANK(R[15]C:R[21]C)"
I also did give the wrong info, the countblank rows result should be in cell B1, but the range that should be used is H16:H22.
Thanks
Gary
There was a small typo in my code above which i corrected now. But considering your change in columns, here is the updated code
Please Login or Register to view this content.
thanks, this is working great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks