| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy paste values macro
Hello
This is my macro Range("K4").Select ActiveCell.FormulaR1C1 = _ "=IF(ISERROR(VLOOKUP(RC10,Sheet2!R1C1:R56C2,2,FALS E)),"""",VLOOKUP(RC10,Sheet2!R1C1:R56C2,2,FALSE))" Range("K4").Select Selection.AutoFill Destination:=Range("K4:K7282") Range("K4:K7282").Select Columns("K:K").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("K3").Select End Sub I get the results I want but ...This is a macro that I have to run everyday. So the auto fill range will be different every day . How do I correct the macro? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for copy and paste values | Excel Discussion (Misc queries) | |||
| Copy range in macro using paste special values | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Threaded Mode
