Problem using variable name

[Scott JS]

In attempting to write an VBA marco in excel, both of the two pieces of code below return

Run-time error ‘1004’:
Method “Range” of object “_Global” failed

With the second line of code highlighted.

First attempt

    finalrow = Range("G65536").End(xlUp).Row
    Range("H & finalrow").Select

Second attempt

    finalrow = Range("G65536").End(xlUp).Row
    Range("H” & “finalrow").Select

I have "dim'ed" finalrow as an integer. What am I doing wrong?

 

[Scott JS]

I'll try, not sure what you mean by posting data.

i have a spreadsheet with about 20 columns. Need all of the data -- but for the most part, don't need to see to big sections -- columns B-F and H-R
So, I have grouped these so that they can be hidden most of the time.

I am copying subsets of a very large spreadsheet into a similarly structured file, change the name for that recipient, hide the grouped columns and save.

Because I have so many of these to do, I thought it would be simple to automate the copy from one workbook to another, then hide the grouped columns.

Range("B1:F1").Select
    ExecuteExcel4Macro "SHOW.DETAIL(2,6,FALSE,,1)"
    ActiveCell.Offset(0, 6).Range("A1:K1").Select
    ExecuteExcel4Macro "SHOW.DETAIL(2,18,FALSE,,7)"

The intended function is really independednt of whether there is even any data in the affected columns. Just trying to automate the hiding of an already grouped set of columns.