Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbers aligning in a table | Excel Discussion (Misc queries) | |||
Add = sign to table of numbers | Excel Discussion (Misc queries) | |||
Missing numbers from the table | New Users to Excel | |||
shuffle table of numbers | Excel Discussion (Misc queries) | |||
how do i shuffle the numbers in a table? | Excel Discussion (Misc queries) |