Forum Discussion
Help with Formula/VBA
Hello Everyone! I am trying to get my inventory tracking sheet to do something very specific. Now I am very new and I've been learning on my own as I go. I have 3 spreadsheets, all labeled as dif...
Thank you for replying!
I cant seem to get any of these to work when I put them in VBA and try to run as a Macro. Nothing happens. It does not show up in my macro list. When I put in the VBA Code
Dim Minvalue As Long
Minvalue = Application.WorksheetFunction.Min(Range("A1:A10").Value)
I get "Compile error: Invalid outside procedure"
Krista1228 ,,
I was expecting that you can handle it ,, since are the SAMPLE code and need to use as SUBROUTINE,,,, using VB editor.
Anyways check the attached file,,, and read the instruction before U proceed.
- Please remember,,, the VBA code I've shown you are just SAMPLE code,, helps that how to use Excel formula with VBA code,,, you need to construct formula as needed.