VBA Code Option based on data in a cell

[MHamid]

Hello,

I was wondering if there is a way to write a code stating that if there is data in a certain cell use this code, but if there is not a data in that certain cell use this other code.

For instance, I have data that should be in 7 column. Sometimes the data being copied is lumped in one column and I would have to use text to column to split it up into the 7 column. Other times the data being copied is copied correctly into the 7 columns.

So, pretty much if there is data in B1, use the following code:

Please Login or Register  to view this content.

If there is no data in cell B1, then use the following code:

Please Login or Register  to view this content.

Any help will be appreciated.


Thank you,
Miriam

[MHamid]

Just updated the title ... Does that comply witht the rules?

[jasoncw]

Hi MHamid,

That is an easy enough request:

Please Login or Register  to view this content.

Jason

[MHamid]

Yes!! That worked perfectly.

Thank you!!

[jasoncw]

You're welcome. By the way, try to get out of the habit of selecting cells in your code. I know this was a result of recording the macros, but here is an example of what you can change it to. It will be much more efficient:

Please Login or Register  to view this content.

Please Login or Register  to view this content.