[AccessD] Manipulating Excel Cells

On 2 Feb 2006 at 10:08, Gustav Brock wrote:

> Hi John and Stuart
> 
> But where would you need that? And if, one line of code will do:
> 
>   lngCol = 53
>   strCol = Left(wks.Columns(lngCol).Address(False, False), 1 + Sgn(lngCol \
>   27))
> 
>   strCol = "BA"
>   lngCol = wks.Columns(strCol).Column
> 

Not really one line.  You need to create  "wks" 


-- 
Stuart