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
    Excel 2016, Excel 2019
    Posts
    676

    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 2016
    Posts
    6,869

    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
    Excel 2016, Excel 2019
    Posts
    676

    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 2016
    Posts
    6,869

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,000

    Re: Adjust coding to allow movement of cells

    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

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. [SOLVED] 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