I am using dropbox, please click on the following link
https://dl.dropbox.com/u/84586105/VariousNotes.xlsm
this file is just a file where i was testing it, so don't look for logic to what I'm trying to do.
Okay, I downloaded the file, but I don't see numbers in Columns B, I or P that should be changed. Your original post said "so let's say Columns B, I, and P should always turn to negative", hence, I set the code to process those columns. I said as much in my message when I told you "
Change the two Const statements to reflect your actual setup (I set StartRow equal to 2 assuming headers,
the Cols were set as per your example).
Note that Cols is a space delimited string of column letters." This is the statement controlling which columns will have their numbers converted to negative values...
Const Cols As String = "B I P"
Just change the letters B, I, P to whichever column letters you actually want to process (you can put in one, two, three, four, or as many column letters as you have need to chang.