+ Reply to Thread
Results 1 to 28 of 28

VBA referring to a different sheet, automatically fill cell based on content of other cell

Hybrid View

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    Buffalo, New York
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: VBA referring to a different sheet, automatically fill cell based on content of other

    OK, I tried this and it did not work, every time I ran it, excel tried to use the I column in itmof and not itbof. It still didn't do anything in the I column of itmof because there is no data there but every time I ran it the entire I column in itmof was highlighted. I think if you can get it to go to the itbof tab, then column I will successfully be rounded to 5 decimal places!

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,026

    Re: VBA referring to a different sheet, automatically fill cell based on content of other

    OK. Try replacing this line:

    Range("I2:I" & bottomA).Select
    with this line:
    Sheets("itbof").Range("I2:I" & bottomA).Select

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1