Copy values only

[rossp1977]

Hi,

Am new to the forum and just need some help with this coding please.

At present I have a Data Input sheet, then info copies over onto various other sheets using this VBA coding (this is just a section of it)

Please Login or Register  to view this content.

This all works spot on, but I also have a version where the data entry is links to other workbooks, so the data is not just simple text and numbers.

Can anyone please suggest an amend to the above that would copy values only?

My problem is this part...

Please Login or Register  to view this content.

Doesn’t ever include .paste so I haven’t got anything to simply replace with .pastespecial xlpastevalues, otherwise it would be fairly simple.

Any suggestions – think it’s this line that is performing the "pasting" function - Sheets("data input").Rows(Cell.Row).Copy Sheets("Niche Floor").Rows(iMatches3)

Thanks in advance,

Ross

Moderator Note:

Pls use code tags around your code next time as per forum rules.

[AB33]

Please use code tags with your code as per forum's rule

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

[rossp1977]

Many thanks for this and apologies for the lack of code tags - totally new to the forum and didn't know how to do that (do now though cheers)

This looks like should work, but the End If function now doesn't seem to work so just loops continuously?

Please Login or Register  to view this content.

Any further suggestions to resolve this issue?

Cheers

[rossp1977]

Actually from using F8, it appears to loop once it's gets to the second Next, and goes back to the If (Len.....) line, so this is the section that loops: -

Please Login or Register  to view this content.

[AB33]

If you mean to exit the sub if row B is empty.

Please Login or Register  to view this content.

[AB33]

Or use this line.

Please Login or Register  to view this content.

[rossp1977]

Brilliant - think got it all sorted.

Many thanks for your help AB33