| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable headers
ActiveWorkbook.Worksheets.Add.Name = "NewSheet"
Sheets("NewSheet").Move After:=Sheets(ActiveWorkbook.Worksheets.Count) 'Copy and paste Sheets("Parameters").Activate Range("D4:F7").Select Selection.Copy Sheets("NewSheet").Activate Cells(1, 1).Select do until activecell = "" activecell.offset(1,0).select loop ActiveSheet.Paste That should work I think .... let me know. Chris On Mar 10, 10:35*am, Robert wrote: The date would be in sheet: Parameters, Cell:D4 HTH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup using column headers and row headers | Excel Discussion (Misc queries) | |||
| Hide Column Headers but not row (Headers) | Excel Programming | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
| Cells.Find error Object variable or With block variable not set | Excel Programming | |||
Hybrid Mode
