Welcome to OStack Knowledge Sharing 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
1.9k 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 ... ) 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.6k views
1 answer
    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.4k 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 ... textframe. How can I do that? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
2.1k 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 ... Value is " & fourthVal End Sub See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
2.5k views
1 answer
    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
2.2k views
1 answer
    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.5k 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 ... wnd[0]").sendVKey 0 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
    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.4k views
1 answer
    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.4k 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 ... 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.8k views
1 answer
    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.2k views
1 answer
    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.5k views
1 answer
    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
2.1k 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? ... or Range("Test").value = a? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
2.4k 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 ... attribute. Any help would be appreciated. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
2.2k views
1 answer
    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.7k views
1 answer
    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.6k 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 ... '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.8k 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:= ... better way to do this? Thanks. See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
2.1k views
1 answer
    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.5k 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, ... ) working correctly in the macro? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
2.5k views
1 answer
    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.2k 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 ... appIE = Nothing End With 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
    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.2k views
1 answer
    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
2.2k views
1 answer
    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
2.2k views
1 answer
    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.4k 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, ... " 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 OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...