Hello everyone,
I'm trying to create a vba button that copies only visible cells from cell range A7 to V7 and rows below. Next, I want to paste that data onto another sheet starting from A7 and only paste it onto the next blank cell. Finally, "clear contents" of what was copied from the first sheet. When I try my macro, it bugs or pastes it weirdly. I'm new to macros, but this is what I got so far.
Sub test()
Range("A7:V7").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Sheets("TheWave").Cells(LastRow, 1).PasteSpecial xlPasteValues
End Sub
I'm trying to create a vba button that copies only visible cells from cell range A7 to V7 and rows below. Next, I want to paste that data onto another sheet starting from A7 and only paste it onto the next blank cell. Finally, "clear contents" of what was copied from the first sheet. When I try my macro, it bugs or pastes it weirdly. I'm new to macros, but this is what I got so far.
Sub test()
Range("A7:V7").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Sheets("TheWave").Cells(LastRow, 1).PasteSpecial xlPasteValues
End Sub