offsets

Hi I have code that I would like to make a small change to but need some help with. I only need the first cell in all the ranges in all the “arr1” in my code below to be increased by one row , so the 1st change is the current range is Range("D22:I36") change to Range("E22:I36"). I can do...

Hi, I have this formula which uses vlookup and I want it to use the cell H1 that offsets the result by 4. I cannot get it to work is there anyway please. =IFERROR(VLOOKUP($A32,Results!$AP$10:$AS$17,4+H1,0),"") Len

Hi, I have the below code. I need to resize this to exclude the last row. In other words I want to keep all but the last row selected. Range("A3:B3").Select Range(Selection, Selection.End(xlDown)).Select I've tried various offsets and resize combinations and can't seem to get it...

This is another building block for formatting a large spread sheet I have to use, thanks in advance! I need to use a cell value as a column offset, move right the corresponding offset, then write a "1" in the next 5 columns of that row. Then repeat for the rest of the rows in my sheet...

Dear MrExcel Forum Users I’m a beginner to VBA and am attempting my first manually created macro. After 2 days of chipping away- online courses, reading other posts, my own attempts- I’ve hit a wall and am seeking your guidance. I wish to automate a repetitive process that I could implement by...