Dim worksheet name issue

[SMILE]

Hello Team
I have a worksheet name called "ROW DATA"
When I declare Dim ROW DATA as worksheet, I am getting error and I know it is because I have two words in my sheet name. How can I declare the DIM if I have more than one word in the sheet name.
Please help me
Thanks

[Olly]

You seem to be confusing the variable name with the worksheet name.

You can name your variable anything you like, but it may not contain a space.

Please Login or Register  to view this content.

Alternatively, change the worksheet codename (again, without using spaces) then you can reference that object directly.

[TMS]

Maybe like this:

Please Login or Register  to view this content.

Then refer to RowData in your code.