move a variable value in a macro to a cell

M

Mike

Within a macro I am using several variables as counters. At the end of the
the session I need to move the values of the variables into the spread sheet
before saving. I used the value statement to bring the cel values in the
variables but can not go the other direction.
 
J

Jim Thomlinson

Here is some code to read and write a value from a sheet.
'*************************************
dim lng as long

lng = sheets("Sheet1").Range("A1").value
lng = lng + 1
sheets("Sheet1").unprotect 'assuming protection
sheets("Sheet1").Range("A1").value = lng
sheets("Sheet1").protect 'assuming protection
'*************************************
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use a variable in a ShapeRange.Increment 0
Drop down list control value in vba 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Range passed to a function - trying to just move through the range 4
Word macro that can call cells out of Excel for a find and replace 0
Return a value from Userform.Show()? 2
Cell data entering slow! 0
Setting column width in a table with a macro is not working 0

Top