Need Help with Current Macro

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Need Help with Current Macro

FAQ

Thread Tools

Display Modes

10-28-2018, 05:41 AM

rsrasc

Windows 10 Need Help with Current Macro

Office 2013

Competent Performer

Join Date: Mar 2014

Location: Germany

Posts: 148

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to auto-save pdf using text on page + current date	hysterical.useless	Word VBA	12	02-05-2018 02:17 PM
macro, data import from the ONLY text file in current folder	ue418	Excel Programming	5	10-28-2017 12:52 PM
a macro that can copy data from copy.xls to our current excel macro.xls based on criteria:	udhaya	Excel Programming	1	11-12-2015 10:12 AM
A macro that moves the current paragraph up or down?	New Daddy	Word VBA	2	04-13-2014 02:25 PM
Macro for moving one cell down from current position	Johnny thunder	Word VBA	3	04-07-2011 04:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:58 PM.