Recent content by BluByU

No, it's not theory. I coded all of this VBA code by hand and did not record a macro. I am using a explicity referenced range object. Anyway, the problem is resolved, thanks.

You were right Skip. I didn't have a range selected when I performed the SORT on the data column. Once I tried that, I got another error which said that the column I was sorting on was "not in range" (when it was). I then changed the format on the SORT column to an explicit date format and...

Thanks for your response, but is there a way that I can do this from inside ADO? If I copy the recordset to a sheet and then sort by the desired column, that column is sorted, but not the rows on the spreadsheet associated with them. So, I don't think whis will work, unless I am missing...

I am having a problem with VB script in an Excel spreadsheet that is calling a stored procedure. The stored procedure I am calling is used by other spreadsheets and has a sorting method that I want to override. I don't want to change the stored procedure, but just change the sort order in the...

Hello. I have a spreadsheet that has a "stoplight" display which is essentially 3 small circles colored red, yellow and green. Each circle is in its own cell. Is it possible to put these shapes into a drop down list so that when the user selects one of them, a predetermined cell is filled...

I hope this isn't a stupid question, but here goes. If I know the index number of a column, how do I retrieve in VBA the alphabetic column header name? Example: Column 47 of the spreadsheet is "AU". The formulas I need to modify on a worksheet use the format: "=SUM('Master sheet v2.0'!AR14)"...

Well, I just got it to work. here is what I had to do. The VBA code was triggered by a command button click on the spreadsheet. I read somewhere else that the command button couldn't have focus in order for the "button click" event to work properly, so I changed the property on the button...

Can someone please help? I really need to get this working. Thanks in advance.

The full error message is: Run-time error '1004' Method 'Publish' of object 'PublishObject' failed.

Thanks for the response. However, the "objPublish.Publish False" statement still returns a "1004" run time error. I have entered the code just as in your example. Any other suggestions on what might be going wrong?

The code below returns a run-time error 1004 on the Publish method. I don't know what VB is complaining about. Thanks in advance for your help. Set objRange = ActiveSheet.Range("A1:Q33") objcoord = objRange.Address Set objPublish = ActiveWorkbook.PublishObjects.Add (xlSourceRange...

Is there any way in VBA Excel 2002 to use the "Republish: Sheet" feature when saving the active worksheet as an "html" formatted file? The online help for the "SaveAs" doesn't show this feature as available. Any suggestions? Thanks in advance.

I have a user who has created a spreadsheet used for data entry. He has placed some "VLookup" formulas in several of the input cells to create drop down picklists. However, when a user enters and saves a new value that is not in the picklist, the "VLookup" formula is lost and overwritten by...

Thanks a lot! That fixed it. I guess the "row" numbers must have been confusing Excel. This is a great forum!

I've done a forum search, but none of the topics seems to have a solution that works. I simply need to set the ".columnwidth" property of a spreadsheet to a certain width. I tried "autofit" (which is preferable to me)that also didn't seem to work. Here is what I am doing in VBA...