LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mo Mo is offline
external usenet poster
 
Posts: 69
Default numerical values for verticalalignment | colors

I'm working on an Access application that I must use late binding vs early
binding for. Unfortunately this means that I cannot use xlcentered, etc. I
must know the numerical values. For example for the horizontalalignment I'm
using 7 for centered. I want to center my verticalalignment as well. I've
tried 7 assuming it might be the same as for horizontal but it didn't work.
I have the same problem for changing the colour of the cells. I'd really
appreciate any help someone can give me with this. Any suggestions, books
etc. that spell out these values would also be a welcome bit of insight.
Thanks and have a great weekend!
 
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
Only chart numerical values, not error values andy Charts and Charting in Excel 2 November 8th 07 10:46 PM
Copying only the numerical values SM New Users to Excel 2 November 7th 07 11:21 PM
Adding numerical values based on multiple values in another column Kazmaniac Excel Worksheet Functions 6 April 4th 07 08:53 PM
Numerical values only saziz Excel Discussion (Misc queries) 4 March 17th 06 12:50 AM
Associated Numerical Values kdoggity Excel Discussion (Misc queries) 3 February 24th 06 07:07 PM


All times are GMT +1. The time now is 08:41 AM.

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"