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.
excel vba for hyperlinks
Name: deadpet Date: February 13, 2008 at 14:06:19 Pacific OS: xp CPU/Ram: n Product: n
Comment:
I am trying to set up an excel sheet which sets up client databases. Each sheet is a client so I want a main sheet to set each one up and I click and jump to their sheet. The followng text fails me.....HELP?
Sub Macro1() Dim asa As String asa = InputBox("Enter name:") Sheets.Add.Name = asa abba = Sheets("main").Cells(1, 9) Sheets(asa).Move Before:=Sheets(3) Sheets("main").Select Cells(abba, 1).Select Dim hiu As String hiu = abba & "!A1" ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ hiu, TextToDisplay:=asa Sheets("main").Cells(1, 9) = Sheets("main").Cells(1, 9) + 1 End Sub
Summary: I am in need of assistance of an excel vba macro that i am creating. I am calculating the Canadian dollar by multipling cell "F2" * "G2". However, I am using a loop to do this and I am having troub...
Summary: I'm trying to save an excel spreadsheet with the filename of K&N.csv but when I try and do this from within my macro, excel crashes when the workbook is closed. I can save the file and close the workb...
Summary: Hello, i have programmed a code in VBA for Excel, wass running smoothly on my old machine, now new computer it says when i run the macro, it says cant find object or library. i know the solution with ...
0 
