Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

[Solved] VBA: syntax for range.select using variable

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Solved] VBA: syntax for range.select using variable

    My code is below.

    I have used
    Range("I"&Row1).Select
    now I want to select a range from ("I"&Row1) to ("P"&Row1)

    but i can't get the syntax right. can anyone help.

    >>>>>>>

    Row1 = Worksheets("UMBRELLA FORM").Range("AF96")

    Sheets("UMBRELLA FORM").Select
    Range("U96:AD96").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Expenses").Select
    Range("I:P" & Row1).Select
    ActiveSheet.Paste
    Application.CutCopyMode = False

  • #2
    i'm an idiot

    Comment


    • #3
      Just for giggles I am partial to using
      cells function

      Cells(1,1)

      range(cells(1,1),cells(10,1))

      Variables can replace any of the numbers

      Comment

      Trending

      Collapse

      There are no results that meet this criteria.

      Working...
      X