Today is just Excel day apparently.
I was assigned another small project to revamp a process we do to make things more user friendly so everyone can do it without much explanation. I am exporting a sheet from Smartsheets to Excel via its export function. I am then copying all of that data into another excel sheet and trying to run some code to clean it up.
I am running a small block to check cell value/text, then deleting according to it:
The code runs and works, but only on rows that are not indented. For some reason, it skips over those. I tried changing my IF statement to If Cell.IndentLevel > 1, but that did not work either. I am really confused as to why.
I was assigned another small project to revamp a process we do to make things more user friendly so everyone can do it without much explanation. I am exporting a sheet from Smartsheets to Excel via its export function. I am then copying all of that data into another excel sheet and trying to run some code to clean it up.
I am running a small block to check cell value/text, then deleting according to it:
Code:
Dim Cell As Range
For Each Cell In Range("B1:B300")
If Cell.Text = "TRUE" Then
Cell.EntireRow.Delete
End If
Next Cell