LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNT unique letter in a column Brian Excel Worksheet Functions 6 May 8th 10 10:46 PM
Formular to count occurence of a number or letter in a column Bethrand Excel Worksheet Functions 2 September 12th 09 03:43 PM
How do I turn excel columns from column number to column letter? column Setting up and Configuration of Excel 1 April 29th 08 10:15 AM
How to replace column letter in refferences with a function using the old column letter? Dmitry Kopnichev Links and Linking in Excel 6 October 13th 05 09:09 AM
How to replace column letter in refferences with a function using the old column letter? Dmitry Kopnichev Excel Worksheet Functions 6 October 13th 05 09:09 AM


All times are GMT +1. The time now is 04:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"