Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I discover the FULL list of vbConstants
Frederick,
I thought Chip Pearson had a list on his web site, but I couldn't find it. I have a spreadsheet that gets the constants of any office app which you can have if you want it. -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Frederick" wrote in message ... I am just begining to use some of the VBA for Excel and using an example from Stephen Bullen & John Greens Book called Excel 2002 VBA. there is a Sub in one of their examples which is listed below.... I am at a loss as to where I can find the list of correct (vbConstant Parammeters) to use when building Subs / Functions such as these.. I have searched through the Help and also the Object Browser, I can find some vbContants but not the ones used in the example below. I am sure there are others which may apply to other functions etc. any help would be much appreciated please. Regards Fred Sub GetRealLastCell() Dim RealLastRow As Long Dim RealLastCol As Long Range("A1").Select On Error Resume Next RealLastRow = Cells.Find("*", Range("A1"), xlFormulas, , xlByRows, xlPrevious).Row RealLastCol = Cells.Find("*", Range("A1"), xlFormulas, , xlByColumns, xlPrevious).Column Cells(RealLastRow, RealLastCol).Select End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I discover the FULL list of vbConstants
Thanks Bob, You are a mine of information. Good job we can all rely on you
and your colleagues. If your Spreadsheet though is something different to that of Chip's and you think it would be of use then I would love to take a copy if that's O/k. Best Regards Fred "Bob Phillips" wrote in message ... Frederick, I thought Chip Pearson had a list on his web site, but I couldn't find it. I have a spreadsheet that gets the constants of any office app which you can have if you want it. -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Frederick" wrote in message ... I am just begining to use some of the VBA for Excel and using an example from Stephen Bullen & John Greens Book called Excel 2002 VBA. there is a Sub in one of their examples which is listed below.... I am at a loss as to where I can find the list of correct (vbConstant Parammeters) to use when building Subs / Functions such as these.. I have searched through the Help and also the Object Browser, I can find some vbContants but not the ones used in the example below. I am sure there are others which may apply to other functions etc. any help would be much appreciated please. Regards Fred Sub GetRealLastCell() Dim RealLastRow As Long Dim RealLastCol As Long Range("A1").Select On Error Resume Next RealLastRow = Cells.Find("*", Range("A1"), xlFormulas, , xlByRows, xlPrevious).Row RealLastCol = Cells.Find("*", Range("A1"), xlFormulas, , xlByColumns, xlPrevious).Column Cells(RealLastRow, RealLastCol).Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to discover the difference | Excel Worksheet Functions | |||
Showing full pull-down list | Excel Worksheet Functions | |||
how do i get the full name list in a workbook ? | Excel Worksheet Functions | |||
Full Down List That Filters | Excel Discussion (Misc queries) | |||
i discover that i cannot scroll in each part if i simply freeze p. | Excel Worksheet Functions |