Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste
Hi,
Can someone please help me with the following task: I am trying to copy a block of cells from sheet1 (starting from Cell("B1")) and ending on the last cell (most right, most down cell, which may vary on each execution), into sheet2. Thanks, Jeff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste
Hi Jeff,
If you are defining the last cell as the last populated cell in the last column. try: Sub Tester() Dim rng As Range With ActiveWorkbook.Sheets("Sheet1") Set rng = .Cells(1, Columns.Count).End(xlToLeft) Set rng = Cells(Rows.Count, rng.Column).End(xlUp) Range(.Range("B1"), rng).Copy Sheets("Sheet2").Range("A1") End With End Sub You have not indicated where in Sheet2 the cells are to be copied.This will copy the block to Sheet2 starting in cell A1. Adjust A1 (in the penultimate line) to suit. --- Regards, Norman "Jeff" wrote in message ... Hi, Can someone please help me with the following task: I am trying to copy a block of cells from sheet1 (starting from Cell("B1")) and ending on the last cell (most right, most down cell, which may vary on each execution), into sheet2. Thanks, Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Macro to Copy/Paste then Paste to Next Line | Excel Programming |