I've got what I expect is a simple question, but I'm still getting to grips with learning VBA. What I want to do is copy cell values in Sheet1 (H3:H42) and paste (transpose) to the next empty row in Sheet 2 starting from column C.
In its current form my macro will just find the next empty row and paste the values starting in column A, could anyone tell me what I would have to modify in order to paste the values starting from column C?
Please Login or Register to view this content.
Bookmarks