Copy range using paste special

[Shaun1978]

Hi All, I am new user to this forum and have limited VBA knowledge so hopefully help is out there for me.

I have created a code to copy data to a new sheet and clear the contents from selected cells but when this copies it takes across the formula and not the cells contents. Also, I can't seem to get the cells to move to the next available row in the new sheet.

Attached is the spreadsheet and code.



Thanks in adavance for any assistance given.

[patel45]

I did not understand what you want

[Shaun1978]

Hi,

Sorry I realise my explanation is not very clear.

from teh scorecard sheet I can copy the following into the leaderboard sheet, players name (B4), Tee by type (B6) & Handicap (B8) these paste into cells A14, C14 & D14, I then want to copy across the net scores from B17:X17 & paste these into E14:AB14. The copy code works but takes across the formuala and not the value of the cell, I know this will need to a paste special but I can not seem to get this to work.

The next step is get the players name, handicap and nett scores etc...to automaically enter the next available empty row on the leaderboard

[AB33]

Please Login or Register  to view this content.

[Shaun1978]

Hi AB33,

Thank you for the solution to the paste value issue, could you advise on how I can paste the next set of scores to the next available row on the leaderboard.

[AB33]

Use this line to find the next empty cell in column B

Please Login or Register  to view this content.

[Shaun1978]

Hi,

Can this code be modified to find the next empty row in column A and then paste contents as above. I tried the code provided but this still copies into the range E14 etc...

[AB33]

LEADERBOARD and Leaderboard are not the same sheet

Please Login or Register  to view this content.

[AB33]

If you want to copy in to next empty cell in column E

Please Login or Register  to view this content.