Does anyone have any suggestions on loading the web link into Excel?
Following codes is working before, recently when I run the macro, it can
open the wb.Sheets("Industry Indexes"), but fails to copy into Sheets("Temp")
and close it.

Howdy!
I am trying to organize a spreadsheet which originated out of a PDF report.
I cleaned the headers and pagecount etc. and now have the data stacked in
colum A of sheet1. Now the challenge is to loop through the rows and move

I have a table which has one blank row between row 1 and row 3 and
then there are several rows of data. How Can I name this range in vba
I cannot delete the blank row
Any suggestions?

Does anyone have code that will loop over all the macros in a workbook and
remove any shortcuts assigned to the macros??
Thanks for any leads.

My goal is to be able to insert the login time of the current Windows
user into a cell in Excel. I have searched the net extensively, but
although there are plenty of ways to find the user NAME, i can't find
any way to find the time that they logged in. Windows obviously

I have an Excel macro I use to run weekly reports for 30 or so employees in
my office.  The macro saves each employee's report as a separate workbook,
attaches it to an Outlook e-mail, and e-mails it to that employee.  I've
been doing this for a while now without any trouble.

Using Visual Basic 6 (not VBA) and Excel 2000
I have graphics and text grouped together on a worksheet.
I need to update the text.
Trying to ungroup in the follow code I get run time erro 1004 "Application-

I have a code that inserts a validation list into a cell.
With ycell.Offset(num, 0).Validation
   .Delete
   .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _

Is it possible that when a user clicks on a hyperlink, the custom view
appears?  And how would I write that into a macro?
Annette

I need to take a column of numbers 1235.36 and change to 123536 with a number
of leading zeros. End result 0000123536. Is there a format or function to
accomplish this task?
Thanks for any suggestions.

I need to use the average function in the row after the last row of data in
column B that calculates the average of range (B10:last cell of data in that
column).  Then I need to fill that row to the right with that same average
function, stopping the fill at the last column of ...

Why can't I find my conversation with a tech from yesterday.  I did a post at
yesterday evening and now can't find it.  It was subjected Copy and Paste?
Eric

I have some code where I use a templated chart to make a copy:
   Debug.Print "    MC 0: " & Now()
   Dim chtObjTemplate As ChartObject, wsCharts As Worksheet
   Set wsCharts = ThisWorkbook.Sheets("Charts")

There must be a bug in Excel 2007.  I have created a pivot table and when I
choose "top 10" for the field, the data does not change.  It's as if i di
dnot choose top 10 at all.
Help!  This must be a bug.

I am trying to programmaticly (vba) prevent users from editing any cell in
one specific column without haveing to 'protect' the entire worksheet.