+ Reply to Thread
Results 1 to 4 of 4

working between 2 sheets within a workbook

  1. 03-01-2018, 10:44 PM #1
    k1dr0ck
    k1dr0ck is offline
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    working between 2 sheets within a workbook

    hi,

    cant get to work trying to copy the value of B(row with last data) in sheet "CONTROL" to C10 in sheet "AR"
    the button is in a form ran from sheet "CONTROL"

    Please Login or Register  to view this content.
    Last edited by k1dr0ck; 03-01-2018 at 10:47 PM.
    Reply With QuoteRegister To Reply
  2. 03-01-2018, 11:03 PM #2
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,914

    Re: working between 2 sheets within a workbook 

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
    Reply With QuoteRegister To Reply
  3. 03-01-2018, 11:08 PM #3
    k1dr0ck
    k1dr0ck is offline
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: working between 2 sheets within a workbook

    ok just now understood that if you use with statement when you reference a range in the sheet you use a period "."
    thanks!
    Reply With QuoteRegister To Reply
  4. 03-01-2018, 11:25 PM #4
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,914

    Re: working between 2 sheets within a workbook

    Exactly.

    Thanks for rep+.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Want to apply code to all sheets available in workbook except two sheets with fast working
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-28-2017, 08:55 AM
  2. From Excel working to Google Sheets no longer working
    By rad1964 in forum Excel General
    Replies: 5
    Last Post: 07-19-2016, 10:23 PM
  3. [SOLVED] Working with a large number of sheets (+500) in a workbook
    By sinapourazima in forum Excel General
    Replies: 3
    Last Post: 07-24-2014, 01:09 AM
  4. [SOLVED] countifs working on extended ranges and different sheets not working
    By etaf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2013, 02:23 PM
  5. [SOLVED] Working with multiple sheets in a workbook
    By male_crux in forum Excel General
    Replies: 3
    Last Post: 03-06-2013, 11:15 PM
  6. [SOLVED] Copying Filtered Data From 2 Sheets of One Workbook to Another Isn't Working Correctly
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-13-2012, 06:30 PM
  7. Automatically Copy sheets in one workbook to create sheets in a new workbook..
    By leebarratt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-13-2011, 03:14 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1