including workbookname in RefEdit value doenst work with Range :-(

Hi,

Since the RefEdit control doesn't include the workbook name in de range reference, i've made a bit of code that does this. when trying to paste de range in antother sheet, it doesn't seem to work :-(.

My code is as follow:

Dim TableRange As Range
Dim TableAdress As String
Dim MyControl As Control

RelevantSheet = "UPLOAD_Organization"

TableAdress = "[" & SETTINGS.Cells(3, 12) & "]" & RefEditOrganization.Value
Set TableRange = Range(TableAdress)
TableRange.Copy Destination:=Worksheet(RelevantSheet).Range("A1:A1")

the "[" & SETTINGS.Cells(3, 12) & "]" part contains the workbook name. When combined, it looks like there's nothing wrong, but i can't get it to work :-(

Any help?

Tnx!

Hi,

This is the entire code. Is first had this (that worked :-))

Dim TableRange As Range
Dim TableAdress As String
Dim MyControl As Control

RelevantSheet = "UPLOAD_Organization"

TableAdress = RefEditOrganization.Value
Set TableRange = Range(TableAdress)
TableRange.Copy Destination:=Worksheets(RelevantSheet).Range("A1:A1")

But now when I want the workbookname in the TableAdress, it doesn't work..