Create formula using VBA

  • Thread starter Thread starter medirate
  • Start date Start date
M

medirate

In worksheet One, starting with A3, I have 10 columns and 10 rows full of
number data. Using VBA, I would like to go to worksheet Two, column A, Row
3, and enter the following: Concatenate (One!A3," ",One!A4," ",One!A5) and
copy this formula (relatively) from A3 through A12.



Can someone tell me how this is done or point me in the right direction?



Thanks!
 
Worksheets("Two").Range("A3:A12").Formula = _
"=One!A3&"" ""&One!A4&"" ""&One!A5"

- Jon
 
Maybe

Sub sonic()
Sheets("Sheet2").Range("A3").Formula = _
"=Sheet1!A3 &"" ""& Sheet1!A4 & "" ""&Sheet1!A5"
Sheets("Sheet2").Range("A3").AutoFill Destination:=Range("A3:A12")
End Sub

Mike
 

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

Which zones are touch given this range 2
Formula Array Help in VBA 3
Look at numbers between 2 numbers and copy the complete rows to a worksheet. 2
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Indirect and offset 4
Preventing Duplicate Records 2
Need to add values...maybe 13
Controlling cursor w/ macro 4

Back
Top