Hi, I'm trying to create macros to analyze my research project data.
I'm new to VBA and don't know much so I try to record macros if it works and then get the base code and tweak it.
I have filtered my column B ("animal") to show only "z011" and "z012". I assigned the value "Control" in "C12" (First cell in this case). I need to assign these filtered rows as "Control" in Column C from the first cell ("C12" in this case), till the last cell.
This is my code currently that i managed to work out from various threads here and there. However I'm not sure what's wrong as it changes my entire sheet cells to "Control".
![]()
Please Login or Register to view this content.
Bookmarks