I need to copy a completely dynamic range in excel. Meaning the rows and columns will be different each time. Please note that the columns will change so I can't use something like range("M" & rowstart & ":" & "O" & rowend).copy. I've seen a lot of examples like this but the columns are static and I need them to be able to change.
Here is what I'm currently using but I get an error:
MySheet.Range(MySheet.Cells(FirstCopyRow, columnpointer1), MySheet.Cells(RowPointer1 - 1, columnpointer1 + 6)).Copy
This doesn't work.