Complie Error: Expected: list separator or (
Hi Friends,
I am novice to VBA macros, Can anyone help me to correct this Complie error: Expected: list separator or ( while running below code.
workbooks("SKU Status Tracker.xls").Sheets("Sheet1).range("I" & SKUOutputrc+1).select
Selection.NumberFormat = "@"
I want to select a particular Cell (Range ("I" & x) ) from a sheet and change its formart to text.
Can anyone help me out...
Add the missing double quotes after Sheet1 in this line
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hey thanks for your reply, after adding missing double quote also I am not able to change the format of particular cell to "Text".
What text do you have in the cell?
You have 2 lines of code which can be reduced to 1 line -Please Login or Register to view this content.
thanks a lot ya. :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks