Paste Special

[ashani]

Hi gurus,

I'm looking to have a VBA syntax for paste special value in the following circumstances :

I would like to copy the last entry from the following columns in sheet 1 to Sheet 2

Sheet 1 : Column K to Sheet 2 B1
Sheet 1 : Column N to Sheet 2 C1
Sheet 1 : Column Q to Sheet 2 D1

Many thanks for your help.

 

[TotallyConfused]

Hello Ashani

A couple of our suggested solutions to your question have failed if the last entry in a column happens to equate to "". I couldn't see where you mentioned what your wishes were if such a situation were to happen. What action would you want - perhaps print a zero, or as JLGWhiz is attempting to do, and that is to go back up the column to the previous entry and then transfer it to Sheet #2?

TotallyConfused

 

[JLGWhiz]

@JLGWhiz - Yes, you are correct. I changed my test data and my code failed as soon as it encountered a NUL value. The NUL value being unprintable is something I hadn't considered. Thanks for bringing this to my attention.

TotallyConfused

Thought you might want to check it out.
Regards, JLG