Textbox value as sourcerange

  • Thread starter Thread starter Basta1980
  • Start date Start date
B

Basta1980

Hi

Can I use a textbox value as sourcerange? If so, how do i go about (I only
get this far);

Set SourceRange = Range(TextBox1).Value

Again many thanks

Regards
 
If Textbox1 contains a valid cell address such as A1 or $A$1 ; you can as below

Dim SourceRange as Range
Set SourceRange = Range(Cstr(TextBox1))
'Msgbox SourceRange.Address

If this post helps click Yes
 
Back
Top