Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a selected used range
Hi How do you select and copy the used range of a worksheet named "calculations" with a permanent starting point of cell "A14". Thanks for you help guys. Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a selected used range
Assume there will be something in cell A14
Dim rng as Range With Worksheets("Calculations") set rng = .Range(.cells(14,1),.Cells(rows.count,1).End(xlup) ) set rng = intersect(rng, .usedrange.EntireColumn) End With rng.copy would be one guess. -- Regards, Tom Ogilvy "michael" wrote in message ... Hi How do you select and copy the used range of a worksheet named "calculations" with a permanent starting point of cell "A14". Thanks for you help guys. Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying selected rows to a new workbook | New Users to Excel | |||
Copying selected columns from 1 chart to another. | Charts and Charting in Excel | |||
Copying selected data and headings | Excel Discussion (Misc queries) | |||
Copying only selected items to another worksheet | Excel Worksheet Functions | |||
Copying selected rows to another sheet | Excel Worksheet Functions |