Macro to copy cell value of Sheet1 to next empty cell of colum A in Sheet 2

Maybe:

Please Login or Register  to view this content.

Hi John,
Sincere thanks for your 'warp' answer : This works perfectly !

Hi John,
Sincere thanks for your 'warp' answer : This works perfectly !

You're welcome. Glad to help out, and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

John, I ran into un expected problem today. The code above worked fine yesterday but when the values in cells H33 and H39 are formula results (as is the case in my actual workbook) then the formula results are not copied to sheet2. Sorry to disturbe you again, but can you help me once more please ?

Try:

Please Login or Register  to view this content.

John, you don't need to look any longer. I found a workaround : in cells H33 and H39, I simply added the sheetname (of sheet1) to the formula (so the formula in cell H33 looks like =Sheet1!$L$33). When the above VBA code now copies this formula to Sheet2, the formula result is pasted (and not the usual #VALUE message). Hope this is helpful to other forum members too.