Move Negative Number and Change to a Positive Number

[Alvin Hunter]

Hello All,

I am looking for a vba to attach to an existing vba. Please see text below highlighted in red.

Thanks in advance,

Alvin

Please Login or Register  to view this content.

The FillDown will bring a formula, from the cell above it and will show a resulting number.

Here is what I would like the vba to do next...

If the resulting number from the FillDown is negative, then cut and paste values one cell to the left as a positive number. If number is positive then do nothing.

[Alvin Hunter]

Well, I figured it out, Yeah! I researched every step along with trial and error. But, I'm still getting better at this the more I do it. Fun!

Please Login or Register  to view this content.

[jeffreybrown]

@Alvin,

Glad to hear you figured out your solution...

Administrative Note:

• Please see Forum Rule #3 about code tags and adjust accordingly...
• Added for you this time, but please use them in the future…Thanks.

Also, this may be of some help to you when writing macros...

Beyond Excel’s Macro Recorder

[Alvin Hunter]

Thank you Jeffrey