View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
May May is offline
external usenet poster
 
Posts: 15
Default combine information in two cells into the third column

I've been trying to write a macro as below to commit above task, but errors
like "variable not defined" and "sub or function not defined" keep poping up.

Sub Macro1()
x = 3
Do While ActiveCell(x, 11).Value < ""
Cells(x, 10).Value = "PO#" + Cell(x, 1).Value + " " + Cell(x, 3).Value
x = x + 1
Loop

End Sub

Could you please help? I'm a beginner at the stage and so happy to find out
this wonderful community.