PDA

View Full Version : Solved: object variable coming in lower case



kishlaya
07-02-2009, 12:39 AM
Dear all
i am facing a prbolem which seems very trivial but i am not able to find any solution for it.
i have set of code which was working fine till this morning but after that all the words which have the kewyword 'count' in them turned into lowercase.

Range(Selection, Selection.End(xlDown)).Count 'it was previosly like this with C in Caps in count
but now it is like this

Range(Selection, Selection.End(xlDown)).count

due to this all the count statements are getting skipped with the variable assigned to them becoming empty.

Also i have not declared any variable as count anywhere since it is happening in all the sheets of my workbook(around 15).

Bob Phillips
07-02-2009, 01:14 AM
Dimension a variable called Count in your procedure, like so



Dim Count As Long


You should see all you instances of count upshift. Then just delete the line you added.

kishlaya
07-02-2009, 01:41 AM
Dear XLD
thanks a billion for your help. you have been a life saver so many times for me!:beerchug:
Regards,
Kishlaya