Hi all,
I'm trying to change the value of cells in another column based off a first column which has specific text.
If cells in Column H have "Buy" I want the matching cell in Column I to turn the value negative. I know I can do a simple excel formula for this but as this will be in the middle of larger code I need it to be vba and am finding it surprisingly tricky
I have tried lots of different methods but keep getting errors. I have tried Else-If function and loops but can't get them to work. Running into issues with setting objects too. Would the formatting of the cell affect the output? I.e would the cells have to be formatted to Number for the *-1 in the code to work?
Thanks.
I'm trying to change the value of cells in another column based off a first column which has specific text.
If cells in Column H have "Buy" I want the matching cell in Column I to turn the value negative. I know I can do a simple excel formula for this but as this will be in the middle of larger code I need it to be vba and am finding it surprisingly tricky
I have tried lots of different methods but keep getting errors. I have tried Else-If function and loops but can't get them to work. Running into issues with setting objects too. Would the formatting of the cell affect the output? I.e would the cells have to be formatted to Number for the *-1 in the code to work?
Thanks.