Macro Help

G

Gary''s Student

This sets the variable:

Sub dural()
Dim r As Range, v As Variant
Set r = Range("A1")
v = r.Value
End Sub

to set the cell, reverse the equation.
 

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

EXCEL MACRO 1
Command button macro 6
Pasting cell contents into a macro 1
Using variable for cell reference 3
How to assign PRINT option to execute a macro 3
Run Macro If Cell have "x" value 0
Pivot table macro filter data between yesterday and today (date+time) 0
Getting filename data 7

Top