+ Reply to Thread
Results 1 to 3 of 3

Merged cells with formula value copied and pasted not working corrrectly

  1. #1
    Registered User
    Join Date
    11-15-2022
    Location
    Washington State, USA
    MS-Off Ver
    360 ProPlus
    Posts
    31

    Merged cells with formula value copied and pasted not working corrrectly

    I have cell on a worksheet that has a formula to get the password from the workbooks database and display it in merged cells. Whether I Right click and copy or use the CTRL-C copy, when I paste that value in an online Login Form it gives me an invalid password.

    If I put a formula in a blank cell and point it to the merged cells (i.e. = K21 the merged cells) I get the same value and if I copy and paste into the online Login Form it works OK.

    I am attaching an image with full description of the problem.

    Thank you in advance for your help.
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    11-29-2022
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    435

    Re: Merged cells with formula value copied and pasted not working corrrectly

    I may not know how to fix your issue, but just some advice: merged cells act weird in general. I try to stay as far away from them as I can within my data and only use them to make titles and whatnot pop. If those cells do not absolutely have to be merged, just un-merge them and make column J wider. Honestly, it is what I would do.

  3. #3
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Merged cells with formula value copied and pasted not working corrrectly

    I suggest Linking the first cell of the merged cell alone, Like J20 that should do the trick, as when you copy the merged cell it also copies the empty cell and shows as "space".
    Punnam
    Last edited by Punnam; 12-02-2022 at 05:49 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. Application.OnUndo for Copy/Paste not working when > 1 Cells Copied/Pasted
    By MaddenJMF in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2021, 02:36 AM
  2. Application.OnUndo for Copy/Paste not working when > 1 Cells Copied/Pasted
    By MaddenJMF in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2021, 10:25 PM
  3. hyperlink not working when copied and pasted
    By scouse13 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-11-2020, 06:56 PM
  4. Replies: 3
    Last Post: 12-22-2014, 02:24 PM
  5. Some copied cells are missing when pasted
    By paulkaye in forum Excel General
    Replies: 3
    Last Post: 07-01-2013, 03:38 AM
  6. [SOLVED] Deleting rows in a For loop not working corrrectly
    By gtol in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-09-2013, 09:32 AM
  7. [SOLVED] Pasted date in Excel 2003 is wrong e.g. 05-16-2006 is copied,05-15-2002 is pasted
    By Jaap van der Veen in forum Excel General
    Replies: 3
    Last Post: 08-11-2006, 09:10 AM

Tags for this Thread

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