Recent questions tagged EXCEL

0 votes

1.3k views

1 answer

excel - VBA Copy Sheet to End of Workbook (with Hidden Worksheets)

I want to copy a sheet and add it to the end of all current sheets (regardless of whether the sheets are hidden ... test.Name = "copied sheet!" See Question&Answers more detail:os...

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

0 votes

831 views

1 answer

excel - How to search on worksheet by VBA Code?

I have a worksheet with 2 columns "Key" and "Value". by VBA code, i want search Input_key on Key columns, if ... [input-value]. How do i code? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - How to "Refresh Data" via VBA in Power Point?

so far I have tried the Chart.Refresh and Chart.Update and also ChartData.UpdateLinks and neither work. My question is ... (65 out of 73). 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 Go to last empty row

I have a project on excel macro, I need to highlight the next last row that has an empty value. example ... should highlight the cell A101... See Question&Answers more detail:os...

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

0 votes

925 views

1 answer

excel - Lookup using INDEX and MATCH with two criteria

I am trying to achieve a basic lookup using INDEX and MATCH. My layout is: Sheet 1 NAME | SITE | DATE Sheet ... to match on both NAME and DATE? See Question&Answers more detail:os...

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

0 votes

952 views

1 answer

excel - Non-contiguous named range into an array, then into row in different sheet

I'm trying to get data posted from a non-contiguous range into a row in a separate sheet. Before I built ... constants Clear End If End Sub See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Can I compile VBA on workbook open?

I am trying to find a way of compiling the code in VBA on workbook open. I can do this manually by opening ... have access to the debug option. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Programmatically create event listener in VBA

Is it possible to programmatically create an event method on a comboBox? On worksheet I have a ComboBox and I can ... listener interface...) ;) 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: Counting rows in a table (list object)

I am trying to write some VBA in Excel that can take the name of a table (list object) as a parameter and ... .Rows.Count) Thanks for any help! See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Skip to next iteration in loop vba

I am trying to create a simple conditional loop that will go to the next iteration if a condition is true ... would be much appreciated. Thanks. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - VBA automation error in CreateObject("InternetExplorer.Application")

I am getting the an automation error while invoking the following object Set IE = CreateObject("InternetExplorer. ... End With 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 - C# - convert xls file to xlsx without office components

I have a server that can't have any office installed on it, so I'm using ClosedXML to do some ... having office installed on the server. See Question&Answers more detail:os...

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

0 votes

927 views

1 answer

excel - Find first and last row containing specific text

I have a long (2,000 + rows) list of different values. I am trying to find the first and last row for each ... Looking for how to do so in VBA. See Question&Answers more detail:os...

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

0 votes

912 views

1 answer

excel - Export from pig to CSV

I'm having a lot of trouble getting data out of pig and into a CSV that I can use in Excel or SQL ( ... ? Any help would be much appreciated! See Question&Answers more detail:os...

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

0 votes

761 views

1 answer

excel formula - Multiple Linear Regression in Power BI

Suppose I have a set of returns and I want to compute its beta values versus different market indices. Let's ... hoping there's a better way. See Question&Answers more detail:os...

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

0 votes

876 views

1 answer

excel - Export from pig to CSV

I'm having a lot of trouble getting data out of pig and into a CSV that I can use in Excel or SQL ( ... ? Any help would be much appreciated! See Question&Answers more detail:os...

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

0 votes

732 views

1 answer

excel formula - Multiple Linear Regression in Power BI

Suppose I have a set of returns and I want to compute its beta values versus different market indices. Let's ... hoping there's a better way. See Question&Answers more detail:os...

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

0 votes

930 views

1 answer

excel - Export from pig to CSV

I'm having a lot of trouble getting data out of pig and into a CSV that I can use in Excel or SQL ( ... ? Any help would be much appreciated! See Question&Answers more detail:os...

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

0 votes

800 views

1 answer

excel formula - Multiple Linear Regression in Power BI

Suppose I have a set of returns and I want to compute its beta values versus different market indices. Let's ... hoping there's a better way. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

excel - Skip to next iteration in loop vba

I am trying to create a simple conditional loop that will go to the next iteration if a condition is true ... would be much appreciated. Thanks. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - VBA automation error in CreateObject("InternetExplorer.Application")

I am getting the an automation error while invoking the following object Set IE = CreateObject("InternetExplorer. ... End With End Sub See Question&Answers more detail:os...

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

0 votes

986 views

1 answer

excel - C# - convert xls file to xlsx without office components

I have a server that can't have any office installed on it, so I'm using ClosedXML to do some ... having office installed on the server. See Question&Answers more detail:os...

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

0 votes

943 views

1 answer

excel - Find first and last row containing specific text

I have a long (2,000 + rows) list of different values. I am trying to find the first and last row for each ... Looking for how to do so in VBA. See Question&Answers more detail:os...

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

0 votes

826 views

1 answer

excel - Export from pig to CSV

I'm having a lot of trouble getting data out of pig and into a CSV that I can use in Excel or SQL ( ... ? Any help would be much appreciated! See Question&Answers more detail:os...

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

0 votes

727 views

1 answer

excel formula - Multiple Linear Regression in Power BI

Suppose I have a set of returns and I want to compute its beta values versus different market indices. Let's ... hoping there's a better way. See Question&Answers more detail:os...

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

0 votes

931 views

1 answer

excel - Add a new sheet to a existing workbook in python

I have browsed almost all the previous threads, but still cannot get this working.I am trying to add a new sheet ... ) wb.save('template.xlsx') See Question&Answers more detail:os...

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

0 votes

964 views

1 answer

excel - How to programmatically change conditional compilation properties of a VBA project

I'm currently working on a VBA code generator/injector that adds VBA functionality to Excel workbooks by using the ... couldn't find anything. See Question&Answers more detail:os...

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

0 votes

919 views

1 answer

excel - Declare a variable as Decimal

I'm optimizing a macro in VBA which had none of the data types declared, so everything was clumsily treated by ... that but the proper way)? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags