Move cell based on contents (VBA)

**BaronDJB** · 09-02-2010, 10:26 AM

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.

**sweep** · 09-02-2010, 11:24 AM

Hi,

Please edit your post to include code tags.

Please Login or Register  to view this content.

**BaronDJB** · 09-02-2010, 11:36 AM

Many thanks for your help, being new to VBA and learning on the hoof isn't the best combination!

**ghynes** · 12-21-2014, 10:37 AM

hello. i am trying to use this code, but using : instead of ,.. but its not recognizing the : because its reading the cell as text format. anyone help?

**Pepe Le Mokko** · 12-21-2014, 10:42 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.