Multiply Entire Range By Value?

by 
Sub Test()

    Dim rngData As Range

    Set rngData = ThisWorkbook.Worksheets("Sheet1").Range("A1:B10")
    rngData = Evaluate(rngData.Address & "*2")
End Sub

Kind of outdated but is that what you were looking for ?

More Related Contents:

  1. How to color all the rows based on the cell values
  2. Loading addins when Excel is instantiated programmatically
  3. Excel’s fullname property with OneDrive
  4. How to insert an embedded picture?
  5. Copy Excel range as Picture to Outlook
  6. Obtain attribute names from XML using VBA
  7. Return RGB values from Range.Interior.Color (or any other Color Property)
  8. Translate text using vba
  9. Run-time error ‘1004’ : Method ‘Range’ of object’_Global’ failed
  10. “Can’t find Project or Library” for standard VBA functions
  11. How do I issue an HTTP GET from Excel VBA for Mac
  12. Copy sheet and get resulting sheet object?
  13. Sending mail using Outlook where the Send method fails
  14. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  15. Using a variable for row in (row,column) for a range in VBA
  16. Export chart as image – with click of a button
  17. How to get the path of current worksheet in VBA?
  18. Excel VBA to match and line up rows
  19. Change font color for a part of text in cell
  20. Create a new object using the text name of the class
  21. Excel cell from which a Function is called [duplicate]
  22. How to extract text within a string of text
  23. GET pictures from a url and then rename the picture
  24. How to implement custom iterable class in VBA
  25. move files from one folder to another
  26. How can I loop through a subset of worksheets?
  27. How to run a string as a command in VBA
  28. How to find Number of Occurences of Slash from a strings
  29. How to Send Email When Computer is Locked?
  30. VBA, Combine PDFs into one PDF file

Leave a Comment