Adding character to multiple active cells VBA

[jamezsez]

Hi All,

I am having trouble getting a very simple task done in Excel.

I have a massive amount of data (176,000 lines worth) and I need to add a "-" character to certain cells throughout the list. I can select (activate) the cells using filtering, but there is no way (that I have found) where I can add the character to all. I am unable to paste due to the filtering, and there are too many cells to do it one by one.

I am thinking VBA might be the way to go.

I am fairly new to VBA but I was thinking the code is something along the lines of,

Active.Cells
Add "-"

Loop...

*shrug*


Your help is much appreciated.

[TMS]

When you say "add" a minus sign, where ... start, middle, end? What determines which cells need updating? A sample workbook would be helpful.

Regards, TMS