|
|
|
|
5 |
264 |
|
|
|
|
4 |
260 |
|
|
|
|
6 |
252 |
|
|
|
|
1 |
224 |
|
|
Macro to automatically print & save as PDF by
PaulaK
I need some help to write a macro that will automatically print a worksheet &
then save it as a PDF document to a specific location on the server.
The work...
|
|
1 |
360 |
|
|
|
|
3 |
265 |
|
|
2 variable Lookup by
andrewevandc
I know how to use vlookup but on only 1 variable.
I have a table with two variables, part # and count, and I want to be able to
look up a 3rd variable with...
|
|
1 |
235 |
|
|
range names by
Sanford Lefkowitz
I have a large number of range names such as
ran1 referring to a1:a200
ran2; referring to b2:b200
down to about ran40
I want to change all of these so they go...
|
|
1 |
247 |
|
|
Parse variable length strings by
Ray
Hi -
I have a data-dump that's used as the source data for a variance
report. One of the fields contains a transaction date and the name of
the purchaser ......
|
|
3 |
235 |
|
|
For each this, then that and that by
wal50
If I drop the "X" part, the below will shade the cells I want. I just can't
get the syntax for adding - ActiveCell.Offset(0, 1) = "X".
I have tried...
|
May 15th, 2009 08:51 PM
by wal50
|
3 |
237 |
|
|
Fill in cells with an array by
dgh
I have a row of numbers that I want to fill into a row only if a variable
cell increments by 1. For instance:
Array = 200 10 5 6 8
Variables ...
|
May 15th, 2009 08:42 PM
by dgh
|
0 |
230 |
|
|
|
May 15th, 2009 08:41 PM
by Tony
|
0 |
225 |
|
|
File Size ? by
Ken
Excel2003 ... I have a File approx 122mgs ... I deleted almost half of the
old WorkSheets & the File size only dropped by 6mgs ... Does this make...
|
|
1 |
202 |
|
|
Index Match ? by
Rugby Al
In my worksheet I rows of values as follows in individual cells
ABC 72 30 DEF 67 20 GHI 77 33 JKL 80 12
DEF 77 23 GHI 77 34 ABC 73 31 JKL 81 13
and so on.... ...
|
May 15th, 2009 08:25 PM
by CLR
|
3 |
200 |
|
|
Insert text depending on font colour by
Tricia
I have a list and was wondering how to do this:
I want to insert a certain word at the beginning of the paragraph in each
cell that has red font. A...
|
May 15th, 2009 08:15 PM
by JB
|
2 |
226 |
|
|
Linking drop down lists to another list by
locobo81
I am trying to create drop down lists that are dependent on the selection
made from a previous drop down list.
For example - My first drop down list contains...
|
May 15th, 2009 07:39 PM
by JB
|
2 |
223 |
|
|
|
|
7 |
232 |
|
|
|
|
1 |
197 |
|
|
copy and paste 2900 times macro by
DLB
I have 11 rows of data that I want to copy and then paste 2900 times in the
same spreadsheet. Is there a macro that will perform this function?
|
May 15th, 2009 07:20 PM
by DLB
|
2 |
197 |
|
|
clear cells when workbook is opened by
Wanna Learn
Hello I want to clear some cells everytime the workbook is opened. the
cells are found in a worksheet "Form"
this is the code - does not do anything...
|
|
6 |
215 |