DeepaB

0

votes
0

answer
5

views

PasteSpecial method of Range class failed in for loop

Writing macros to copy cells in a different workbook in a specific format.Getting error at different lines everytime I run the code I tried with unhide cells, selection `For i = 1 To lastrow If IsEmpty(ThisWorkbook.Sheets('Summary').Range('A' & i).Value) = False Then If ThisWorkbook.Sheets('Summary'...
DeepaB