for i

Hi all I am having trouble with combining the .textotocolumn function with if statements. The posts I have found all have fixed/specified ranges such as destination cell A1 and range A:A. My data insn't always imported the same way. Both the columns and the format varies which is why I would...

Data: C1: 3 B2: 2 D2: 2 A3: 1 E3: 1 B4: 2 D4: 2 c3: 3 Sub mac() 'MsgBox Selection.Cells.Count For Each cell In Selection.Cells MsgBox cell.Address Next cell End Sub Sub mac1() 'MsgBox Selection.Cells.Count For i = 1 To Selection.Cells.Count MsgBox Selection.Cells(i).Address Next i End Sub

Hi, i cant figure out what i am doing wrong. Trying to look at a range and test if date value in cell is greater than date value in another cell, if so then enter text in another cell, then go to the next cell and perform the same test, do this till the last row of data in that column. But when...