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
199 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
728 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
513 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
392 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
508 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
388 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
633 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
313 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
468 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
485 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
445 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
310 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
531 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
362 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
476 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
421 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
766 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
469 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
552 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
343 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
773 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
574 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
403 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
314 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
342 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
369 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
346 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
528 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
...