Recent questions tagged Excel

0 votes

1.1k views

1 answer

excel - VBA code to set date format for a specific column as "yyyy-mm-dd"

I have a macro which I specify the date (in mm/dd/yyyy) in a textbox and I want to set this value for ... A50000").NumberFormat = "yyyy-mm-dd" See Question&Answers more detail:os...

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

0 votes

718 views

1 answer

excel - Some dates recognized as dates, some dates not recognized. Why?

Here is a list of dates: 04-22-11 12-19-11 11-04-11 12-08-11 09-27-11 09-27-11 04-01-11 ... recognize all list items as dates? Many thanks! See Question&Answers more detail:os...

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

0 votes

719 views

1 answer

excel - Why cells(1,1) = 500 * 100 causes overflow but 50000*100 doesn't?

I just created a simple sub and it gives an overflow error. However, I don't see anything wrong with the code, and ... 2) = 50000 * 100 end sub 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 Save as PDF with Filename as Cell Value

I am trying to save four sheets into a single PDF. The code below is what I have so far. When I ... :=False Sheets("Summary").Select See Question&Answers more detail:os...

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

0 votes

971 views

1 answer

excel - How to convert my xlsx sheet to java object using Apache POI

can any one suggest me to convert my xlsx sheet to java object using Apache POI. eq, my excel sheet ... convert directly. Thanks in advance. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Converting Unix time stamp to dd/mm/yyyy hh:mm:ss

I have a column that holds Unix timestamps at C1, and I am looking for the formula to create a new ... a sample of the timestamp: 1409502202 See Question&Answers more detail:os...

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

0 votes

755 views

1 answer

excel - Test for Null in IF statement

I got the sub below from: Format cell based on formula value from "JosieP" I am trying to test for Null ... ColorIndex = 10 next rcell End Sub See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

excel - Need to revise this formula that displays data based on another cell's contents

I can't get this formula working properly. Here is what I need to do (see included image below): I need ... details to solve this issue. Thanks! See Question&Answers more detail:os...

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

0 votes

825 views

1 answer

excel - Convert rows of spreadsheet to separate XML files

I am looking for a system to convert a spreadsheet (or CSV file) with a few hundred rows of data into ... that would be the best outcome. See Question&Answers more detail:os...

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

0 votes

813 views

1 answer

excel - VBA - Do While Loop returns Dir <Invalid procedure call or argument>

I am running a loop through a folder in order to get the complete filename address (folders address + file name ... is run inside the While. See Question&Answers more detail:os...

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

0 votes

805 views

1 answer

excel - Automatically link to a cell in another sheet if value is the same

I have a status update sheet (sheet1) in which team members have a line per action, and each action has a ... know if I should clarify anything. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Concatenate values based on criteria

I have a two column list of data in Excel. The first column being a question number from a test and the second ... need to be in the same cell. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

excel - VBA Run-time error 438 appears when "paste" runs

I'm just getting familiar with VBA and my code For k = 3 To ThisWorkbook.Sheets.Count ThisWorkbook.Sheets(k). ... use Cstr, but nothing changed See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Insert data in two Table using Mybatis

I am very new to Mybatis and stuck in a situation I have some questions The complete scenario is I need to ... tag Any help would be appreciable See Question&Answers more detail:os...

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

0 votes

994 views

1 answer

excel - vbNewline vs Chr(10) as linebreak delimiter in Windows vs. Mac OSX

I have an Excel sub that uses the Split() function to split CSV data from a cell into an array. However, ... explanation why this is going on? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Unable to save as PDF from VBA in mac

I am trying to save a range from a sheet as PDF through VBA. Following is the code that I have ... Completely clueless. Can anyone help?? See Question&Answers more detail:os...

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

0 votes

797 views

1 answer

excel - VBA to connect slicers (looking for improvements to code)

I finally found a code that will connect slicers with different caches on pivot table update. Basically when the ... link to original inquiry: See Question&Answers more detail:os...

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

0 votes

801 views

1 answer

excel - Find table intersect with selection

I'm looking for a Javascript equivalent of the Excel VBA Intersect method. I need to find the active cell table. ... was native. ;) Thanks, Zack See Question&Answers more detail:os...

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

0 votes

766 views

1 answer

excel - .NumberFormat sometimes returns the wrong value with dates and times

It seems that every week or so someone posts a question about dates being converted (corrupted?) to American ... it to control the screen. See Question&Answers more detail:os...

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

0 votes

894 views

1 answer

excel - What does mean the colon with equal sign ":="

If foud this code: ActiveCell.Offset(-5, -1).Range("A1:E1").Cut Destination:=ActiveCell.Range( _ "A1:E1") I ... about ":=". What does it mean? See Question&Answers more detail:os...

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

0 votes

808 views

1 answer

excel - How to identify ThisWorkbook module using VBA

Using Excel 2010. I need to add code to a remote Excel file where ThisWorkbook module has been renamed, let's say to ... ... Thank you, M.R. See Question&Answers more detail:os...

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

0 votes

879 views

1 answer

excel - Copy conditional formatting from one cell to another using VBA?

Can I copy conditional formatting from one cell to another using VBA? I'm imagining something like: Sheets ... Range("B1").ConditionalFormatting See Question&Answers more detail:os...

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

0 votes

987 views

1 answer

excel - What is the difference between Application.Calculate and Application.CalculateFull?

What is the difference between Application.Calculate and Application.CalculateFull? https://msdn.microsoft.com/en- ... efficiency is different. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

excel - Using multiple language (english, chinese, japanese) in VBA

I need to be able to use strings of multiple languages (english, chinese and japanese) in VBA. Changing the region/locale ... "尊敬的" z = "こんにちは" See Question&Answers more detail:os...

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

0 votes

817 views

1 answer

excel - Regex return seven digit number match only

I've been trying to build a regular expression to extract a 7 digit number from a string but having ... letters the second time around? See Question&Answers more detail:os...

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

0 votes

686 views

1 answer

excel - Coloring each point of a chart based on data using sequential or divergent color scales

How can I colour the individual points on a scatter chart based on values in my spreadsheet? For example, how ... instead of a sequential one? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Change region format to another language with VBA

I need to change the region format to "French (Canada)" in order for datevalue to accept french months (eg. ... I wish to change: Thanks See Question&Answers more detail:os...

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

0 votes

979 views

1 answer

excel - VBA - Find a column with a specific header and find sum of all the rows in that column

I have a large sheet. I have to set multiple filters in that sheet to columns headers in dynamic positions. ... to pick the column dynamically. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags