Recent content by arbeeone

The macro processes what is essentially timesheet data extracted from a corporate data base and then does a LOT of formatting! At the moment, it had been a local office initiative but the desire is to distribute it nationally to all other offices. Some of the output goes externally to customers...

Hi, What I'm wanting to do is create a macro which, in addition to formatting a data file, also prints the Company Logo at the top of the page. The problem is that once the macro is distributed, there would be no common source from which to import the graphics. So, is there any way to embed a...

Hi, I'm trying to manipulate a string of up to 40 characters in length which is basically a free-form entry although there are some basic 'standards' for data entry. I have the feeling I'm missing something very simple, but I want to be able to identify the first alpha character (i.e. A-Z only)...

I was trying to avoid going to multiple sheets if possible because the reports would themselves then have to be sorted, or it would require a potentially large number of print commands. Although there are three report 'types' as shown above, there are potentially many more than just 3 reports...

There is a single large input file coming into Excel which is being reformatted using VBA into 3 types of reports: a) detail b) first level summary (based on certain fields) and c) overall totals, plus some quite 'fancy' formatting that is required (colours etc). Each of the 3 types of report...

I'm wanting to repeat 4-5 header rows on each page (NOT Header/Footer) but also to change the Rows that are printed at different, known stages through the report when I force a Page Break. By using the .PrintTitleRows feature, I can print one set of header rows, but I can't see how to change it...

Thanks Geoff, I'd tried 2 or 3 different combinations of concatenation but not that one! rsb

I've tried this, but the problem is that the macro recorder gives specific row numbers (e.g. Rows("10:11") ) but I want to have them as variable names. I've tried Rows("r:r1") and Rows(r:r1) but neither seem to work. rsb

Hi, I want to insert multiple rows into a worksheet using VBA. I can insert a single row using: Rows(r).Insert - where r is the row number But, Rows(r:r1).Insert (where r1 is the last row number) doesn't work. I've tried using the Cells method for the Range but this also gives me problems. I...

Oooops, I've just tried the formula again only this time using [A1].Formula rather than [A1].FormulaR1C1 and the Sum code worked! - So thanks Skip!! However, I still have the problem with inserting rows, so I still need help there if possible. rsb

Hi, I have the same basic question. I have tried the code as recommended above by Skip but when I run it in a macro, I am getting the formula come out as =SUM('S13':'S17') (these are the cells I want, but not in quotes). As a result, I'm getting #NAME? in the cell. Any suggestions? Also, I have...