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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address Entire Worksheet as a range
cells will select all cells
maybe something like this With Cells .Borders(xlDiagonalDown).LineStyle = xlNone .Borders(xlDiagonalUp).LineStyle = xlNone .Borders(xlEdgeLeft).LineStyle = xlNone .Borders(xlEdgeTop).LineStyle = xlNone .Borders(xlEdgeRight).LineStyle = xlNone .Borders(xlInsideVertical).LineStyle = xlNone .Borders(xlInsideHorizontal).LineStyle = xlNone End With -- Gary "Klatuu" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address Entire Worksheet as a range
Thanks, Gary, Actually, to condense it:
xlsheet.cells.borders.linestyle = xlnone worked. When I go to print preview, the borders are all gone; however, in the workbook I was given to copy, you don't see any grid lines in normal view. What property do I need to set to make them disappear? "Gary Keramidas" wrote: cells will select all cells maybe something like this With Cells .Borders(xlDiagonalDown).LineStyle = xlNone .Borders(xlDiagonalUp).LineStyle = xlNone .Borders(xlEdgeLeft).LineStyle = xlNone .Borders(xlEdgeTop).LineStyle = xlNone .Borders(xlEdgeRight).LineStyle = xlNone .Borders(xlInsideVertical).LineStyle = xlNone .Borders(xlInsideHorizontal).LineStyle = xlNone End With -- Gary "Klatuu" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address Entire Worksheet as a range
Never mind, I got it.
xlsheet.activate xlapp.activewindow.displaygridlines = false Thanks again for the help. "Gary Keramidas" wrote: cells will select all cells maybe something like this With Cells .Borders(xlDiagonalDown).LineStyle = xlNone .Borders(xlDiagonalUp).LineStyle = xlNone .Borders(xlEdgeLeft).LineStyle = xlNone .Borders(xlEdgeTop).LineStyle = xlNone .Borders(xlEdgeRight).LineStyle = xlNone .Borders(xlInsideVertical).LineStyle = xlNone .Borders(xlInsideHorizontal).LineStyle = xlNone End With -- Gary "Klatuu" wrote in message ... 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? |
Reply |
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 |