Thread: [Solved] Need Help with Current Macro
View Single Post
 
Old 10-28-2018, 05:41 AM
rsrasc rsrasc is offline Windows 10 Office 2013
Competent Performer
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default

Hi p45cal,

Your observation is well taken.

I'm sure your macro will help me somehow in the future.

Code:
If Cell.Value > 0 Then Cell.Value = Cell.Value * -1
Since I was playing with the macro, I also realized I can change from negative to positive by inverting the greater (>) than sign to less than sign (<).

You guys are amazing.

Thank you for your support.

Much appreciated

Regards,
rsrasc
Reply With Quote