Easy Question

[Kavy]

I feel dumb asking this

This is on an excel user form with vb code

I used a variable i made called rowS

now i need to use the built in excel function called rows()

i am using the built in fuction in another sub, a differnt command button but it still changes my rows to rowS.

Does option explicit change this?

 

[Datsmart]

You have found out the reason to never use reserved names in your variables.
It is best to change your variable to a non-reserved name.

 

[Norie]

kavy

As John has pointed out it's a bad idea to use names that could conflict with VBA functions/properties/methods etc

Why do you need to use Rows() in VBA anyway?

 

[Kavy]

ah i don't, i didn't know it was a variable reseverd, I proably should of though... I guess its time to use find and replace, luckly all my "rowS" are variables