Hi

I have 2 monitors and would like to open 2 separate excel instances, so I can display the two on separate monitors
right now the code just opens the workbook and can't separate them.

any help would be appreciated

Thank
Keith


Private Sub CommandButton1_Click()
Dim NAMES As String
Dim BLENDA As Workbook

Worksheets("NAMES").Select
NAMES = Range("C4:C35").Select

Set CHARTB = Workbooks.Open("C:\Users\RAM\Desktop\TEST\CHARTB.xlsm")
Worksheets("NAMES").Select
Worksheets("NAMES").Range("a3").Select
RowCount = Worksheets("NAMES").Range("a3").CurrentRegion.Rows.Count
With Worksheets("NAMES").Range("a1")
.Offset(RowCount, 3) = NAMES
End With

End Sub