General

VB help SELECT COLUMN / PASTE FORMULA'S
hi, i am trying to copy formula's down a sheet (1 column), will need separate method of: paste-special: formula, forma, both - will use shortcut keys: alt -x.. (so this goes to a module?) - want to paste to column, from cell selected (anywhere in column) dynamic select rows automatically from row x to ... 23 Jan 2010 07:40

retriving data from different work sheet
hi i have a way to do this but i require the workbook to do it..... If you dont mind send it to angelshree101(a)yahoo.co.in Al wrote: Importing numbers from 200 worksheets into 1 16-Jan-10 I wish to import numeric data from numerous worksheets, say upto 200, into an overall summary page. For example, I ... 23 Jan 2010 06:35

XLSX Files Will Not Open
Using Windows 7 / Excel 2007. I can open old xls files using Excel 2007 but can not open any xlsx files. When I select an xlsx file to open, a new blank worksheet opens instead of the selected file. The "ignore other applications" box is unchecked as recommended in other posts and I have re-installed Office. ... 23 Jan 2010 00:09

How do I load Excel using the Project Key only
... 25 Jan 2010 11:41

Cannot delete a worksheet in Excel (Office 2007), but the option i
I'm trying to delete a worksheet in Excel (Office 2007), but the option is | greyed out under "Edit" drop - down menu, what could cause this? What's the fix? ... 22 Jan 2010 19:44

Name Ranges
How do I avoid duplicating name ranges after copying cells that contain a name range? -- Steve ... 22 Jan 2010 17:29

How do I find my previous post ?
Open this reply and move to your question. Click on your name to see your profile. Click on Recent Posts by this user. Select your post and double click the post. HTH on OAP to another. "Slim" wrote: -- Slimone ... 22 Jan 2010 17:29

How do I create a form in Excel that I can send to be filled out?
I want to create a form in Excel that I can send out so people can fill it out electronically and then send it back to me. I need lines in the form and when I add lines I have to widen the column and then it messes up the previous wording. I know it can be done but not sure if I have to protect it, create a t... 23 Jan 2010 02:18

Run time 1004
I am trying to use the Reuters quote function in a macro. I have created a string that gets the symbols and date from cells of the excel file. I can successfully have the strinf displayed in a message box to show that I have successfully created the function for reuters. However when I attempt to have this i... 22 Jan 2010 16:21

Excel 2003 doesn't recognize russian text
... 21 Jan 2010 20:20