formula array gives compile error

  • Thread starter Thread starter R..VENKATARAMAN
  • Start date Start date
R

R..VENKATARAMAN

the following statements give compile error

Set rng1 = Worksheets("sheet1").Range("c1:c10")
rng1.FormulaArray="=range("a1:a10")+range("B1:B10")

what is the mistake and what is the correct statement
 
Hi,

did you mean something like this:
rng1.FormulaArray="=(a1:a10)+(B1:B10)"

regards,
Ivan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

for each question 2
Compile error 10
Find range differens between two ranges/areas? 3
Passing a range into a VBA function 4
Using Collection to also capture range adjacent 10
Tweak some code 3
Tom Ogilvy code 2
SET THEORY & VBA ? 6

Back
Top