Hi All,
Im new to VBA and facing some issue to simplify my work
I have this excel sheet(table 1) with reference numbers("#:") all over the place(cell A1:BU1500). I need to have these reference numbers in a new sheet(result) in column A.
I figured that using conditional formatting to identify those cells containing ("#:") and highlight in RGB(255,255,0) then i copy and past them in result-column A.
Hope you can understand my explanation above and below are my module.
PROBLEM: Above code cannot pick up the cells highlighted by conditional formatting. It works if i were to highlight the cells with fill color
Did i miss something or there is nothing I can do with conditional formatting?
Bookmarks