Results 1 to 7 of 7

Thread: [RESOLVED] excel file

  1. May 2nd, 2007, 05:05 AM #1
    ariv
    ariv is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2007
    Posts
    27

    Resolved [RESOLVED] excel file

    hi all, how to make the first row as bold in an excel file....
    Reply With Quote Reply With Quote
  2. May 2nd, 2007, 05:11 AM #2
    ganeshmoorthy
    ganeshmoorthy is offline
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: excel file

    how do you assign values to the excel file...
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.

    Reply With Quote Reply With Quote
  3. May 2nd, 2007, 05:19 AM #3
    ariv
    ariv is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2007
    Posts
    27

    Re: excel file

    just i will be assigning values to the first row with for loop. i will be numbering from 1 to 30. now i want that first row to be in bold
    Reply With Quote Reply With Quote
  4. May 2nd, 2007, 06:06 AM #4
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: excel file

    Do you know what the range of the first line is?
    Reply With Quote Reply With Quote
  6. May 2nd, 2007, 06:10 AM #5
    ariv
    ariv is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2007
    Posts
    27

    Re: excel file

    i don no.... just i want to bold that first row only...
    Reply With Quote Reply With Quote
  7. May 2nd, 2007, 06:13 AM #6
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: excel file

    But, where is the first row?

    Is it in A:? B:? C:?

    Excel deals with ranges. You can do anything (pretty much) that you want to a specified range, but you are least need to know where the range starts.
    Reply With Quote Reply With Quote
  8. May 2nd, 2007, 06:16 AM #7
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: excel file

    Example: Here is something I pulled out of one of my programs.
    Code:
    shWorkSheet.Range("A1:Q5").Font.Bold = True
    shWorkSheet is declared As Worksheet.

    I'm telling it to start at A1 and go down to Q1, then over to Q5 and bold everything in between.
    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