Posted to microsoft.public.excel.programming

Steve

external usenet poster

Posts: 1,814

refedit error

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
To refedit, or not to refedit, that is the question.	davegb	Excel Programming	2	October 25th 06 08:19 PM
RefEdit ???	T.c.Goosen1977[_20_]	Excel Programming	0	July 3rd 06 03:06 PM
RefEdit	[email protected]	Excel Programming	3	March 13th 06 12:53 AM
RefEdit in VB6	Ben Crinion	Excel Programming	0	October 8th 04 11:00 AM
RefEdit	daMike[_2_]	Excel Programming	3	December 13th 03 07:31 PM

All times are GMT +1. The time now is 06:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us