General

running a Macro in 2007 which was created in 2003
Hi there, I hope you can help, I am not VB literate unfortunately but I am trying to run a macro with the following line of code which creates an error: LastRow = Master_Wksht.Range("N" & Rows.Count).End(xlup).Row Is there a change between versions which means this line won't work any more? ... 23 Apr 2010 01:23

Replacing carriage returns with a comma
thanks sue the ctrl J worked for me. the Alt 013 didnt - saved me a couple of couple of delete down arrow, delete down arrow, delete down arrow. "Sue Compelling" wrote: Thanks FSt1 for the quick response - I also kept searching and discovered the very simple Find CTL J Replace , R... 22 Apr 2010 04:07

protecting a file from extension change deletion or move
hi can anyone tell me a way to stop a user of one of my spreadsheets from changing the file extension, deleting the file or moving it elsewhere within our drives? my sheets are used by many poeple and added to daily but it seems someone has been careless and accidentally deleted some vital sheets any help would... 22 Apr 2010 09:18

Saving Autorecover info in 2007 so SLOW!
I've had to disable it. Its soooo slow (eg 5 minutes and more to save autorecovery info on a file that saves in under 30 seconds!). Any ideas why so? I'm on Office 2007, Win 7 using files that were generated years ago under Excel 2000 and have worked flawlessy prior to "upgrading" (ha ha) to Office 2007. Al... 23 Apr 2010 01:23

Autofit
I have an excel sheet that I have set "wrap text" on most cells. I have no merged cells however the autofit will not work. I dont know where/how to fix this. Any help would be greatly appreciated. ... 22 Apr 2010 08:16

Use of table and Scenerio in data and tool menu
what is the use of table command in data an Scenerio command in tool menu -- Sajjad ... 22 Apr 2010 02:03

Personal Macro
hi community when i closed the excel workbook with a personal macro recorded, why my excel did not prompt another alert to ask whether i wish to save the personal macro, it only prompted me whether do i want to save the workbook? I am using excel 2007 in os vista can community kindly help me on this? th... 22 Apr 2010 03:05

EXcel 2003 Page setup slow
Would changing printers from one using an LPT1 connection to a USB connection also slow down Page Setup? I have home PC with only one printer. "Dave Peterson" wrote: I'm guessing that it slows down to go to the printer driver to see how things should be laid out. You may want to try getting a fresh... 22 Apr 2010 08:16

Printer Using USB Port Slows Page Setup
Recently in Excel when I click on Page Setup or Print Preview, the response time slows to a crawl, as does every operation after that, like scrolling or adding rows or columns. I recently installed an HP Officejet Pro 8000, which uses a USB connection to an older Dell desktop. This printer replaced an HP Lase... 22 Apr 2010 08:16

Match formula
I have a spreadsheet with 4 columns, each with a list of names. The names are mostly the same, from 4 different resources, but some are mispelled. I would like the 5th column to say True/False or Y/N if any of the names in a row do/do not match, assuming blank cells as a match. Ex. DB Cisco ... 21 Apr 2010 19:51