Copy paste table into new worksheet macro

Hi everyone,

I've recorded this macro in excel that copies data from one table into another on a different worksheet:

Sub CopyPasteIress()
'
' CopyPasteIress Macro
'

'
Sheets("IRESS Stock").Select
ActiveWindow.SmallScroll Down:=-231
Range("A4").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("IRESS Options").Select
Range("A5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub


However, the table data that I am copying will change, i.e. The number of columns will stay the same but the number of rows will fluctuate, hence, I would like the macro to be able to adjust accordingly.

Can anybody help me modify the code accordingly?

Thx so much in advance!

Please Login or Register  to view this content.

above 2 lines re enough to take care.. of incresing Row/Column.. if you dont left a blank row/column.. in between..
above will work fine..