Recent questions tagged excel

0 votes

453 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 the same two cells in ALL sheets, although ... = (item_a & item_b) End If 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 - 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 substitute the cell address in. =indirect(F5) I ... = "" .ShowInput = True .ShowError = True End With See Question&Answers more detail:os...

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

0 votes

807 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 Chart Set currChart = Sheets("Diagramm 1") Dim ... a shape has a textframe. How can I do that? See Question&Answers more detail:os...

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

0 votes

645 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 currently very basic, and I have ... MsgBox "Fourth Highest Value is " & fourthVal End Sub See Question&Answers more detail:os...

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

0 votes

821 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 to the table. I have been using ... ").PasteSpecial Worksheets("OLD_Master").ShowAllData End Sub See Question&Answers more detail:os...

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

0 votes

659 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 and pastes the rows as expected: Sub ... range to lose focus, but does clear the clipboard. See Question&Answers more detail:os...

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

0 votes

959 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 two systems "F6P" and "FVP" at the ... /bopin" Session.findById("wnd[0]").sendVKey 0 End Sub See Question&Answers more detail:os...

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

0 votes

607 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 Responded column (C) over the Ticket # ... calculated field that gives me the % in column G? See Question&Answers more detail:os...

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

0 votes

788 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...) called profile_reference. On a cell, I ... value of that textbox to a cell then parse it. See Question&Answers more detail:os...

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

0 votes

859 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 getting the right Day Name(e.g. Tuesday). ... 's supposed to be "Tuesday". Thanks for the help guys. See Question&Answers more detail:os...

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

0 votes

854 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 "Consumer". I want to get the value that i ... a = combobox.value; (a -> Consumer) thank you See Question&Answers more detail:os...

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

0 votes

738 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 trying to insert the click event code but its ... there is an error. Any help? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

973 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 write a row of data, which then populates some ... option I have due to JAVA errors from XLConnect etc. See Question&Answers more detail:os...

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

0 votes

608 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? Does it matter if the range is one cell or ... Range("Test") = a or Range("Test").value = a? See Question&Answers more detail:os...

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

0 votes

865 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 looks like following: <?xml version="1.0" ... value of the ID attribute. Any help would be appreciated. See Question&Answers more detail:os...

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

0 votes

725 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 disable rows of information on another sheet. ... change in a checkbox with a sub/function? 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 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 just need type in cell: =sendRequest("http ... send request and get return value under async method. See Question&Answers more detail:os...

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

0 votes

937 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 getting an error. I tried using both VBA ... '438': Object doesn't support this property or method. See Question&Answers more detail:os...

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

0 votes

933 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:=stringArray, Operator:= but I don't ... xlFilterValues Is there a better way to do this? Thanks. See Question&Answers more detail:os...

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

0 votes

646 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 run it from the VB Editor. My source had ... is not valid for the current chart type error. See Question&Answers more detail:os...

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

0 votes

1.1k 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, that are visible. The data ... isn't SpecialCells(xlCellTypeVisible) working correctly in the macro? See Question&Answers more detail:os...

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

0 votes

987 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 application, and during the initial export the ... the initial export from the web-based application? See Question&Answers more detail:os...

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

0 votes

764 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 single video in which the URL is built ... .innerText appIE.Quit Set appIE = Nothing End With End Sub See Question&Answers more detail:os...

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

0 votes

625 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". CountIf probably compares cells as numbers. ... other way to check for duplicates in VBA? See Question&Answers more detail:os...

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

0 votes

618 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 variable. I'm using a concatenation of ... With block variable not set" Any throughts, Thanks See Question&Answers more detail:os...

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

0 votes

700 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 adding sheetname again & again in code. Private ... -1])" End Sub Thank you for your help. See Question&Answers more detail:os...

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

0 votes

655 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 have tried using the code below but doesn' ... cr End With Application.DisplayAlerts = True End Sub See Question&Answers more detail:os...

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

0 votes

846 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, I need to seek a goal for a "VARIABLE" ... , to the "By changing" 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