+ Reply to Thread
Results 1 to 7 of 7

Mirror cells - two worksheets, random cells. Attempted code provided

  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    southampton
    MS-Off Ver
    Excel 2003
    Posts
    76

    Mirror cells - two worksheets, random cells. Attempted code provided

    Hi all

    I have the code below, kindly posted by another member on an older post, which I have tried to adjust for my needs - mirroring the cells on sheet Step 1 to sheet Step 3, M23 with L44 etc.

    Its just coming back with errors. Can anyone spot my mistake? I'm useless at VBA.

    Many thanks

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Mirror cells - two worksheets, random cells. Attempted code provided

    Where are the error(s)?
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    05-14-2013
    Location
    southampton
    MS-Off Ver
    Excel 2003
    Posts
    76

    Re: Mirror cells - two worksheets, random cells. Attempted code provided

    Hi Nathan,

    Thanks for your reply. it's the error text box that's part of the code i.e. a box simply titled Mircosoft Excel and the message reads "was not mirrored in". Not very helpful I know. I need to click it 10 times to get rid of it..
    Last edited by ld2x07; 06-18-2014 at 09:13 AM.

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Mirror cells - two worksheets, random cells. Attempted code provided

    Hi

    Can you attach the book?

  5. #5
    Registered User
    Join Date
    05-14-2013
    Location
    southampton
    MS-Off Ver
    Excel 2003
    Posts
    76

    Re: Mirror cells - two worksheets, random cells. Attempted code provided

    Here's a link to the source post if it helps :
    HTML Code: 

  6. #6
    Registered User
    Join Date
    05-14-2013
    Location
    southampton
    MS-Off Ver
    Excel 2003
    Posts
    76

    Re: Mirror cells - two worksheets, random cells. Attempted code provided

    I'm trying to upload the workbook but its very big and compressing it isn't enough.. :-/

  7. #7
    Registered User
    Join Date
    05-14-2013
    Location
    southampton
    MS-Off Ver
    Excel 2003
    Posts
    76

    Re: Mirror cells - two worksheets, random cells. Attempted code provided

    I'll keep trying....
    Last edited by ld2x07; 06-19-2014 at 08:18 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. mirror data between cells in different worksheets
    By dumdum in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-19-2016, 02:40 AM
  2. VBA to mirror cells between worksheets conditional to cell color
    By Guy Waggoner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2013, 11:43 AM
  3. VBA Code To Mirror Cells from one Worksheet to another based on sequence number
    By jarrinsonp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2010, 06:28 AM
  4. VBA Code To Mirror Cells from one Worksheet to another
    By Daniel1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2010, 07:03 AM
  5. Mirror Cells
    By darksupernova in forum Excel General
    Replies: 7
    Last Post: 03-03-2010, 12:16 PM

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