KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
So i was using a for each loop to go through a bunch of rows. I ran into a problem where i was deleting rows and it was causing a row to get skipped so i have changed to a do while loop. The problem i am having is trying to get a 'cell' object. Before when i had: For Each C In Worksheets("Blah").Range("A2:A" & lastRow).Cells I could do things like C.Offset(1, 0) C.Value = "Troy" Etc. I tried using: C = Worksheets("Blah").Cells(iRow, 2) but that just gives C the value of the cell. How do i get the actual cell object? Thanks
Tags (comma-separated)
Save Edits
Cancel