Search results for query: *

Hi, I'm confused. I can't get XL to programatically set the print on a sheet to the mulitple ranges that I have as a print area on another sheet! Now normally I'd use With ActiveSheet.PageSetup .PrintTitleRows = "$1:$5" .PrintTitleColumns = "$A:$F"...

Hi, I'm confused. I can't get XL to programatically set the print on a sheet to the mulitple ranges that I have as a print area on another sheet! Now normally I'd use With ActiveSheet.PageSetup .PrintTitleRows = "$1:$5" .PrintTitleColumns = "$A:$F"...

Hi, Have a problem using replace in a macro. I have no education at all in VB, everything i do is "self taught". This means that I rather include recorded code when possible, since I'm not a very competent code writer myself. The problem is that the recorded code doesn't work...

Hi, I have a user who is experiencing the strangest problem... She has a database which contains several hundreds of rows of data. Column "L" contains unique numbers. Sheet 2 (col "a") contains a number cells with the same kind of numbers as previously mentioned in sheet1!L:L. The main issue...

Hi, I get the following error message when trying to save a template (kind of, anyway, my version is in Swedish): 'Excel cannot complete task with available resources. Choose a smaller amount af odata or close other applications' (OK button only) This is followed by an immediate new msgbox...

Hi, Having problems with DSUM-functions. I'm successfuly using the function in a big template to calculate the differences between the sum bought and sold units of certain products, with data from two different (uncompatible) systems. The function used is the same in all cells (250 rows * 30...