VBA- variable in a range, inside a formula

by

Have you tried this:

Dim sVal as String
sVal = "50"
ActiveCell.FormulaR1C1 = "=MAX(RC[-3]:R[" & sVal & " ]C[-3])"

More Related Contents:

  1. VBA: Selecting range by variables
  2. How do I get values from a hidden worksheet using VBA [closed]
  3. How to copy cells that contain certain text to another worksheet [closed]
  4. VBA Macro for copying and pasting columns on same excel sheet
  5. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  6. How to add default signature in Outlook
  7. Levenshtein Distance in VBA [closed]
  8. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  9. How do I base64 encode a string efficiently using Excel VBA?
  10. Assign event handlers to controls on user form created dynamically in VBA
  11. How to move each emails from inbox to a sub-folder [duplicate]
  12. Conditional Formatting using Excel VBA code
  13. Outlook Reply or ReplyAll to an Email
  14. How to use Events with Option Button Controls on Userform [duplicate]
  15. VBA Search in Outlook
  16. How do I use variables to set properties in VBA (Excel)
  17. VBA: Else without If Error
  18. Object variable or With block variable not set (Error 91)
  19. How do I open an outlook .msg file from my harddrive that is NOT in outlook?
  20. Convert RTF (Rich Text Format) code into plain text in Excel
  21. lastrow and excel table.
  22. How can I create text files with special characters in their filenames
  23. Open a workbook from VBA and disable Workbook_Open() code?
  24. How to filter listbox values based on a Textbox value
  25. Text To Clipboard in VBA Windows 10 Issue
  26. Excel VBA using FileSystemObject to list file last date modified
  27. How to get the procedure or function name at runtime?
  28. Copy an array reference in VBA
  29. What does the To and Step mean in VBA?
  30. Query my excel worksheet with VBA

Leave a Comment