Same principle

Windows (Range("H33").Value).Activate

--
HTH

Bob Phillips

"Steve@ABS" wrote in message
...
Thanks, that works. Now I have a similar problem switching between open
worksheets:
Windows ("H33").Activate where H33 is the name of the worksheet we
opened in K6 minus the path.

"K Dales" wrote:

Workbooks.Open FileName:=Range("K6").Value

"Steve@ABS" wrote:

I have a variable filename in a cell. The cell, K6, contains "
concatenate(K4,H4)"
I recorded a macro that opens "filename" using
Workbooks.Open FileName:= "filename"
but the filename is hard coded as the name when the macro was
recorded, not
a variable name. How do I get the macro to open the variable filename
in K6?
I am not a VB programmer.

I tried Workbooks.Open FileName:= (K6) but either it isn't the
right way
to do it or the syntax is bad.