KarNeedsHelp
06-03-2011, 06:20 PM
Hi can someone help me with this macro that I want to do?
I want to write a macro that basically checks Column A and goes through each cell with value, and if it's not blank then Column B will say Y
We don't have a set range because it will vary from cases to cases.
So something that checks like the top cell offset by 1 because of the header to the last cell with value in that column.
so if A2=value B2=Y
it will keep doing that until the last cell with value.
I want to write a macro that basically checks Column A and goes through each cell with value, and if it's not blank then Column B will say Y
We don't have a set range because it will vary from cases to cases.
So something that checks like the top cell offset by 1 because of the header to the last cell with value in that column.
so if A2=value B2=Y
it will keep doing that until the last cell with value.