Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged excel

0 votes
453 views
1 answer
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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)
Ask a question:
Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
...