Closed Thread
Results 1 to 5 of 5

Adjust coding to allow movement of cells

  1. #1
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Adjust coding to allow movement of cells

    Hi all I am just out of surgery for my eyes so I cannot see all the best.

    On the attached file I wish to move the data in cell B1 across to cell AF1
    then move cell b8 to B34 inclusive up to B1

    and adjust the coding to compensate for all of the moves

    Regards

    Peter

    Also posted on Ozgrid link to follow.\

    https://www.ozgrid.com/forum/index.php?thread-add/75/
    Attached Files Attached Files
    Last edited by Potholes; 06-04-2020 at 01:42 AM.
    One I have learnt over the last few months, " You are NEVER too old to learn ".
    Sometimes I forget to say " Thank You " for your assistance, so here I say " A BIG Thank You. "

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Adjust coding to allow movement of cells

    Hi, well that means that we have to walk through your code to understand what it's doing, figure it out and then hope we have a solution for you.
    Well, don't hold your breath, cannot promise anything but will see if I can make heads or tails from this
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Adjust coding to allow movement of cells

    Good afternoon

    Attached is the vr2 of the file as to how it will look after the mods EXCEPT the coding.

    The original coder is away with a very sick child

    Peter
    Attached Files Attached Files

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Adjust coding to allow movement of cells

    Hi Peter,
    I'll take a look later today, we're quite off as it comes to timezones, but ... I'll try and let you know asap

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Adjust coding to allow movement of cells

    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-04-2019, 09:17 AM
  2. Cursor Movement using Criteria
    By nzas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2015, 08:24 PM
  3. Copy cells and paste like a cut, no adjusting for movement
    By brucemc777 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-28-2014, 12:36 AM
  4. Replies: 0
    Last Post: 08-22-2012, 10:12 AM
  5. 2010, Cursor movement in locked cells
    By nsv in forum Excel General
    Replies: 0
    Last Post: 03-30-2011, 09:09 AM
  6. controlling cursor movement in unlocked and protected cells
    By thomaskprakash in forum Excel General
    Replies: 1
    Last Post: 09-02-2009, 08:51 AM
  7. movement between cells in excel
    By trealopf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2005, 08:06 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