+ Reply to Thread
Results 1 to 3 of 3

Text in a cell keeps moving after running report

  1. #1
    Registered User
    Join Date
    07-07-2016
    Location
    Chicago, IL
    MS-Off Ver
    2016
    Posts
    2

    Post Text in a cell keeps moving after running report

    Hello,

    I have a form on an excel file. On the form, there are buttons to run reports using VBA. The data is stored in a Excel tab on the same file, pushed through an Access DB, and the results are spit back out onto the original Excel tab with the form. In order to run any report, the VBA needs to read the location of the Access DB which I typed in cell D1. The problem is that when I run a report, the DB location text in D1 moves over a couple cells to H1. I have to keep moving the text back to cell D1 in order to run another report. Its a tad annoying since I have to run multiple reports quite often. Is there any way I can make sure that the DB location text never moves from cell D1? Thanks

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Text in a cell keeps moving after running report

    Isn't your macro causing that?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    07-07-2016
    Location
    Chicago, IL
    MS-Off Ver
    2016
    Posts
    2

    Re: Text in a cell keeps moving after running report

    All the macro is doing is reading the cell text... It shouldn't be moving it. When I run a different report it alters the report on the screen and is moving the text after it refreshes the new report. I didn't put anything in the VBA that should move the text from D1.

+ 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. [SOLVED] Moving Text from One cell to another if it matches some set text
    By andylpsx in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-24-2014, 01:23 PM
  2. Running a report
    By lucas1787 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-04-2014, 05:16 AM
  3. Moving part of text in cell to another cell Excel 2007
    By Deepesh in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-22-2013, 06:25 AM
  4. Moving text from cell to other cells
    By brakiss in forum Excel General
    Replies: 2
    Last Post: 11-12-2010, 11:46 AM
  5. moving specific text within a cell
    By Rnash in forum Excel General
    Replies: 4
    Last Post: 07-08-2010, 09:31 AM
  6. Moving text from one cell to another
    By Firefighter_930 in forum Excel General
    Replies: 14
    Last Post: 12-23-2006, 05:21 AM
  7. [SOLVED] HOW TO KEEP TEXT FROM MOVING OUT OF A CELL?
    By Briguyy in forum Excel General
    Replies: 2
    Last Post: 02-23-2006, 05:10 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