Getting the a string val from a Excel Range ?? Help

[WMitchellCPQ]

Hi Im new to both VB and VBA im having problems with the following.

str = Range("SheetName!RangeName&quot.Cells(2, i).Value

It seems as if the types are no the same. How can i make the value from range a string ?

Thanks in advance
W

 

[SkipVought]

Hi, W,

Convert to string CStr function

str = CStr(Range("SheetName!RangeName").Cells(2, i).Value)

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[WMitchellCPQ]

Thanks Skip that was great.

Will

 

[xlbo]

or you could just use .TEXT ;-)

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244