REALLY Basic question on variable syntax...

Obviously I'm a newbie, so I'd appreciate learning how I'm messing up this code:

Please Login or Register  to view this content.

I'm simply trying to delete anything in the rows from the end of my last data through row 201. I keep getting a Type mismatch error on the last row. I assume I'm not entering the variable myRow correctly - maybe I'm missing some apostrophy's or quotation marks???

Man I hate being dumb at something!

Thanks in advance!

Mike

Mike,

Welcome to the forum! In the future, please wrap your code in code tags, link in my sig for how.
As for your question, "myRow:201" is a string. To use the variable, you need to concatenate it to the ":201" using the & symbol:

Please Login or Register  to view this content.