Tuesday 15 April 2014

vba - If Loop For Full Column Using Len -


I want to make an I statement which measures the amount of characters in an AutoFill column and if the character is equal to lane = 9 Or 12, I want to go to the first column and change the name of the cell to "CLO" on that line. I have to run this whole column (column M & N), how should I go about it?

  set the Rial range as the Range Range set as the Range range, Range range as Range, Range Range as the integer myRange = Column ("M: M") = Application Worksheet Function. Set up the cautá (RealRng = RealRng) for ActiveSheet.Range ("M2: M +" and counting) for each RNG if LAN (RNG) = 9 or LAN (RNG) = 12 then RG Offset (0, -12) = "Bond" and if the next RNG is a simple demo that will loop through a filtered range, test for length, and change the next column to a length of 9 or 12.  

You will need to optimize for your purposes:

  set the range, ranging range filtered RNG = range as a sub-demo () dim filter ("A1 : A10 "). Special Seals (xlCellTypeVisible) filteredRng for each RNG if the lane (RNG) = 9 or lane (RNG) = 12 then RNGFetset (0, 1) = "CLO" end if the next RNG end sub    

No comments:

Post a Comment