Recent questions tagged excel

0 votes

1.6k views

1 answer

excel - Copy Paste macro is inducing 'grouped'-worksheet functionality?

I am getting an error I can't figure out: After I run the macro below, two certain string values are pasted into ... ) End If End If End Sub See Question&Answers more detail:os...

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

0 votes

2.4k views

1 answer

excel - Using Indirect function in Data Validation through VBA

I am using the indirect function in my excel sheet through VBA , I am getting an error when I try to ... True .ShowError = True End With See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

excel - vba: test if shape contains a textframe

I want to loop over all shapes in a chart in an excel file. This works in principle with Dim currChart As ... textframe. How can I do that? See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - Finding highest and subsequent values in a range

I have the below code which is supposed to find the 1st, 2nd, 3rd, and 4th highest values in a range. It is ... Value is " & fourthVal End Sub See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

excel - VBA selecting visible cells after filtering

The following code applies filters and selects the top 10 items in column B after some filters are applied ... OLD_Master").ShowAllData End Sub See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - "Application.Calculation = xlCalculationManual" statement causing run-time error 1004 in VBA Copy-Paste procedure

I have VBA code that copies the first row and pastes the values to multiple rows. The below code runs fine ... , but does clear the clipboard. See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

excel - How to choose specific SAP GUI session?

I am trying to run an Excel VBA code which uses SAP GUI Scripting. I have some open sessions in Sap and using ... wnd[0]").sendVKey 0 End Sub See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel 2010 - Creating Calculated Field with SUM and COUNT of Fields Pivot Table

Here's a snapshot of my pivot table. I want to create a calculated field that displays the percentage from the ... me the % in column G? See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

excel - Get the value of a textbox to a cell

I have a textbox called TextBox 1 which contains paragraphs. I defined it with a name (Insert > Name > Define...) ... to a cell then parse it. See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

excel vba - How to get the Day Name of Date?

I have a small code that gets the Day Name of the Dates listed in Excel. But the problem is, it's not ... Tuesday". Thanks for the help guys. See Question&Answers more detail:os...

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

0 votes

2.5k views

1 answer

excel - Get the selected value of a activex combobox using vba

How do i get the selected value of the combobox? i have a combobox which has the values: "Corporate" and " ... (a -> Consumer) thank you See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

excel - Programatically inserting click event code for dynamically generated label not working

I am inserting a ActiveX control Label in excel sheet using VBA code. Now after inserting the button, I am ... Any help? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

excel - openxlsx not able to read from .xlsx file in R

I am trying to read value from a .xlsx file using openxlsx package in R. In simple words, I need to ... to JAVA errors from XLConnect etc. See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - When to use range.value?

If I'm reading/writing to a range, when do I just use the range name and when do I need to use range.value? ... or Range("Test").value = a? See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

excel - Read XML Attribute VBA

I am trying to get the attribute of a single node in VBA, but can't manage it using DOM The XML ... attribute. Any help would be appreciated. See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - Detecting changes to checkboxes via VBA

Following on from my previous question. A requirement from the customer is to have checkboxes on a report to ... checkbox with a sub/function? See Question&Answers more detail:os...

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

0 votes

2.5k views

1 answer

excel - How to VBA sends an Async XMLHTTP request?

To get data from a webservice in Excel, I have created an excel addin provide function to get it; user ... return value under async method. See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

excel vba IE clicking a button

Through Excel and VBA, i am opening a page. I want to click on the button 'Expand' through vba but I am ... 't support this property or method. See Question&Answers more detail:os...

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

0 votes

2.5k views

1 answer

excel - VBA: Autofilter for Partial Array strings

I need to filter a column for the array I've made. I'm trying to use Cells.AutoFilter Field:=14, Criteria1:= ... better way to do this? Thanks. See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - Working macro returns error when run from form control

I'm trying to move all charts from source sheet to destination sheet. The following code works fine when I ... the current chart type error. See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

excel - SpecialCells(xlCellTypeVisible) also includes hidden/filtered cells

I have a dataset that I'm using a filter on. I simply want to calculate the total values in column N, ... ) working correctly in the macro? See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

excel - Importing .xls to Access .mdb: External Table is not in the expected format

I have a macro that imports a spreadsheet as follows: (this spreadsheet is an export from a web-based ... from the web-based application? See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

excel - Webscrape loop on all URLs in Column A

I'm trying to scrape the Facebook Video Titles from a list of URL's. I've got my macro working for a ... appIE = Nothing End With End Sub See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

excel - Detecting duplicates formatted as text

I need a function to detect duplicates formatted as text. This cannot distinguish between "46.500" and"46.5000" ... check for duplicates in VBA? See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

excel - Using the Find VBA function with Defined String

Hey maybe I'm not seeing something obvious here but how can you use the Find VBA function with a predefined ... not set" Any throughts, Thanks See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - Vba loop for many sheets

I have vba code that adds calculations for 4 sheets. I want a loop that will calculate hundreds of sheet without ... Thank you for your help. See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - How do you merge same value columns using vba?

Can anyone help me write a vba code to merge same value cells in different columns as shown below. I ... .DisplayAlerts = True End Sub See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

excel - VBA Goalseek with Variable instead of Cell

I need to use Goalseek in my VBA code, but rather than seeking a goal for a target "CELL" in my spreadsheet, ... " field. Is that even possible? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags