| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code almost works...but can't find a minor mistake
Thanks Tom
Tom Ogilvy wrote: change Worksheets("Calculation").Range(MyRange).Select to Worksheets("Calculation").Range(MyRange).Entireco lumn.Select and Worksheets("Data").cells(6, Data_Col).Select to Worksheets("Data").Columns(Data_Col).Select Of course you can then probably eliminate a lot of other code, but that is your decision. I have something that almost works...but I can't get it to copy the entire Column AD, where am i making a mistake. [quoted text clipped - 64 lines] End Sub -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200603/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bulk find and replace mistake | Excel Worksheet Functions | |||
| Code somewhat works. Please help? | Excel Programming | |||
| Code mistake | Excel Programming | |||
| Macro Code minor alteration please. | New Users to Excel | |||
| Why won't this code works | Excel Programming | |||
Hybrid Mode
