variable columns

A member of MrExcel was kind enough to help me with the code below. One thing it is lacking is the ability to manage a variable # of columns and rows. I would need to account for that possibility. My thanks for your help! Sub Foo() Dim MyDay As String Dim MyCol As Long, i As Long MyDay =...

Hi, To start off, my question is very similar to the one at this location: http://www.mrexcel.com/forum/excel-questions/553169-concatenate-row-variable-number-columns.html This is the provided solution that I've been trying to use: Sub ConCatFromColumnC() Dim X As Long, LastRow As Long...

I have a question dealing with a variable column and cell reference I’m using. To make it simple here’s what I have done. On the FRUIT tab I have the following table in location BU132 – BV161 Name Column Apples A Pears B Corn ‘VEGGIE’!A Peas ‘VEGGIE’!B I’m using the following...

Hi, Thank you for reading this post. I have a table containing the result for different races I extract from another software, compared over 2 year (2011, 2012) The table look a bit like that : <tbody> 2011 2012 Alpha Bravo Charlie Romeo TOTAL Alpha Bravo Charlie Romeo TOTAL...

Hi guys, I have a column of data down my col B, and then more data staggered in various columns further to the right on my worksheet, I'm trying to write a 'simple' <.< *grrr* script to move the column over to the cell one to the left of my other data. For example, if this is my current sheet...