Copy/Pasting Concatenated Value

[keeper10]

Hi all,

Ok, so I have two worksheets(index and master). When the user inputs data, the program creates a unique PR number automatically that has 3 letters, then 5 numbers. (eg. STL39849). I did this by concactenating two other cells. I want to copy and paste this PR number so I can paste it in another area, but a simple copy and pastespecial does not work for the result of a concatenated value. Just to reiterate, the PR number is a value created by concatenating two cells. I want to take this value and paste it in another location. Any help is appreciated!

 

[Chris Mack]

Are you using VBA? How come it doesn't work?

 

[keeper10]

I recieve an error message that says the copy/paste area isn't the same. I am unsure why I am receiving this though.

 

[Chris Mack]

My guess is that it's something to do with merged cells?

 

[burns14hs]

Like Chris said above, I have VBA that throws this error when I have merged cells, I added extra lines to unmerge and remerge afterwards... I also have another report that copies/pastes values just in the same place to save the worksheet from having a million formulas constantly calculating. That report will throw that copy/paste area error if I have accidentally left the worksheet filtered...

 

[keeper10]

I fixed that error, however, when it pastes the concatenated cell, it will only paste the number. For example, it should copy "STL99999" and paste it. Instead it just pastes "99999". This is the problem I have been running into. I can't get it to paste the entire thing instead of just the numbers.

 

[keeper10]

I figured the error (if that's what you would call it). I was using .PasteSpecial xlPasteValues. Instead of using this function I used the .Insert function. It will allow you to take the entire value, letters and numbers, and put it where you need it to go.