Thread: Merging
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_99_] Steve[_99_] is offline
external usenet poster
 
Posts: 1
Default Merging

Hello ..

So far I have this

Sub Update_receipt(ByVal name, ByVal Quantity, ByVal Price, ByVal Total)
Sheets("Receipt").Select
Rows("6:6").Select
Selection.Insert Shift:=xlDown
Range("a6").Select
ActiveCell.FormulaR1C1 = name
Range("b6").Select
ActiveCell.FormulaR1C1 = Quantity
Range("c6").Select
ActiveCell.FormulaR1C1 = "@"
Range("d6").Select
ActiveCell.FormulaR1C1 = Price
Range("e6").Select
ActiveCell.FormulaR1C1 = Total
intCount = intCount + 1
End Sub


Now instead of sending the Quantity to one cell, the '@' symbol to
another cell and the Price to a different cells i want to send them all
to the same cell.

Now i am a total newbie so it will be a simple answer


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080108-0, 08/01/2008
Tested on: 09/01/2008 14:07:49
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com