ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 961
- Office Version
- 365
- 2010
- Platform
- Windows
Hi Everyone,
I would like to copy and paste a range of cells that change each day. Is there a way to alter the the VBA Range code.
For example, if the cell range values that I want to use are in a Tab named "Toolbars" in cells F2 and G2. The value in cell F2 = 20 and cell G2 = 11574 (G2 this number changes everyday)
Range ("A1:F1574").Select
Selection.Copy
If I were to do something like the following:
Dim AA As Integer
Dim BB As Integer
AA = Range("F2").Value
BB = Range("G2").Value
Range AA:BB.Select 'I know the code is incorrect
Selection.Copy
Or
Worksheets("Toolbars").Range.Value = AA: Range.Value = BB
Thanks!!
Steve
I would like to copy and paste a range of cells that change each day. Is there a way to alter the the VBA Range code.
For example, if the cell range values that I want to use are in a Tab named "Toolbars" in cells F2 and G2. The value in cell F2 = 20 and cell G2 = 11574 (G2 this number changes everyday)
Range ("A1:F1574").Select
Selection.Copy
If I were to do something like the following:
Dim AA As Integer
Dim BB As Integer
AA = Range("F2").Value
BB = Range("G2").Value
Range AA:BB.Select 'I know the code is incorrect
Selection.Copy
Or
Worksheets("Toolbars").Range.Value = AA: Range.Value = BB
Thanks!!
Steve
Last edited: