Move from one cell to another
Here is a program I wrote for somebody this morning that have lots of features.
Sub zip_code()
Dim Cell_Data As String
zipcode_count = 0
For Each MyWorksheet In Workbooks(ThisWorkbook.Name).Worksheets
If StrComp("Summary", MyWorksheet.Name) < 0 Then
RowCount = 1
Do While StrComp(MyWorksheet.Range("C1"). _
Offset(rowOffset:=RowCount - 1, columnOffset:=0), "End") < 0
Cell_Data =
MyWorksheet.Range("C1").Offset(rowOffset:=RowCount - 1, columnOffset:=0).Value
If Len(Cell_Data) = 5 Then
Found_Char = False
For char_count = 1 To 5
character = Mid(Cell_Data, char_count, 1)
If (character < "0") And (character "9") Then
Found_Char = True
Exit For
End If
Next char_count
If Found_Char = False Then
Worksheets("Summary").Range("C1").Offset(rowOffset :=zipcode_count, _
columnOffset:=0) = Cell_Data
zipcode_count = zipcode_count + 1
End If
End If
RowCount = RowCount + 1
Loop
End If
Next MyWorksheet
End Sub
"Don" wrote:
I use Excel but never program in it. However, I use VBA in Microsoft Access
a lot.
Can someone get me started and tell me the syntax to program a spreadsheet
to move the focus from one cell to another once something is entered into the
first cell? Thanks in advance.
--
Don Rountree
|