CODEWITHSUNDEEP
excelvbaexcel-formula
Mel4342
Mel4342

Reputation: 1

Vba referencing a cell on another worksheet

I have a question its am stuck on. I have 2 sheets within a workbook. I want to reference the cell within 1 sheet. Then insert that data into each cell in a range in the other worksheet any thoughts?

Sub insert formula and drag Dim last row as long Lastrow=Range("K" & Rows.Count).End(xlUp).Row Range("k7").formula="=sheetnamecellvalue" Range("k7").auto fill destination:=Range("K7:K" & Lastrow) End Sub. I was trying to use a formula to pull the data from this cell. The formula would come out as text n not execute. Also the cell would change in the formula and not stay the same. Like the cell i wanna reference is c17 but formula would run down c18 c19 etc

Upvotes: -5

Views: 58

Answers (0)

Related Questions