• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

vba macro runtime error type mismatch

M

mdisa

New Member
hello,
first i explain my macro excel file, i have four sheets for daily stock track excel in which four sheets opening, inwards, outwards and net stock where qty calculate and run macro for inward sheets directly paste to net stock sheet but when entered inward stock which i have opening stock debug error is showing and when entered new inventory then macro run perfectly
 

Attachments

  • debug.png
    debug.png
    157.3 KB · Views: 6
  • error in macro.png
    error in macro.png
    169.1 KB · Views: 8
  • opstock sheet.png
    opstock sheet.png
    163.5 KB · Views: 6
  • inwardsheet.png
    inwardsheet.png
    164.8 KB · Views: 6
  • net stock sheet.png
    net stock sheet.png
    167.7 KB · Views: 4
Last edited:
mdisa
You wrote one long sentence and sent some snapshots.
What is UBi -value then You'll get Your challenge?
What isScreenshot 2021-11-26 at 18.35.42.png-value then You'll get Your challenge?
( Hint: I didn't try to ask - what it should be? )
Hint - Instead of some snapshots - You should able to send a sample Excel-file with needed sample data.
... as well - explain - when something happens? ... what should happen?
 
You must log in or register to reply here.
Back
Top