Paste Value Macro Yielding Blank Cells

[bdr2831]

Hello,

So I have been working on a paste value macro and when I run it, every cell has the correctly pasted values except for one row. I have since isolated it to just writing a paste value macro for just that one row and it still comes up blank. Here is what I have written (It copies from one sheet to another in the same workbook):

Please Login or Register  to view this content.

Any ideas? Thanks.

[TMS]

The code looks ok, if not the most efficient.

Maybe you'd care to upload a sample workbook

Regards, TMS

[Leith Ross]

Hello bdr2831,

Welcome to the Forum!

The PasteSpecial method does not check for blank cells, rows, or columns before pasting. You would have to do this check your self before pasting to the destination.

[bdr2831]

@Leith Ross, the cells are blank before I paste into them - it is just that when I run the macro, the cells remain blank that is giving me issues.

[Leith Ross]

Hello bdr2831,

Try this...

Please Login or Register  to view this content.

[bdr2831]

hmm that's just giving me a syntax error.

also @TMS, it does work when I move it to another sheet, I however, cannot upload the document I am working on that's having this problem.

Thanks for your replies.

[TMS]

Do you have any hidden columns?

[bdr2831]

I just noticed that there are hidden columns...does this have an effect?

[TMS]

Well, the copied cells will go into the columns regardless of whether or not they are hidden. So the data may have been copied, just not visible.

[bdr2831]

Well, I did check those columns in case that was happening, then re-hid the columns and tried it again and it worked...

Thanks for your help!

[TMS]

You're welcome.




If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.