VBA code only works when i entered values manually

**keshavtale** · 03-26-2024, 05:06 AM

In the attached file there is VBA code , use of this code is find specific sum of values and highlight that values, you can see in that file cell A2, A3, A4 is highlighted
because sum of that values is 433159 get matched which i entered in VBA code, but problem is now i use msoffice 2016 i do not know that is the reason behind it or any other reason , now this code only works when i entered values manually in A column, and whein i copy paset values then code not work
please give me solution of that problem

**JohnTopley** · 03-26-2024, 05:49 AM

Copy/paste has no impact on the macro BUT the macro only matches TOTAL in range 433158 To 433160. so if no matching total is found, it (should but does not!) return a blank (or "error")

**keshavtale** · 03-26-2024, 05:55 AM

do you try decimal values put this value in cell A3 224853.53 then try to run code successfully

**JohnTopley** · 03-26-2024, 06:05 AM

It will NEVER match on any total where the data is not whole numbers. Your intial post is completely mis-leading as the issue has nothing to do with copy/paste!

**keshavtale** · 03-26-2024, 06:31 AM

you mean i will post new thread for this new problem , when you say that code is running successfully on your side then i thought by this angle then i just found this problem ,
because whein i entering values i entered whole values i do not know there is decimal value because it is hidden and when i copy paset values it also copies decimal values , so please give me solution for this problem

**keshavtale** · 03-26-2024, 06:59 AM

and this my second reply and also take care of my previous reply , the VBA code not work with decimal values and also when i copy paste values it is not work believe me you take access of my computer through anydesk through remote session then you can see the problem , i attached another file where i copy and pasted values please check that in this file VBA code works on your computer

**JohnTopley** · 03-26-2024, 07:57 AM

As per my previous replies, if I cut, then paste, no problem: nor with data being decimal, OTHER than it has to a whole number i.e no digits after the decimal point.

And macro only matches TOTAL in range 433158 to 433160 i.e integer values.

**keshavtale** · 03-26-2024, 08:06 AM

you are right when i cut and paste values then VBA code work, it is possible when i pick values from formula it means when i paste only values from formula so i think that is the cause VBA code not work if i am right then what is the solution for that

**JohnTopley** · 03-26-2024, 08:09 AM

If you delete entry from C2 and then macro, what result do you get?

Please Login or Register  to view this content.

Clears C2 and is blank after running macro if no match found

**JohnTopley** · 03-26-2024, 08:11 AM

Post a file with an EXACT replication of what you are doing.

**keshavtale** · 03-26-2024, 08:18 AM

i attached file where i copying values from that file you should copy only yellow color values

**JohnTopley** · 03-26-2024, 08:54 AM

The reason they do NOT match is : 224853.0 is actually 224852.9641! Obviously you were manually entering 224853.0 - hence it worked

Try

Formula:

Please Login or Register  to view this content.

in the source sheet

**keshavtale** · 03-26-2024, 10:14 AM

Thanks now my problem is solved

VBA code only works when i entered values manually

LinkBack

Thread Tools

Rate This Thread

Display

VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Re: VBA code only works when i entered values manually

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Paste Visible Cells Only - works only if step through code manually

code to delete a file works when stepping through manually, but not automatically?

Code works when cell is manually changed only the first time and not with vba

Forecast() of manually entered values instead of a selected range

Excel 2007 : code works (manually F8) but not with button

[SOLVED] VLOOKUP only works on data manually entered.

#N/A Values : Returned by Formulas vs Entered Manually

Bookmarks

Bookmarks

Posting Permissions