Hi All,
I'm trying to use VBA to move a cell one column to the right if it contains a comma, below is the code I'm using.
My problem is that the code only looks to see if the whole cell value is a comma - I need it to work even if there is other text in the cell with the comma; I tried putting an asterisk either side of the comma in the code but it flagged an error...
Any tips would be appreciated, I'm probably missing something really basic!
Please Login or Register to view this content.
Bookmarks