range object

Hello below is my code, it works only 1/3 of the upper screen as expected, error msg comes out anywhere else. please help to identify the root cause. Thanks so much. Sub FindMax() ' Dim zoomCell As Range, zoomRng As Range, maxCell As Variant ActiveSheet.Cells.Interior.Color =...

Hello, The following is attempting to iterate an array (2D String array) and use the values in order to create new powerpoint slides- Dim rng as range Dim loopI As Integer For loopI = 0 To arrayLength - 1 'array starts at 0 so 1 'Add a slide to the Presentation...

In Excel, how do you split the VBA code for a long Range object? To simplify my problem, let's say the following Range object is too long: Set r1_text = Sheets("1").Range("E8:F17, E21:F70, I21:J70, C73:G87") And I want the code to look like a list: Set r1_text = Sheets("1").Range(" _ E8:F17...

Hello, I tries to run a macro and a message pops up "No cells were found". The Macro runs fine until the variable dy1 is 5 (Meaning it is day 5 of the month). Some days are missing as there are weekends were no data are available. The filter returns nothing (no visible data) as there isn't day...

I am trying to take a column of data that I want to paste in five different columns. I want it to go: 1 to 12345 2 12345 3 12345 4 12345 5 12345 1 2 3 4 5 ... and so on. Here is the code: Option Explicit Sub ReArrangeCells()...

hi, I am trying to copy data from cells A2to U305 of worksheet 1 to worksheet 2 , in the same workbook using range object. I seem to be getting overflow error and i am unable to find out the problem. Request some help in finding the issue in my code Sub CopyData() Dim SourceRange As Range...