Recent questions tagged Excel

0 votes

Q: Excel VBA application.visible immediately set back to True

I have set up a new, empty, modeless userform, to fix my problem with the least amount of code ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked May 1, 2022 in Education by JackTerrance

0 votes

Q: How to add a column and fill it with values

I have a table: Using vba I need to add a column after UsedRange, add a header and fill cells ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 26, 2022 in Education by JackTerrance

0 votes

Q: How to add a column and fill it with values

I have a table: Using vba I need to add a column after UsedRange, add a header and fill cells ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 26, 2022 in Education by JackTerrance

0 votes

Q: Export p-values from reghdfe to Excel

I am trying to export p-values to Excel from the Stata community-contributed command reghdfe: // get data ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 24, 2022 in Education by JackTerrance

0 votes

Q: Move Records to bottom of a spreadsheet if it contains a 0

I would like to move an entire row to the bottom of a spread sheet if the column k contains a 0 ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 21, 2022 in Education by JackTerrance

0 votes

Q: Importing from textfile with macro

I have an issue where i want to import value from a textfile into my excel-document which it does ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 20, 2022 in Education by JackTerrance

0 votes

Q: Formula to include range.address only if it has been set

I am using a macro to write a formula into a cell on my Excel worksheet. The formula is written ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 5, 2022 in Education by JackTerrance

0 votes

Q: How go I get a reference to a cell in an array knowing only its value?

I have a column array with the following values in my sheet: 11, 15, 5, 7, 2. I want to ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 11, 2022 in Education by JackTerrance

0 votes

Q: How go I get a reference to a cell in an array knowing only its value?

I have a column array with the following values in my sheet: 11, 15, 5, 7, 2. I want to ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 11, 2022 in Education by JackTerrance

0 votes

Q: Why can't I publish my Excel Add-In?

I have updated an Excel add-in that used to work fine apart from some new requirements. I've ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 2, 2022 in Education by JackTerrance