Thread: [SOLVED] Select Range with Starting Cell Unknown

I am trying to record a macro that will allow me to select from whatever cell is active at the time of running the macro to BR2. I am then copying the information selected and pasting it into a new spreadsheet. If it is not possible to record a macro this way, then can I edit the macro to allow me to do so?

This is what I have recorded already...

Code:

    Range("BR2:EL17").Select
    Range("EL17").Activate
    Selection.Copy
    Windows("FTH_RunningSpreadsheetCHS.xls").Activate
    Range("A2").Select
    ActiveSheet.Paste
End Sub

EL17 is not important, it will always be in column EL, but there will always be a different number of rows I need to copy. I know I could just set it to copy from EL500 or something like that because I would never have that many rows; however, I do not want to copy excess information and then go back and delete.

Hope this makes sense and I'm sorry if this is a repeat question, I looked for a while first and couldn't find an exact answer to this.

As Stephen requested, please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

Your question is fine. You need to add CODE tags around your code. The way to do that is described in both the forum rules, and in the How To, both accessible from the menu bar.

Thank you. Try

Code:

    Range(ActiveCell, "BR2").Copy _
            Destination:=Workbooks("FTH_RunningSpreadsheetCHS.xls").Range("A2")

Sorry, you also need to specify the worksheet:

Code:

 Range(ActiveCell, "BR2").Copy _
            Destination:=Workbooks("FTH_RunningSpreadsheetCHS.xls").Worksheets("???").Range("A2")

Perhaps ...

Code:

    With Workbooks("FTH_RunningSpreadsheetCHS.xls").Worksheets("???")
        Range(ActiveCell, "BR2").Copy _
        Destination:=.Cells(.Rows.Count, "A").End(xlUp)(2)
    End With