Thread: changing
View Single Post
 
Old 01-28-2012, 04:30 AM
gsrikanth gsrikanth is offline Windows XP Office XP
Competent Performer
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default changing

change to macro

Code:
Sub Test()
Dim rngToChange As Range
Dim iMultiplier As String
Dim iDivisor As String
With Sheets("Sheet1")
  iMultiplier = .Range("A1").Value
  iDivisor = .Range("A2").Value
  .Range("A3").Value = iMultiplier & iDivisor
  Set rngToChange = .Range("B1:B" & .Cells(Rows.Count, "B").End(xlUp).Row)
  .Range("A3").Copy
  rngToChange.PasteSpecial _
  Paste:=xlAll, Operation:=xlMultiply, SkipBlanks:=False, Transpose:=False
  Application.CutCopyMode = False
End With
End Sub


convert to application.inputbox

Last edited by macropod; 02-06-2012 at 07:36 PM. Reason: Added code tags
Reply With Quote