PDA

View Full Version : Assign a value of a variable to a specific cell



beki_bt
02-15-2012, 05:25 AM
Hi,

I have a problem. I have a macro that filters my raw data (ProjData) sheet and the end result integer value is given to a variable (count).
What I now need to do is to assign the value of my variable (count) to a cell (D25) of another sheet (ResProj).

Any help is appreciated!!!

Bob Phillips
02-15-2012, 06:02 AM
Worksheets("ResProj").Range("D25").Value = count

beki_bt
02-15-2012, 06:06 AM
Worksheets("ResProj").Range("D25").Value = count

Thank you! worked like a treat!