Select all existing data

[RebeccaMorgan]

Hello,

I'm trying to write a macro that selects all data from one sheet and uses that same data in a formula on a separate sheet. Below is my issue. Instead of defining a certain area, I would like the macro to fill all the way right then all the way down within a formula.

Sub Breakout()
'
' Breakout Macro
'

'
Rows("1:1").Select
Selection.Copy
Sheets("EFT").Select
Range("A1").Select
ActiveSheet.Paste
Sheets("Payment").Select
Range("A1").Select
ActiveSheet.Paste
Sheets("EFT").Select
Range("A2").Select
Application.CutCopyMode = False
ActiveCell.Formula2R1C1 = _
"=FILTER(Sheet1!R2C1:R96C10,Sheet1!RC[7]:R[1000]C[7]=""EFT"","""")"

[Jacc]

I don't understand but I'm guessing you need something like:
ActiveCell.CurrentRegion.Select


If you want a better answer you need to post a workbook.