Did you know that you can navigate through forms without using your mouse?
You can go to the next field of the form by pressing the "TAB" key on your keyboard (
)
You can go to the previous field of the form by pressing together "SHIFT+TAB" keys.
For most MODEMs, the string AT#CID=1 or AT+VCID=1will enable Caller ID.
If these fail try :
When you try this AT commands in a terminal program, the answer you should receive is OK.
When you write your own macros, a very important thing is to know exactly where your worksheet starts and where it ends. Here is a helpful macro that can be used in your own macros and does exactly that :
Sub DetermineUsedRange(ByRef theRng As Range)
Dim FirstRow As Integer, FirstCol As Integer, _
LastRow As Integer, LastCol As Integer
On Error GoTo handleError
FirstRow = Cells.Find(What:="*", _
SearchDirection:=xlNext, _
SearchOrder:=xlByRows).Row
FirstCol = Cells.Find(What:="*", _
SearchDirection:=xlNext, _
SearchOrder:=xlByColumns).Column
LastRow = Cells.Find(What:="*", _
SearchDirection:=xlPrevious, _
SearchOrder:=xlByRows).Row
LastCol = Cells.Find(What:="*", _
SearchDirection:=xlPrevious, _
SearchOrder:=xlByColumns).Column
Set theRng = Range(Cells(FirstRow, FirstCol), _
Cells(LastRow, LastCol))
handleError:
End Sub
The following macro uses the above code and displays in message boxes the used Range, the last used column and the last used row:
Sub CallDetermineUsedRange()
On Error Resume Next
Dim usedRng As Range
DetermineUsedRange usedRng
MsgBox usedRng.Address
MsgBox usedRng.Columns(usedRng.Columns.Count).Column
MsgBox usedRng.Rows(usedRng.Rows.Count).Row
End Sub