How to assign "Find" function result from one Range to other Range variable using VBA? RRS feed

  • Question

  • I want to find the column which having value "N" in "filter_rng1" variable then I want to store the list of column which having "N" in other range variable "filter_rng2". But I cannot able to store the "filter_rng1" range result in "filter_rng2".

    Please refer the below screenshot. It showing some cell address in Immediate window


    Tuesday, June 7, 2016 3:46 PM