Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
last cell and copy
Hi
I want to use VBA to copy columns a,b,c,e,f,g (excluding D as this is hidden) together with the last 6 columns that have values in, into another sheet. The cells that are blank do have formulas in them, but appear blank. My main data starts in row 4, with the other rows above being column headers etc.. I have attempted to record a macro, and inserting activecell.end(xltoright), which gets me to theend cell, but get stuck on how to copy the preceeding 5 columns Any direction/coding appreciated Brian -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200707/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
last cell and copy
In <75f6581ee8e7d@uwe, BNT1 via OfficeKB.com <u19326@uwe spake
thusly: I want to use VBA to copy columns a,b,c,e,f,g (excluding D as this is hidden) together with the last 6 columns that have values in, into another sheet. The cells that are blank do have formulas in them, but appear blank. My main data starts in row 4, with I succeeded at a very similar project last month using Ron de Bruin's great sample code to start and then changing it with help from this group. http://www.rondebruin.nl/tips.htm E.g., http://www.rondebruin.nl/copy6.htm "Create a workbook from every worksheet in your workbook" -- dman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy the first word or two words from a cell containing a complete sentence to another cell | Excel Discussion (Misc queries) | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |