Help with this code please !!!!!!!
in [Programming]
|
From: Ayo on 13 May 2010 22:45 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
From: Gary Keramidas on 13 May 2010 22:50 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" <Ayo(a)discussions.microsoft.com> wrote in message news:A1024882-9924-426B-BD04-E4A4CDCB658D(a)microsoft.com... > 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
From: ozgrid.com on 13 May 2010 23:27 With Sheets("Completions Summary").UsedRange .Value = .Value End With -- Regards Dave Hawley www.ozgrid.com "Ayo" <Ayo(a)discussions.microsoft.com> wrote in message news:A1024882-9924-426B-BD04-E4A4CDCB658D(a)microsoft.com... > 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
From: Gary Keramidas on 13 May 2010 23:50 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" <dave(a)ozgrid.com> wrote in message news:ukwS$Vx8KHA.980(a)TK2MSFTNGP04.phx.gbl... > With Sheets("Completions Summary").UsedRange > .Value = .Value > End With > > > -- > Regards > Dave Hawley > www.ozgrid.com > "Ayo" <Ayo(a)discussions.microsoft.com> wrote in message > news:A1024882-9924-426B-BD04-E4A4CDCB658D(a)microsoft.com... >> 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 >
From: ozgrid.com on 13 May 2010 23:55 So do I, but in the case of converting a Worksheet to values, it well suited. -- Regards Dave Hawley www.ozgrid.com "Gary Keramidas" <gkeramidas(a)MSN.com> wrote in message news:%23fKyPix8KHA.4600(a)TK2MSFTNGP02.phx.gbl... > > 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" <dave(a)ozgrid.com> wrote in message > news:ukwS$Vx8KHA.980(a)TK2MSFTNGP04.phx.gbl... >> With Sheets("Completions Summary").UsedRange >> .Value = .Value >> End With >> >> >> -- >> Regards >> Dave Hawley >> www.ozgrid.com >> "Ayo" <Ayo(a)discussions.microsoft.com> wrote in message >> news:A1024882-9924-426B-BD04-E4A4CDCB658D(a)microsoft.com... >>> 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 >> >
|
Pages: 1 Prev: How to select a workbook? Next: how to print autocad dwg's from excel vba |