Foxtrot
02-28-2009, 07:58 AM
:banghead:
Hello,
When my userform enters data into my spreadsheet, it will need more than one row in some columns. The problem is, the next time I enter data, it will copy over the data in the extra rows. I've tried to remedy this with an index column that will have an "x" in Column A for every corresponding cell in Column K, but the "For Every" function is an endless loop.
There has to be a better way?
Dim Cell As Range
For Each Cell In Range("K:K")
If ActiveCell.Value > 0 Then ActiveCell.Offset(0, -10).Value = "x"
Next Cell
Hello,
When my userform enters data into my spreadsheet, it will need more than one row in some columns. The problem is, the next time I enter data, it will copy over the data in the extra rows. I've tried to remedy this with an index column that will have an "x" in Column A for every corresponding cell in Column K, but the "For Every" function is an endless loop.
There has to be a better way?
Dim Cell As Range
For Each Cell In Range("K:K")
If ActiveCell.Value > 0 Then ActiveCell.Offset(0, -10).Value = "x"
Next Cell