Thread: Macro Prob
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franz Verga Franz Verga is offline
external usenet poster
 
Posts: 459
Default Macro Prob

carl wrote:
I am experimenting and trying to learn how the code works. I have the
code below. It gets hung on S = "=" & Range(i).Value.

[cut]

If (but not sure...) I well understand, you should solve this way:

S = Range(i).Value

or if you want concatenate the values in G6 and G7

S = S & Range(i).Value

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy