Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning column count into a Column Letter
I have a macro where I am looking to be able to dynamically select
data based on how many rows and columns are filled in. I have the count for the number of columns with data, but I need to know how to turn that count # into a Column letter (like A, B, C) so that I can then tell the macro the range to select. How do I do that? I can find lots to tell me how to count columns, but nothing that tells me how to translate that value into something useful to me for my macro. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning column count into a Column Letter
If you have a count, then just use the Resize property to create the range.
For example... NumberOfRows = 5 NumberOfColumns = 9 StartAddress = "C3" Range(StartAddress).Resize(NumberOfRows, NumberOfColumns).Select -- Rick (MVP - Excel) wrote in message ... I have a macro where I am looking to be able to dynamically select data based on how many rows and columns are filled in. I have the count for the number of columns with data, but I need to know how to turn that count # into a Column letter (like A, B, C) so that I can then tell the macro the range to select. How do I do that? I can find lots to tell me how to count columns, but nothing that tells me how to translate that value into something useful to me for my macro. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning column count into a Column Letter
On Oct 16, 10:19*am, wrote:
I have a macro where I am looking to be able to dynamically select data based on how many rows and columns are filled in. I have the count for the number of columns with data, but I need to know how to turn that count # into a Column letter (like A, B, C) so that I can then tell the macro the range to select. How do I do that? *I can find lots to tell me how to count columns, but nothing that tells me how to translate that value into something useful to me for my macro. function ColLtr(numb) ColLtr = Chr(numb + 64) end function _____________________ Tom Lavedas |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning column count into a Column Letter
Hi
If you have a fixed start cell, you can use something like this: Range("A1").Resize(RowCount,ColumnCount) or Range("A1", Cells(RowCount, ColumnCount)) If you do not start from A1 you can use Range("D5",Range("D5").Offset(RowCount-1,ColumnCount-1)) Hopes this helps. .... Per skrev i meddelelsen ... I have a macro where I am looking to be able to dynamically select data based on how many rows and columns are filled in. I have the count for the number of columns with data, but I need to know how to turn that count # into a Column letter (like A, B, C) so that I can then tell the macro the range to select. How do I do that? I can find lots to tell me how to count columns, but nothing that tells me how to translate that value into something useful to me for my macro. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning column count into a Column Letter
Thanks to you both, you were a big help!!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNT unique letter in a column | Excel Worksheet Functions | |||
Formular to count occurence of a number or letter in a column | Excel Worksheet Functions | |||
How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions |