Copy value after If

[uniks]

I have number 1 to 10 in Column A and name in Column B. What I am trying to accomplish is to check the name in cell B2, if empty then it will copy the number from cell A2 to cell H2. But if cell B2 already contains a name then it will copy the number from cell A3 to cell H2 and so on.
here is my code

Please Login or Register  to view this content.

Thanks

[dlow]

Hi,

You didnt say what doesnt work or what line is giving you trouble. But if I assume correctly try this:

Please Login or Register  to view this content.

[uniks]

here is the code that didn't work, it's just show blank

Please Login or Register  to view this content.

[dlow]

That code does work, so... Its not working the way you expected.
Maybe we should have a look @ what you’re doing. I think what you might be getting hung-up on is the Range.Offset Property (Excel).

So if we look @ this over simplified example:

Please Login or Register  to view this content.

We can see how the .Offset Property works. I.E. .Offset(Row, Column).Activate

What am I saying: it looks like from the code you provided you want to copy data from Col B of some row to H. Well like I said your code does that, & if you’re not see the result you want there is no data in ColB to copy over to H & thats why it looks to you as if nothing is happening, but non the less it is working.

What I do to make sure what I want is happening is I might add a select just while testing like this:

Please Login or Register  to view this content.

Now you see what range you are pointing to. Once you get that worked out now you can replace .select with the .copy Method

[dlow]

Thanks for the Rep Point. Glad you got it work out.