Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with this code please !!!!!!!
I have use the code set below in other files but in this new file I am
getting an error on "Cells.Select". "Select method of Range class failed" Any idea whats going on? Sheets("Completions Summary").Select Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False Range("A4").Select |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with this code please !!!!!!!
are you sure you have the sheet name correct?
no need to select, i'd use something like this: With Worksheets("Completions Summary").Cells .Copy .PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False .Range("A4").Select End With -- Gary Keramidas Excel 2003 "Ayo" wrote in message ... I have use the code set below in other files but in this new file I am getting an error on "Cells.Select". "Select method of Range class failed" Any idea whats going on? Sheets("Completions Summary").Select Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False Range("A4").Select |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with this code please !!!!!!!
With Sheets("Completions Summary").UsedRange
.Value = .Value End With -- Regards Dave Hawley www.ozgrid.com "Ayo" wrote in message ... I have use the code set below in other files but in this new file I am getting an error on "Cells.Select". "Select method of Range class failed" Any idea whats going on? Sheets("Completions Summary").Select Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False Range("A4").Select |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with this code please !!!!!!!
i personally stay away from using used range. i'd rather find it through code. the one time it screws up could be costly. you may have other views, this is just mine. http://www.contextures.on.ca/xlfaqApp.html#Unused -- Gary Keramidas Excel 2003 "ozgrid.com" wrote in message ... With Sheets("Completions Summary").UsedRange .Value = .Value End With -- Regards Dave Hawley www.ozgrid.com "Ayo" wrote in message ... I have use the code set below in other files but in this new file I am getting an error on "Cells.Select". "Select method of Range class failed" Any idea whats going on? Sheets("Completions Summary").Select Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False Range("A4").Select |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with this code please !!!!!!!
So do I, but in the case of converting a Worksheet to values, it well
suited. -- Regards Dave Hawley www.ozgrid.com "Gary Keramidas" wrote in message ... i personally stay away from using used range. i'd rather find it through code. the one time it screws up could be costly. you may have other views, this is just mine. http://www.contextures.on.ca/xlfaqApp.html#Unused -- Gary Keramidas Excel 2003 "ozgrid.com" wrote in message ... With Sheets("Completions Summary").UsedRange .Value = .Value End With -- Regards Dave Hawley www.ozgrid.com "Ayo" wrote in message ... I have use the code set below in other files but in this new file I am getting an error on "Cells.Select". "Select method of Range class failed" Any idea whats going on? Sheets("Completions Summary").Select Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False Range("A4").Select |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating excel file, adding code to it from code, VBE window stays | Excel Programming | |||
How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? | Excel Programming | |||
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |