View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Archie Archie is offline
external usenet poster
 
Posts: 10
Default cant seem to get a function to reference a variable cell?

I want to ask a user to choose a column (eg input "E", for column E) and then
use this in a function in VB

eg to concatenate two cells A3 and E3, but I want the user to choose, say,
"E".

I can get the input but cant seem to get a function to reference a variable
cell?

Thanks