Macro to Change sign of values in Col C

[Howardc1001]

I have tried to write code to change positive values to negatives and vice versa in Col C36:C50


However when running the macro, I get a run time error "Type mismatch"

Please Login or Register  to view this content.

[Artik]

If you want to multiply each cell in a range, you need to loop each of them separately.
But...
Assuming A1 is always empty (you don't use it):

Please Login or Register  to view this content.

Artik

[Greg M]

Hi there,

See if the following version of your code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[Marc L]

Or with Excel basics in a single codeline : [Recon!C36:C50] = [IF(ISNUMBER(Recon!C36:C50),-Recon!C36:C50,Recon!C36:C50)] …

[kvsrinivasamurthy]

Try this

Please Login or Register  to view this content.

[Howardc1001]

Hi Guys


Thanks for all your input


the code provided works perfectly

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M