Get instant live expert help on I need help with excel query editor
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
cannot get into visual basic editor anymore
Solved by I. C. in 11 mins
Hello, suddenly Excel is not allowing me to get into the VBA editor. When I click on the "Visual Basic" button under the Developer tab I can see Excel flicker but the VBA editor does not appear. This has never happened before. Pls help!
Solved by X. Y. in 21 mins
Use the VBA Editor to create a new module. Function Depreciation (Value, Rate) Depreciation = Value * Rate End Function
Solved by G. S. in 30 mins
I'm doing a query against a DB2 table and right now in the query editor results I can see "null" for the fields with actual null data. But when I close the query and load the results to a table in a worksheet the field will show a blank instead of a null. Now I'm where I don't really know if the field is null or contains '' which is a very big difference. How do I get "null" to show in the table results?
Solved by F. J. in 30 mins
Use the VBA Editor to create a new module. Type the following VBA code to create a custom depreciation function (be sure to include the blank lines after the first line and before the last line). Save and exit the VBA Editor. Function Depreciation (Value, Rate) Depreciation = Value * Rate End Function
Solved by I. A. in 12 mins