LinkBack URL
About LinkBacks
I have set variable for active sheet!
Set s = ActiveSheet
I can't get formula work for sheet as a variable
???? ActiveCell.FormulaR1C1 = "=s!R[-20]C[1]" ????
How do i force formula from variable sheet???????
HOW to include ActiveSheet vatiable in formula?
I have set variable for active sheet!
Set s = ActiveSheet
I can't get formula work for sheet as a variable
???? ActiveCell.FormulaR1C1 = "=s!R[-20]C[1]" ????
How do i force formula from variable sheet???????
Last edited by madars; 01-31-2011 at 08:56 AM. Reason: removed repeated ? from title
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks