My first row has aheader in for the columns. I need to make a variable that counts the number of rows being used without counting the header. Any suggestions?
How are you counting the rows now? Just use that criteria and subtract 1.
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
This is what I have I called column A "PH".
PH_Count = Sheets("Input").Range("PH").count - 1
It isn't subtracting the one though.
Use this
ph_count = (Sheets("Input").Range("A" & Rows.Count).End(xlUp).Row) - 1
Cheers,
Arlette
If I 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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks