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: 1
Default Looking Up Numbers in a Table Using VBA

Hi.
I have created a program for myself to generate the code for an HTML
pictures page, using about 7 parameters I have specified (width,
height, border, gap etc...). I would like it to be able to check if
the current rownumber in the array (as it is filled in) is in a list
of numbers on my spreadsheet. This is so that I can write into my
spreadsheet the numbers of the portrait orientated pictures, and the
array will put into a box that this picture number is portrait
orientated (important for data later in my code).
I have only been using VBA for a few days, and I have managed to
produce all of my code using help files and google groups, but I can't
find how to do this anywhere.
Also, if possible, I'd like to be able to write my list in one cell -
using the same style as when you print selected pages. ie, 1-12, 14,
16-21 would select pictures 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14,
16, 17, 18, 19, 20, 21. Is this possible?
Please help!
Simon
 
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
Numbers aligning in a table Basharat A. Javaid Excel Discussion (Misc queries) 0 August 22nd 09 08:59 PM
Add = sign to table of numbers Dewayne Excel Discussion (Misc queries) 3 August 22nd 09 04:28 AM
Missing numbers from the table Javed Iqbal New Users to Excel 1 June 13th 08 03:27 PM
shuffle table of numbers WLRobi Excel Discussion (Misc queries) 1 April 17th 08 12:17 PM
how do i shuffle the numbers in a table? inkap Excel Discussion (Misc queries) 2 October 3rd 05 02:44 AM


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

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

About Us

"It's about Microsoft Excel"