Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need help getting the syntax right for a loop...
This is what I am trying to accomplish: Start in A2, run spell check on that cell only. Go to the next cell in that row with data (if any, up to the last column) and run spell check on that cell only. Go to the next cell in that row with data (if any, up to the last last column) run spell check on that cell only...etc. Then move to Row 3 and do the same... Then Row 4...then 5...etc. Until we hit the last row. Can someone help me get the syntax right? I know this is probably a ways off, but this is where I left off. (As you can see..need a lot of help...it obviously doesn't work). Sub SpellCheck3() Dim LastRow As Long Dim LastCol As Long LastRow = ActiveSheet.Cells(Rows.Count, "C").End(xlUp).Row LastCol = ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column Debug.Print LastRow, LastCol Set LastCell = ActiveSheet.Cells(LastRow, LastCol) x = 2 z = 1 Do Until x = LastRow Do Until z = LastCol Set mc = ActiveSheet.Cells(x, z) Application.Goto(ActiveSheet.Range(mc.convertformu la(formula:=mc, FromReferenceStyle:=R1C1 _ , ToReferenceStyle:=A1) Range(x.Address, z.Address).CheckSpelling SpellLang:=1033, AlwaysSuggest:=True z = z + 1 Loop z = 1 x = x + 1 Loop End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Two Cell Loop | Excel Programming | |||
VBA Loop until certain cell! | Excel Programming | |||
Loop to add +1 in cell? | Excel Programming | |||
Loop until cell is empty | Excel Programming | |||
loop through a cell. | Excel Programming |