Business Software

Recent Answers

2013-05-21 Excel - Search for part of cell value:

It's always difficult when data doesn't exactly match - but there isn't (as far as I know) a quick way of handling this - however, you can do it in a number of passes - firstly, you've done a look up which

2013-05-20 Excel - Inserting images into excel file:

Amit,      Well, since the row height is adjusted to the height of the picture, I wouldn't see that being in the center.  Not sure what you thoughts are on that.     If you want to center it in the center

2013-05-20 Excel - Inserting images into excel file:

 Amit,    this is where it uses column B to get the list of pictures    Set r = Range("B2", Cells(Rows.Count, 2).End(xlUp))      So you could do     Set r = Range("B2", Cells(Rows.Count, "B").End(xlUp))

2013-05-20 Excel - Inserting images into excel file:

Amit,    row height is limited to 409 - so as long as 50% of the height is less than 409, the row will hold the picture.  If it is creater than that, then it will make the height 409.      I tested it

2013-05-20 Microsoft Word - Word 2010 footer:

Hi Rick,    To automatically show the print date/time: Place cursor in the footer > Insert > QuickParts dropdown > Field > select Print/Date (choose preferred format) > OK.    A field does not exist as