array address

I have an array that can vary in length. Is there a way to adjust this macro so that I don't have to use R1C1 to define the array? This is what my VBA looks like so far... Windows("2022 Design Yield Report Ryan.xlsx").Activate ActiveWorkbook.Names.Add Name:="myArray"...

Hello, I'm trying to use some strings to reference arrays so that I can use one cell instead of four, to visualize it better follows the example: A B C D E F G H I 1 =SUM(Sheet2!A1:D1) =SUM(Sheet2!A2:D2) =SUM(Sheet2!A3:D3) =SUM(Sheet2!A4:D4) =Sheet2!A1:A4 =Sheet2!B1:B4 =Sheet2!C1:C4...

Hi, ino sheet1 I have table: Into sheet2 I have other table: How to write a function, that will be automaticly taken value from sheet1 and put into col H - Target, to sheet2?

Hi Guys, I have an array as follows -2 b -1 c 0 d 1 e 2 f I can easily do this using vlookup(a3,a1:b5,2,False). However the problem is the value I want could be anywhere in the table so I need another function to call out the cell location (a3) before I use vlookup. I have tried...