Problem with the range format

[dwg83]

I am hoping someone can help me identify what is wrong with using this line in my code:


FrontPage.Range(Cells(UtilityRow, 50), Cells(UtilityRow, 64)).Select

FrontPage is defined as a worksheet
UtilityRow is defined as an integer defining which row my utility is on

Thanks!
David

 

[VoG]

You need to fully qualify the range

Application.Goto FrontPage.Range(FrontPage.Cells(UtilityRow, 50),FrontPage.Cells(UtilityRow, 64))

 

[dwg83]

With that Goto command, will my focus now be set on that worksheet, or will the active sheet remain the same?

 

[dwg83]

Perhaps I can do this a different way...I am just trying to copy some formulas saved on a "repository" sheet to my active sheet. Does the code below do it the most efficient way?

Thanks!

        'Imports Formulas
        FrontPage.Range(Cells(UtilityRow, 50), Cells(UtilityRow, 64)).Select
        Selection.Copy
        Range("AC10").Select
        Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False

 

[VoG]

try

FrontPage.Range(Cells(FrontPage.UtilityRow, 50), FrontPage.Cells(UtilityRow, 64)).Copy
Range("AC10").PasteSpecial Paste:=xlPasteFormulas

 

[dwg83]

I tried your last suggestion (without the "goto" statement) and the error that occurs (I think it's the same error) is:

Method 'Range' of object '_Worksheet' failed

 

[dwg83]

Fixed! In the code you provided, the second "FrontPage." should have been in front of "Cells" rather than UtilityRow. Thanks for your help!

FrontPage.Range(FrontPage.Cells(UtilityRow, 50), FrontPage.Cells(UtilityRow, 64)).Copy
Range("AC10").PasteSpecial Paste:=xlPasteFormulas