Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Below produced by Macro Recorder:
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 5/21/2005 by James May ' Selection.Copy Range("H17").Select Selection.PasteSpecial Paste:=xlPasteComments, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False End Sub I need to replace the Line Range("H17").Select with a clickable designated other cell, not just H17 as was done with the recorder. What do I put in its place? TIA, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
How do I change macro text with another macro? | Excel Discussion (Misc queries) | |||
macro color change | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel | |||
Macro button colour change??? | Excel Worksheet Functions |