Recent questions tagged Excel

0 votes

1.1k views

1 answer

excel - Multiplying every cell within a range by a value

I would like that the value of every cell within a range is multiplied by a specific value (let's say 4/7). I ... ).Value * 4 / 7 Any thoughts? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - How can I speed up this For Each loop in VBA?

I have an Worksheet_Change macro that hides/unhides rows depending on the choice a user makes in a cell with a ... the entire range at once? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - Remove non-numeric characters from numeric fields without loop

I have read some topics explaining how to do this, which would be incredibly slow. The explanation is here: ... own array to iterate through. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - Worksheets does not work

I am trying to write an excel visual basic macro. My Problem is that this code works: Dim x As String x = ... not set What could be the problem? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

excel - How to extract text based on font color from a cell with text of multiple colors

I have a column of data (A). The data in each cell in column (A) is half one color and half another color. ... ..kjd3kd 2hn89dslkjh..........2hn See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

excel - Get all innertext VBA

How do I get all of the innerText from a webpage? - Using the code below only gets the first line, the <p> ... ).innerText more code.... End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

excel - VBA - Copy and Paste Table Row to Another Table

I am very new to VBA and I am trying to solve what I think should be a very simple problem (I have a ... be appreciated. Thanks ahead of time. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

898 views

1 answer

excel - Check if BuiltInDocumentProperty is set without error trapping

Task: My goal is to check if a value has been set in the BuiltInDocumentProperties collection of an Excel ... value to function End Function See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - Assigning range to array in VBA

I would like to get excel data into an array in VBA, so I do the following: Dim Arr() As Variant Arr ... know what could be wrong? Regards Crouz See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - VBA:Trigger macro on column filter

Is there a way we can trigger a macro function on column filter in excel?? Please help Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

excel - One page per sheet property in JasperReports

I have a requirement where I have to design a report in JasperReports. The report has 4 sheets. The first sheet ... Is it possible to do this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - Convert numbers to words with VBA

I have a column of numbers. In the next column, I want the text/word conversion of the numbers. Example: 123.561 ... places. How can I do this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

979 views

1 answer

excel - Find the number of a row that contains two specific values?

I have a table of information with multiple columns. The first column is "Date" (range A:A) and the second ... anyone know how to do this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - Error handling in VBA - on error resume next

I have the following code: ErrNr = 0 For Rw = StRw To LsRw 'ToDo speed up with fromrow torow If Len(ThisWorkbook ... know how to use this code. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

969 views

1 answer

excel - HTMLBody Workaround For OlAppointment Object?

I am working on a project that links outlook meetings and appointments from an Outlook calendar to a formatted Excel ... x End If End Function See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - Using Parameters in SQL query with sub-query

I have a fairly complicated SQL query with a nested subquery. When I try to use parameters in Microsoft Query ... could do this? Thanks -Jesse See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - Remove hours and minutes from dates in one step

I always get the dates like shown in Column A, but I need them as shown in column C. How can I do it without ... A and dates in the same order. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - How to refer columns in Power Query by index or position?

I have a line as below in Power Query. So instead of referring it by name, I want it by position dynamically. Can ... {6}, but it is not working See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - VBA - Change date language

I'm trying to solve such problem: In macro, that I'm using, one of the parts is to retrieve date month (in ... knows, how can this be solved? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.8k views

1 answer

excel - python pandas read_excel returns UnicodeDecodeError on describe()

I love pandas, but I am having real problems with Unicode errors. read_excel() returns the dreaded Unicode error: ... win64, with pandas 0.16 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

excel - Using "SELECT SCOPE_IDENTITY()" in ADODB Recordset

Using a VBA script in Excel, I'm trying to insert a new row into a table and then get back the identity value of ... to be closed (state = 0). See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - Data Validation to Include Comma Character

I am using the following short macro to assign Data Validation as a list of characters: Sub DVList() With ... cells to build the list?? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - convert an integer variable to a string with leading zeros in VBA

For starters, there are LOTS of questions that have been asked with this topic. However all the ones I kept clicking ... the VB method in VBA? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

excel - What is the different between IsNull, IsEmpty, =Empty, and an empty string ie "" and why might I use variants

I'm trying to understand what a Null is and also what an Empty variable is. Are they the same? How ... similar difficulties find this useful) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - Have one cell represent a cell range

Excel 2003 Question: I'd like to have one cell represent a range of cells. So that another formula can use it ... what I'm trying to accomplish. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

961 views

1 answer

excel - Error while copying more than 8202 characters from one cell to another

Problem - I have around more than 8202 characters in once cell say Range("A1"). Now I would like to copy the ... ! I'm Confused. Pls assist. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

excel - How to check timestamp of a text file using VBA

I'm trying to write a code in Excel 2003 VBA (Windows XP) to find out if outside TXT file has different timestamp ... in VBA that can save me? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

996 views

1 answer

excel - using COUNTIF with blank value criteria with variable ranges

I have sort of a bizarre issue here attempting to use COUNTIF. pretend for a moment this is the sheet in question ... *(September!L1:L16000="")) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags