| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address Entire Worksheet as a range
What would be the correct syntax to address an entire worksheet as a range.
What I am doing is using Automation from Access to create, load data into, and format a worksheet. I have done this several times, but have a new problem. The first thing I want to do is make all the borders in the worksheet invisible. Normally, the code would be: xlsheet.range("A1:IV65536").borders.linestype = xllinestypenone Is there a shortcut way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CAN VLOOKUP SEARCH AN ENTIRE WORKSHEET INSTEAD OF RANGE OF CELLS | Excel Worksheet Functions | |||
| how to print same address on entire sheet of labels | Excel Discussion (Misc queries) | |||
| Macro to print a selected range, not entire worksheet | Excel Discussion (Misc queries) | |||
| Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming | |||
| Copy information from a specific range; not the entire worksheet. | Excel Programming | |||
Threaded Mode
