ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   refedit column (https://www.excelbanter.com/excel-programming/393550-refedit-column.html)

JT

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

Bob Phillips

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




Tom Ogilvy

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



All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com