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.3k views
1 answer
    I am trying to work out the relative benefits and features of dictionaries compared with collections and arrays. I ... Does anyone know of one? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    After checking if a cell value exists in a column, I need to get the value of the cell next to the ... returned to achieve the desired result? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    I'm trying to write a script that opens many Excel files. I keep getting the prompt: This workbook contains links to ... , I'm using Excel 2010. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.6k views
1 answer
    I have a sheet which contains data as below: Now the Excel is having 36 total tasks,Each tasks has 4 columns ... marked the bad columns in RED See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    This loops through a list of students, but fails on the print area, which is set and coded in the export line ... Next rCell End With End Sub See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.6k views
1 answer
    I have a global variable called processRowBegin that contains the row number for the beginning of a process. I also ... , please let me know. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    Currently I have a set of cells, and each has, among useless information, a unique identifier. I also ... practice with my specific example? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.8k views
1 answer
    I am trying to create a Sub that places a SUMIF formula in a cell. I have reduced the problem to a ... suspect the semicolons in my formula. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    I have a folder with 50 files and I have a list of 50 email addresses. Each file goes to a different ... ScreenUpdating = True End With End Sub See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.7k views
1 answer
    My vba script in myMacro.xls Workbooks.Open Method work well as below, Workbooks.Open Filename:="D: ... your read and reply. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    The colon operator : is a statement delimiter in VBA. However, does anyone has a clue why the first three examples ... Debug.Print "8c" End Sub See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.7k views
1 answer
    I have cells which will contain the below value "Image not allowed|png" I want to change the color of |png ... text color(|png) using VBA? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.9k views
1 answer
    I'm trying to kill certain processes through VBA. I have a proprietary object that connects to a market data ... a process through VBA? Thanks See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
2.0k views
1 answer
    Is it possible to use VBA to detect which decimal sign is being used on the computer? I have a macro script ... ).Font.ColorIndex = 3 End With See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    Happy Monday Everyone! Have a question and hope you can help. I have a budget spreadsheet that has a budget ... an addon called power query. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.4k views
1 answer
    When I reference Excel worksheets using the CodeName property, how do I fully qualify them including the workbook ... the sheet's codename. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.6k views
1 answer
    I use this code to send email from Excel: Sub Mail_workbook_Outlook_1() 'Working in Excel 2000-2013 'This example ... it is not working ether. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.9k views
1 answer
    I'm trying to save a file from https password protected site using WinHTTP. Here's the code: Sub SaveFileFromURL( ... cannot save it? Any clues? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.9k views
1 answer
    Im trying to run a macro code but since I'm using a 64 bit Excel 2016 this code is not working. Please ... _ ByRef ppvObject As Object) As Long See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.8k views
1 answer
    I have two ranges, each containing a single cell (for example "A1" and "C3"). How do I get a new range ... R1C2") instead of Range("A2"). See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.7k views
1 answer
    Is there any easy/short way to get the worksheet object of the new sheet you get when you copy a worksheet ... a more elegant, shorter solution. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    I want to check if a range in Excel is empty. How do I write in VBA code: If Range("A38":"P38") is empty See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.8k views
1 answer
    This is the code that I'm currently working with, and I'm getting this problem. I'm novice at Excel and ... '_Worksheet' failed, error 1004. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.8k views
1 answer
    I have the following button on a Form: Private Sub CommandButton1_Click() Dim pass As String pass = UserForm1. ... be much appreciated. Thanks. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.8k views
1 answer
    I have a function that generates data for say 100 rows (and 2 columns). For each row (in the 3rd column) I ... from. Any idea how to do this? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.6k views
1 answer
    If I have the following table (shown in the image below), how can I write a grouped query that would ... So the desired results would be: See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.9k views
1 answer
    I'm reading an .xlsx file using the Office Open XML SDK and am confused about reading Date/Time values. One ... place to find this information? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.6k views
1 answer
    Can anyone find the difference between 'On error goto -1' and 'on error goto 0' in VBA? I've tried google and msdn, but I've had no luck. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
To see more, click for the full list of questions or popular tags.
Ask a question:
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...