| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
I need Range("B:B") to change to Range("D
 "), Range("F:F"), and so.I need the "Next_line" to be 2 when the next column is selected. Next_Line = Application.CountA(Range("b:b"), NumColumns) I want to do: Next_Col = 0 ' Then when the next column comes: Next_Col = Next_Col + 2 Next_Line = Application.CountA(Range("Next_Col:Next_Col"), NumColumns) How do I do this? Jose |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
On Oct 16, 7:41 pm, LongBeachGuy <crnet...@yahoo.com> wrote:
> I need Range("B:B") to change to Range("D "), Range("F:F"), and so.> I need the "Next_line" to be 2 when the next column is selected. > > Next_Line = Application.CountA(Range("b:b"), NumColumns) > > I want to do: > Next_Col = 0 > > ' Then when the next column comes: > > Next_Col = Next_Col + 2 > Next_Line = Application.CountA(Range("Next_Col:Next_Col"), > NumColumns) > > How do I do this? > > Jose Hello Jose, Like this... Next_Col = Next_Col + 2 Next_Line = Application.CountA(Cells(1, Next_Col).EntireColumn, NumColumns) Sincerely, Leith Ross |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change code to look at a range of columns not a single column | BeSmart | Microsoft Excel Programming | 2 | 7th Mar 2010 01:16 PM |
| select range in column, calculate on range plus 3 columns, output inrange plus 7 columns | ppeer | Microsoft Excel Programming | 8 | 11th Feb 2010 09:14 PM |
| writing values of a range inside a range | sloth | Microsoft Excel Programming | 7 | 3rd Oct 2006 03:14 AM |
| Change Rows/Columns in range??? | 43fan | Microsoft Excel Programming | 9 | 1st Apr 2004 02:05 PM |
| Can't change any properties of range object from inside a function | dienkwik | Microsoft Excel Discussion | 6 | 12th Mar 2004 04:22 PM |
