Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
More efficient copy/paste??
TIA!!! Is there a more efficient way to perform this copy paste? I know yo should always avoid selecting if possible. I have tried a number o things and had no success. Here is the snippet of code I want t streamline: If rngNHO Is Nothing Then GoTo skipNHO Sheets("ALL").Select rngNHO.Copy Sheets("Contribs").Select Cells(Range("A3").End(xlDown).Row + 1, "A").Select ActiveSheet.Paste skipNHO: I have several snippets like this in my macro. Any help is greatl appreciated! -- Cel ----------------------------------------------------------------------- Celt's Profile: http://www.excelforum.com/member.php...fo&userid=1941 View this thread: http://www.excelforum.com/showthread.php?threadid=55039 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
More efficient copy/paste??
Set rngNHO = Sheets("All").Range("A1")
Cells(Range("A3").End(xlDown).Row + 1, "A").Select rngNHO.Copy ActiveCell This assumes that you are on the Sheet that you want to paste the data into. HTH Die_Another_Day |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
More efficient copy/paste??
Thanks guys! Quick question Ardus... With your code, if rngNHO is nothing...will that cause an error -- Cel ----------------------------------------------------------------------- Celt's Profile: http://www.excelforum.com/member.php...fo&userid=1941 View this thread: http://www.excelforum.com/showthread.php?threadid=55039 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
More efficient copy/paste??
if you don't set the rngNHO to some range then it is empty...
Die_Another_Day Celt wrote: Thanks guys! Quick question Ardus... With your code, if rngNHO is nothing...will that cause an error? -- Celt ------------------------------------------------------------------------ Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413 View this thread: http://www.excelforum.com/showthread...hreadid=550393 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
More efficient copy/paste??
No: it will do nothing.
-- AP "Celt" a écrit dans le message de news: ... Thanks guys! Quick question Ardus... With your code, if rngNHO is nothing...will that cause an error? -- Celt ------------------------------------------------------------------------ Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413 View this thread: http://www.excelforum.com/showthread...hreadid=550393 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
More efficient copy/paste??
for Ardus' code it should not because of the if not rngNHO = Nothing
HTH Die_Another_Day Celt wrote: Thanks guys! Quick question Ardus... With your code, if rngNHO is nothing...will that cause an error? -- Celt ------------------------------------------------------------------------ Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413 View this thread: http://www.excelforum.com/showthread...hreadid=550393 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Efficient way to copy a range in numerous sheets within a workbook | Excel Programming | |||
Efficient Copy/Paste | Excel Programming | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
More efficient method to copy-paste values in place? | Excel Programming |