variables name

Selecting only few fields 3 ( Has subject ID, Stimulus defines and %Change) rows out of 1500 ..(.Problem is they appear in different cell location for every excel file) is from the Excel file, copy and save them in Master Excel file. In my head it works perfectly: 1) drag .dat file into Excel...

Hello, how can I loop through ranges. What I have already tried so far. Is it possible? Dim Variabel as Range Dim Variabel_1 as Range Dim Variabel_2 as Range Dim Variabel_3 as Range Dim I as Long ' the ranges are as an example Set Variabel_1 = Range("A1") Set Variabel_2 = Range("B5") Set...

Dear VBA programmers, I've searched all over the internet but have not yet found the solutions to the following issue: I want to dynamically get the value of global variables by dynamically using the variable name. So imagine there are global variables defined in a VBA Excel application...

Hi, I have 5 variables pos1 : 10 pos2 : 19 pos3 : 25 pos4 : 36 pos5 : 42 and i have a loop from 1 to 5 in which i have to change the variable name inside as so to access the content of the variable: for i=1 to 5 x= cells("pos" & i, 1).value and so on so when i combine the name "pos" with a...