Before I give up and look for a job as a parking lot attendant, can anyone help out with this:
I import a rst to Excel just fine. What I want to do next is select the new area of cells that have been filled in order to apply formatting. I can't figure out how to get a Range reference to the region. Within Excel, the recorder gives Macro language:
Range("Z200"
.select
selection.currentregion.select
this isn't working in the OLE mode, neither is (the # of rows/columns is provided by rst counts):
With objxlwkb.ActiveSheet
.Range(.Cells(1, 1), .Cells(10, 10)).select
End With
I can get a reference to the last cell with "xlspecialcellslast" but can't get that address into the next selection.
(The code examples are paraphrased)
This should be simple but it's stymied me. . .any takers?
I import a rst to Excel just fine. What I want to do next is select the new area of cells that have been filled in order to apply formatting. I can't figure out how to get a Range reference to the region. Within Excel, the recorder gives Macro language:
Range("Z200"
.selectselection.currentregion.select
this isn't working in the OLE mode, neither is (the # of rows/columns is provided by rst counts):
With objxlwkb.ActiveSheet
.Range(.Cells(1, 1), .Cells(10, 10)).select
End With
I can get a reference to the last cell with "xlspecialcellslast" but can't get that address into the next selection.
(The code examples are paraphrased)
This should be simple but it's stymied me. . .any takers?
