excel-2010
How does one restore default case to a variable in VBA (Excel 2010)?
At some point I accidentally named a variable range (all lower-case) and since then the V开发者_如何学Goisual Basic for Applications editor refuses to use Range (Pascal-cased); it will auto-correct it[详细]
2023-02-08 04:50 分类:问答Visual Basic move all other columns to create one long column B
I have a series of columns of data, each 15 rows deep. Column B is the column I want to move all other columns beneath in order. So the contents of column C gets cut and moved below that a开发者_如何转[详细]
2023-02-07 14:55 分类:问答Creating Parameterized SQL Queries in Excel 2010 with VBA
I came across the following link: http://w开发者_开发知识库ww.informit.com/guides/content.aspx?g=sqlserver&seqNum=135[详细]
2023-02-06 16:53 分类:问答Vba button to activate sheet
I am trying to write the callback for a button on the backstage view. I want to select a certain worksheet and show it to the user. I thought aboutsheet(\"sheetName\").activate. This is select开发者[详细]
2023-02-06 04:33 分类:问答Automating Excel 2010 using F#
I have been searching for a FAQ to tell me how to open a Excel Workbook/Worksheet and also how to Save the File once I have finished.[详细]
2023-02-05 22:58 分类:问答How do I sum a named range of values that contains errors?
I have an Excel spreadsheet which imports data from another source that I need to run a calculation on.The data I need to work with is in a named range - it happens to be in the range C12:C36 - but it[详细]
2023-02-05 08:07 分类:问答Open New Instance of Excel 2010 with every file [closed]
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it's on-topic for Stack Overflow.[详细]
2023-02-04 21:53 分类:问答What's the "proper" way to retrieve a reference to a ribbon object?
For a VSTO workbook project, is there a best practice for retrieving a reference to the Ribbon object from the ThisWorkbook class?[详细]
2023-02-02 11:08 分类:问答Excel conditional formatting based on if it is in this currently displayed month
I am creating a work calendar and I want it to Grey out the Days of the week that a开发者_运维百科re NOT part of the currently displayed month.I have the First Day of the Month Displayed in Cell A1[详细]
2023-02-02 04:09 分类:问答Threading excel
Can I have multiple threads in Excel. I need a counter to show the time elapsed. The thread would have a loop which would update the counter and then sleep for a second. This would (hopefully) take ca[详细]
2023-01-27 12:15 分类:问答