VBA Code Queston Cell Range

[ststern45]

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

 

[ststern45]

OK I figured it out.