Hope this kinda makes sense here... Trying to enter formulas via vba to a worksheet... I'm trying to figure out a way to make one or + "Loop" out of all of this code here below. I already have a row count of the data being used from another worksheet but I also need to have a column count of data being used on the same worksheet("Decon_Config"). As you can see from the code I want the column to be from column "B" to the last entry column of the row of data. So from "B" to end of column. But then where the r1c2 is, I also need it to increase to the used column count range. So r1c2 to r1c(end of column data). I am trying to wrap my brain around this, please help.

Please Login or Register  to view this content.