Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
VB to rename&hyprlnk to new sheets
Name: askedit Date: February 22, 2007 at 19:44:31 Pacific OS: xp CPU/Ram: p4; 1g Product: hp
Comment:
In excel I have a macro that finds the last cell in a column, selects the next cell down and inserts a value of N+1 (where N is the previous cell’s value). It then inserts a worksheet and renames it the value of the new cell (N+1). How do I add to this macro an instruction to also create a hyperlink from the cell (N+1) to the corresponding worksheet with the same name? Basically, once I have many worksheets created, I want to be able to use the original column list as an index from where I can click and zoom to the corresponding sheet.
Summary: Excel2000 I have a file where i record hours flown. Each different aircraft would have it's own sheet. The totals of every sheet has to be carried over to the next sheet. New sheets are inserted fr...
Summary: oh Please help-I am a novice and I typed a paper and it is lost. I pulled up a document from 'my documents'-it was a saved template. I typed on Microsoft word (2002)and pushed 'save' as I went. When I...
Summary: I want to put some titles (name, number, address, etc.) in seperate cells at the top of my excel page. When I scroll down I would like to have the titles to always be there in view, how is this done. ...
0 
