Range does not exist

Help
1

Hi all,
I do not understand why the range does not work. I used “C1:Cx” and x is the assigned activity that was created to count the number rows. I know that you can do C1:C10 depending on how many rows you have but I want it to count itself. Please help and thank you!
ScreenHunter_199 Apr. 26 14.51

2

Hey Danny.

You need to change the range to: “C1:C” + rowCounts.ToString

Kind regards, Anders

2 Likes
3

Wow! I was doing like “C1:C.rowCounts.ToString”. THANK YOU SO MUCH!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.