Hello,
I am attempting to create a macro to process different data sets. I have gotten to a part where I need to reference data specific to each data set, so I need to use relative references, however, they did not return the proper data. So, I created a variable that will read the value I need returned in each data set but the relative reference will not read the variable in the cells when the code is run. Any ideas how to fix this?
Range("B1").Select
ActiveCell.FormulaR1C1 = "Deflection{in}"
Range("B:B").Select
Columns("B:B").ColumnWidth = 12.57
Range("A" & FirstRow).Select
NewVar = ActiveCell.Value
Range("B" & FirstRow).Select
ActiveCell.FormulaR1C1 = "=(RC[-1]-NewVar)*0.5/60"
Range("B" & FirstRow).Select
Selection.AutoFill Destination:=Range("B" & FirstRow & ":B" & LastRow), Type:=xlFillDefault
Range("B" & FirstRow & ":B" & LastRow).Select
Thanks in advance!
I am attempting to create a macro to process different data sets. I have gotten to a part where I need to reference data specific to each data set, so I need to use relative references, however, they did not return the proper data. So, I created a variable that will read the value I need returned in each data set but the relative reference will not read the variable in the cells when the code is run. Any ideas how to fix this?
Range("B1").Select
ActiveCell.FormulaR1C1 = "Deflection{in}"
Range("B:B").Select
Columns("B:B").ColumnWidth = 12.57
Range("A" & FirstRow).Select
NewVar = ActiveCell.Value
Range("B" & FirstRow).Select
ActiveCell.FormulaR1C1 = "=(RC[-1]-NewVar)*0.5/60"
Range("B" & FirstRow).Select
Selection.AutoFill Destination:=Range("B" & FirstRow & ":B" & LastRow), Type:=xlFillDefault
Range("B" & FirstRow & ":B" & LastRow).Select
Thanks in advance!