refedit error
Your variable "addr" does not evaluate to a cell location.
Just guessing, but maybe if you dropped the .Text from the
variable assignment, it might work.
"Steve" wrote:
With this code I obtain a 'Method of 'Range' object '_Global' failed error:
Dim Addr As String
Dim SelRange As Range
Addr = frmImport.RefEdit1.Text
Set SelRange = Range(Addr)
This code is in a Button select event on a userform.
|