looping through columns

Hello and thanks in advance and I will provide feedback to any assistance on solutions. I'm trying to name range a large amount of cells and would like to use a VBA loop to do it. I am naming a column of cells from (20, 3) to (20, 69). That's 50 cells in column C starting on the 20th row and...

(?<word> \w{4,}) This is a php code that does exactly what I want my macro to do. String together characters a-z and 0-9 (not case sensitive) and match words when they are equal to or greater than 4 characters. I am not sure how to get this code into VBA's language. I need it to loop through a...

Hi, I have encountered the following problem: I have a huge set of data (experimental measurements), which I have gathered to Excel so, that the data I'd like to plot in a graph is in every 8th column (first data series I'd like to plot is A30:B50, second I30:J80, third Q30:R70, and so on). I...

Hello, I am trying to create a large loop that will reference my column called cities. I want the loop to refernce cities and put the state of these locations in a new column with the header state. My table is below. I have 5 different cities Memphis, Sand Diego, Seatle, Portland, and Charlotte...

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I’m sorry my question is a little difficult for me to describe, but here goes…<o:p></o:p> <o:p></o:p> <o:p></o:p> I need to loop through the rows in my sheet looking at the value in Column...