Recent content by rlee16

Bronte, I just had the same thing happen to my Toshiba M200 Tablet PC. Does anyone out there know how to fix this? Ugh.

I had been querying stock/financial data from Yahoo (non US) but it has recently upgraded its pages for that country to javascript and so now each page no longer has its own URL. I had been using simple VBA code to automatically get this data. Now I can only get the first page. When I hover over...

thanks everyone especially to byundt, As byundt mentioned, i messed up on the fourth parameter, I can't believe I missed it. Thanks!

I would like to clarify that at first both the cell with the VLookup formula and the cells with INDIRECT formulas were accessing the name of the Company is pull in data. (The Vlookup formula is trying to pull in data from another workBOOK, whereas INDIRECT formulas are pulling data from other...

[Task]: I am trying to add some data from another workbook to this Summary by using vlookup on the name of company (which is hard-coded, not a formula). Simple, I've done this a million times, nothing is wrong with the formula. [Problem]: However, Vlookup is not returning the correct values...

Thanks Skip and PHV, I combined both of your postings into the following workable solution. Those little single quotes were tough to debug! RefersTo:="='" & ActiveSheet.Name & "'!" & ActiveCell.Address

I would like to name a particular cell in every worksheet "Sales" using VBA. Thus Sheet A would have A!Sales and Sheet B would have B!Sales. The following is a snippet of my very amateurish code. How can I code the RefersTo:= so that it is using variables instead of the hard coded cell address...

Thank you Dace! Exactly what I needed. Richard

I would like to rename my worksheets depending on the presence of a word in a text-filled cell A1. Basically, my problem is that I do not know the syntax to find one element of many in one cell. Do I need to parse out X from the sentence contained in A1 first? Sub RenameSheet() Dim wkst as...

Is there a way to use VBA to automate the process of updating data labels (for a series not a data point) on an excel chart? I have a line chart graphing a time series. I also have horizontal lines for max, standard deviation, average, and min. These are labeled as such: max1.88x, 1sd1.36x...

Zathas, Using this method, is there a way I can I preserve the ability to click into the worksheet functionally equivalent to "Userform1.Show (0)". Thanks. Richard

Zathas, Works perfectly! Thank you. Richard

Clarification - I have several command buttons on my excel worksheet, each corresponding to a different page on the Multipage Thread707-669091 seems to only describe setting the focus once. I would like my command buttons to be able to jump to any of the pages. Private Sub...

I would like to have a command button on my excel worksheet be able to open up a Userform and jump right to a specific page(in this case, Page2) within a MultiPage. Is this possible or do I have to make a brand new Userform? Regards, Richard

New virus? I was able to successfully rid my computer (running XP home edition) of msblast virus a few days ago. Yesterday I was FTP'ing files to my website and soon after my computer started exhibiting the similar problems from msblast (i.e. continuously rebooting). My computer may have...