Count Patterns In one Cell Excel

I wanted your help, I'm currently working in extracting some data, now the thing is that I have to count an specific amount of Call IDs a call ID format is the following 9129572520020000711. The pattern is 19 characters that starts with 9 and ends in...
more »

2017-08-15 23:08 (3) Answers

VBA - Simpler Code for Formatting

I was hoping that there is simpler code for my formatted cells below. The goal of this code is to make a box look a bit nicer, nothing overly fancy, just simple and this code doesn't look simple. Range("C17:C25").Select Selection.Borders(xlDiagonal...
more »

2017-08-15 22:08 (2) Answers

hide column based on cell font color in a row vba

I am trying to hide columns based on cell font color in first row. Here I want to hide columns if cells in first row has black as font color. Now, I dont want to define a range since my data varies each week so I can have 10 columns this week and 20 ...
more »

2017-08-15 15:08 (3) Answers

Before CheckIn-Event for Excel

I have an excel file on sharepoint which is to be checked out to make changes on it. These new changes should be exported to an access file, which is not part of the problem. The problem is that the code for the export to an access table should start...
more »

2017-08-15 12:08 (0) Answers

Delete table name in Excel VBA

I would like to remove/delete the name of my table which is "Table2" using Excel VBA. I know how to remove the name by hand, but I cannot figure out how to set the name "Table2" as a name in VBA. I found other questions on this topic but those codes ...
more »

2017-08-15 10:08 (3) Answers

Excel time comparison

I have given workers' start/end(coming to work and going out from work times) time in excel table. In 2nd table, I have given breakfast, lunch, dinner start/end times. How can I check worker can eat breakfast, lunch, dinner? ...
more »

2017-08-15 10:08 (1) Answers

Excel Solver VBA

One of the equations in a Solver model that I am creating in an Excel VBA macro is as follows: SolverAdd CellRef:="$M$18:$M$30", Relation:=2, FormulaText:="$N$18:$N$30" How could I implement it so that the row number "18" is a value that can be re...
more »

2017-08-15 03:08 (1) Answers

How to filter 4 numbers in column

I know how to filter 2 numbers like less than 25 and greater than 50 and so on, But I'm wondering how to filter 4 numbers like between 250 and 290 or if it is between 70 and 110. The codes I have tried so far are ActiveSheet.Range("$F$4:$AK$18")....
more »

2017-08-14 23:08 (1) Answers

Move cursor to non-adjacent cell after pasting

My spreadsheet has several non-adjacent blocks of cells to be filled in: A3:D4, F3:I7, K3:N7, then A9:D10, F9:I13, K9:N13, etc. I paste data copied from the Internet into each block, one after the other. Once I paste into one block, I would like th...
more »

2017-08-14 23:08 (2) Answers

Passing a parameter to an event handler procedure

I am generating a scripting dictionary using one button on a userform, using it to populate a listbox, and then need to use that same dictionary using a second button on the form. I have declared my dictionary either using early binding as so: Dim I...
more »

2017-08-14 19:08 (2) Answers

Speed up Excel Macro as Opening

So the whole scope of this Excel file is to copy and paste from other 27 external files to the current Excel file one by one. to show what I mean, following are the code examples and a stimulated capture picture. Macros(line # including space line):...
more »

2017-08-14 18:08 (2) Answers

Access Saving a Macro-Enabled Spreadsheet, ERROR

I am trying to get Access to Open a Macro-Enabled file from a Macro-Enabled Template, fill in some data then save it. I keep getting the following errors: 1- The Excel Template is hidden using the Application.visible = False in the Thisworkbook sec...
more »

2017-08-14 18:08 (1) Answers

FOR loop in Excel - find and replace

I have the following code Sub CleanCat() Dim i As Integer For i = 1 To 50 Columns("A").Replace What:="Cat" & i, Replacement:="Category" & i, LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=F...
more »

2017-08-14 17:08 (2) Answers

Deleting a Row in Excel if Value is less than X

I'm trying to delete a row in excel if it meets the criteria that the value in Column B is less than 100. I saw this and tried to follow it, but I'm not that knowledgeable in VBA, so I'm not sure where to go. EDIT This is the code I've tried thus f...
more »

2017-08-14 15:08 (3) Answers

Excel VBA - Import Macro that works but doesn't

I have the following Macro - Sub Import_Data() Dim rng As Range Dim WB2 As Workbook Dim FName As String Dim ChampSpecific1 As Worksheet Set ChampSpecific1 = Sheets("Summary-Champion Specific") FName = Dir(Application.ActiveWorkbook.Path &...
more »

2017-08-14 14:08 (1) Answers

Input Data from a Select File using VBA

I work at a bank and we regularly receive quarterly Data from Nasdaq Smart about market abuse. I have been assigned with the task of creating a macro to summarize this data to be able to visualize market abuse over longer timelines. So far I am abl...
more »

2017-08-14 14:08 (2) Answers

VBA Excel Error Run-Time error '53'

I hope you can help. I have a macro and it is extensive. Essentially what it does is it has a User form See Pic 1 This user form allows a user to navigate to a template where data is stored (see Pic 2) and select this completed template. On the u...
more »

2017-08-14 11:08 (2) Answers

VBA filter by multiple cells

I'm trying to filter a list according to the values of multiple cells on another tab, but i just can't get it to work properly. This is what i got: ActiveSheet.Range("$A$2:$Y$129").AutoFilter Field:=13, Criteria1:=Range("Formulas!A8:A10").Value ...
more »

2017-08-14 10:08 (1) Answers

Error, in comparing two sheets

I have two sheets, S and P. I am trying to compare the Id between two sheets. IF I the ID matches the I pull the corresponding details of the matched ID and paste them in sheet3. For this task, First I copied the column containing the ID in my s...
more »

2017-08-14 09:08 (3) Answers