Referencing a cell using a cell from a different sheet - Page 2
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Referencing a cell using a cell from a different sheet

  1. #11
    New Member
    Join Date
    Mar 2002
    Location
    Nanaimo, BC
    Posts
    49
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    'Copies format down
    Sheets("Data").Select
    Range("A" & Sheet1.[E37] & ":" & "H" & Sheet1.[E39]).Select
    Selection.AutoFill Destination:=Range("A" & Sheet1.[E37] & ":" & "H" & Sheet1.[E40]), Type:=xlFillDefault
    Range("A" & Sheet1.[E37] & ":" & "H" & Sheet1.[E40]).Select
    ActiveWindow.SmallScroll Down:=-9
    'Pastes information
    Range("I" & Sheet1.[E37]).Select
    ActiveSheet.Paste
    'Resets to Interface Sheet
    Sheets("Interface").Select
    Trying to copy down the formatting (like dragging the bottom right hand corner of a selection down the sheet) and then paste a value into it

  2. #12
    New Member
    Join Date
    Mar 2002
    Location
    Nanaimo, BC
    Posts
    49
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    oh, one more thing the error occurs at the first line starting with "Range"

  3. #13
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Well, here is your code, revised and error free when I tested it.

    This looks like only part of your entire code, but nevertheless, this portion had no errors.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com