Re: Function VBA Help
Quote from cytop;777707The reason you get #value is because the code is throwing an error. I did try to figure out the logic but failed, miserably.
First step: Add error handling to your function.
That, at least, will warn you when things are not right and perhaps you can begin to resolve it from there.
Ok I found my error before the macro runs turn off automatic formula update and after the macro runs I turn it back on using VBA of course. Thanks for everyone's help! 
Re: Function VBA Help
Quote from StephenR;777705That works for me.
Did you run the macro in B6? The formula keeps reverting to #value and then you have to F2 every cell individually...
Re: Function VBA Help
Try it now
Re: Function VBA Help
Please click the "Attachment 70228" text to open the file
Good afternoon Ozgrid community,
I am having an issue with my "function" code when I sort using a macro. Attached is an example with what I mean. In column's H and I you will see a custom formula. Now go to cell b6 and select "John Doe." When you do that all of those formula's become #value. Why is that?
forum.ozgrid.com/index.php?attachment/70233/
Re: Userform label1 update based on Textbox value
forum.ozgrid.com/index.php?attachment/69537/
Here is a better example just follow what the userform says also the macro will pop up asking you to debug the macro due to the Vlookup formula.
Re: Userform label1 update based on Textbox value
[ATTACH=CONFIG]69516[/ATTACH]
Please note the userform is a work in progress.
Re: Userform label1 update based on Textbox value
This works perfect is there a way to add an extra step like:
V = Worksheets(ActiveSheet.index + 1).Name
vlookup("& textbox14& ",'" & V & "'!A4:F1000,5,false)+Val(Me.textbox1)+Val(Me.textbox1)Good afternoon I trying to create a userform that has a label in it that adds textbox value together. Example: Lebel1.caption = textbox1 +textbox2 + textbo3 etc... would anybody be able to help me out with this?
I have the following vba code that I am trying to use to no avail. I need to run an autofill macro that will not refer to any range unless it is a variable.
lnglastrow = ActiveSheet.UsedRange.Rows.CountActiveCell.Offset(2, 0).AutoFill Range(ActiveCell.Offset(2, 0), ActiveCell.Offset(2, 3).lnglastrow)