excel macro error

Hello dear experts! I have a whole bunch of workbooks with 30 sheets each, that I need to update each month. On top of each sheet, I'm using DATE-function: =DATE(2016;10;SHEETS()+14). That helps users telling which date the sheet is made for. Each month I am changing the month (in this case...

This code has some syntax error but its generic I cant understand. Says For with no Next I have got an next in code it as I am new at this how can I Skip to next row if the row does not contain a number? For Each Nextcell In Range(InitialRow) If Not IsNumeric(Nextcell) Then...

Hi, I receive the following error while trying to delete some cells: Run-time error '1004': Cannot use that command on overlapping selections This is my code: Rows("2:" & LastRow).Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.EntireRow.Delete Here LastRow...

Dear Friends, Greetings to you all! I used Mr.Domenic code for this: Option ExplicitSub test() Dim OutlookApp As Outlook.Application Dim MItem As Outlook.MailItem Dim Rng As Range Dim Rw As Range Application.ScreenUpdating = False ActiveSheet.AutoFilterMode = False...

Hello, I created a macro that has a userform to select a workbook, pull data from it, and then go through the comments (its from a survey with an open-end question). The search and replace was designed to remove expletives. I wont post the expletive list, but I will share the rest. The red...

This macro should take two list and create every combination of the two list in a third column a1 b1 a2 b2 should give the following list (not sure what order) a1 b1 a2 b1 a2 b1 a2 b2 b1 a1 b1 a2 b2 a1 b2 a2 The excel macro gives a Run-time error '6" Overflow on this line "Set rngOutB =...