Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT JT is offline
external usenet poster
 
Posts: 234
Default refedit column

Is there an easy way to extract the column (letter or number) from the value
that gets populated in a RefEdit? Thanks......
--
JT
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default refedit column

Range(RefEdit1.Value).Column

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"JT" wrote in message
...
Is there an easy way to extract the column (letter or number) from the
value
that gets populated in a RefEdit? Thanks......
--
JT



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default refedit column

Range(refedit.value).column

--
Regards,
Tom Ogilvy


"JT" wrote:

Is there an easy way to extract the column (letter or number) from the value
that gets populated in a RefEdit? Thanks......
--
JT

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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[_21_] Excel Programming 0 July 3rd 06 03:11 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 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"