| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy cell format
Hello -
I recorded a macro to copy the format of a range of cells on sheet2 to an equal range of cells on sheet 1. When I run the macro it copies the data from sheet 2, but then it runs into a problem on the "Range("D34:D49").Select" step and gives me the following error. select method of range class failed Sheets("Sheet2").Select Range("D9:D24").Select Application.CutCopyMode = False Selection.Copy Sheets("Sheet1").Select Range("D34:D49").Select Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Thanks for any info you can give me on this. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy cell format
I found the problem. I had the code attached to a command button in sheet 2.
I moved the macro to module in the workbook and it works fine now. "ksh" wrote: Hello - I recorded a macro to copy the format of a range of cells on sheet2 to an equal range of cells on sheet 1. When I run the macro it copies the data from sheet 2, but then it runs into a problem on the "Range("D34:D49").Select" step and gives me the following error. select method of range class failed Sheets("Sheet2").Select Range("D9:D24").Select Application.CutCopyMode = False Selection.Copy Sheets("Sheet1").Select Range("D34:D49").Select Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Thanks for any info you can give me on this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Copy worksheet1 to worksheet2, keep cell format eg cell size | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Copy partial cell character format(s) from one cell to another - an example | Excel Programming | |||
Linear Mode
