Results 1 to 3 of 3

Thread: Getting column names in Excel 2000

Threaded View

  1. Jan 12th, 2005, 12:13 PM #1
    salvelinus
    salvelinus is offline

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Resolved Getting column names in Excel 2000

    How can I get the letter column names in Excel in code? I want to apply a formula (SUM) to a range of cells in a row, but I can't use the Cells property because that takes integers, so instead of B8 i get 28.
    I don't know all the columns in advance (varies by client), so I can't hardcode it. I can think of awkward ways -adding 65 & taking the ASCII value, creating an array of letters, etc, but it seems like there ought to be a better way - column.name or something. Thanks.
    Last edited by salvelinus; Jan 12th, 2005 at 03:17 PM. Reason: Resolved
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width