Macro question

Hi,

I'm building a macro that performs many tasks. One of the functions will place a number in column I depending on what is in column H. It will then cut the value out of column I and paste it on top of value H.

The problem is that a situation may come up where there is no value to be changed. Column H would be correct and no value would place in column I. There would be nothing in column I to cut and paste into column H.

How do I get it to cut the data out of column I and place it column H only if there is something in column I?

I hope I have I explained myself correctly. Let me know if there is anything I can do make it more clear.

Eddie.

Hi,

By starting your macro with a test (IF) on column I which will then trigger your two possibilities ...

HTH
Carim

Thank you so much for your quick reply.

I have been trying various forms of "if" to get it to work but I can't seem to gtet it right. Below is the VBA text that cuts data out of the column I and pastes it into column H. How does this data have to read so it will only cut something out of column I if there is a value in it (not blank)?

Range("I2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Cut
Range("G2").Select
ActiveSheet.Paste

Any thoughts are most welcome.

Eddie

Hi,

Please Login or Register  to view this content.

HTH
Carim

That worked great. Thank you so much.

Eddie.

Glad your problem's fixed

Thanks for the feedback

Carim