| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autoshape textbox
I want to copy a textbox in its entirity and paste it to a location on
another sheet inside the same workbook prior to printing the sheet. ActiveSheet.Shapes("Text Box 17").Select Selection.Copy Sheets("Pre Bid PRNT").Select Range("A28").Select ActiveSheet.Paste Sheets("Pre Bid PRNT").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Sheets("Pre Bid PRNT").Select Sheets("Pre Bid").Select It is failing on the Range("A28").Select statement If I remove it I get results but it is pasted in "A1". i want it to appear further down the sheet. Any ideas what is wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight all Text in a Textbox when the textbox is selected | Excel Programming | |||
| HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
| Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
| Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
| UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Threaded Mode
