Thread: Input Box selects a cell location to use in code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Archie Archie is offline
external usenet poster
  
Posts: 10
Default Input Box selects a cell location to use in code
I have the following simple code:

ActiveCell.FormulaR1C1 = "=TRIM(RC[5])&RC[11]"

eg above concatenates the cells 5 & 11 columns along.

What I want is for the user, by way of an input box, to be able to choose
the columns, say 2 & 6.

Can anyone help with this please?


Reply With QuoteReply With Quote