![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
cjansley | Outlook | 1 | 07-27-2011 07:36 AM |
![]() |
jerem | Outlook | 2 | 10-29-2010 03:04 PM |
Changing list of Value | xmadnet | Word | 0 | 09-07-2010 01:48 PM |
Changing Word doc to .txt | cialili | Word | 1 | 08-02-2010 12:38 PM |
changing font size without changing leading | carolns | Word | 1 | 09-14-2009 12:30 PM |