| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Half a Worksheet
Thanks Vergel, thats exactly what i was looking for!!!!
Batty!!! Vergel Adriano wrote: like this? Sub Test() Dim iTotalColumns As Integer iTotalColumns = ActiveSheet.UsedRange.Columns.Count Range(Columns(1), Columns(iTotalColumns \ 2)).Select End Sub Good Morning to you all. [quoted text clipped - 5 lines] Batty |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting only working for half of worksheet | Excel Discussion (Misc queries) | |||
| print half of rows on left and other half on right | Excel Discussion (Misc queries) | |||
| Can I have the bottom half Worksheet with less columns than Top | Excel Discussion (Misc queries) | |||
| Workbook VBA not recognising half the new worksheet!! | Excel Programming | |||
| Full Screen With Status Cut Worksheet Tabs in Half | Excel Programming | |||
Threaded Mode
