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).
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).