I am trying to establish the length of a cell in vba

So if one would like to find the length of A1

then len(A1)

however in VBA dont think I can use worksheetfunction.len,

any ideas, many thks


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=563705

Actually very easy, no probs, thks


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=563705

Hi,

if you use

Len(Range("A1"))

This will give you the character length of the entry in that cell.

HTH
DS

"T De Villiers" wrote:


I am trying to establish the length of a cell in vba

So if one would like to find the length of A1

then len(A1)

however in VBA dont think I can use worksheetfunction.len,

any ideas, many thks


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=563705

Hi T,

Use VBA's Len function:

Dim iLen as long

iLen = Len(Range("A1").Value)


---
Regards,
Norman



"T De Villiers"
wrote in message
news:T.De.Villiers.2batqr_1153491008.9545@excelfor um-nospam.com...

I am trying to establish the length of a cell in vba

So if one would like to find the length of A1

then len(A1)

however in VBA dont think I can use worksheetfunction.len,

any ideas, many thks


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile:
http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=563705