Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Azban65
  • Content: Threads
  • Order by date
  1. Azban65

    Copy a sheet from a closed workbook?

    Hello, How can I copy from a closed workbook into an open workbook? I tried with the Getdata command but it's for range, I like to copy the whole sheet to keep the hyperlink, format etc.... Thanks Azban
  2. Azban65

    Hyperlink in a protected sheet

    Hello, I try to add an hyperlink in a protected sheet within a macro. It was working well at the beginning, but for some reason, now I have to unlock the cell to use the hyperlink when I protect the sheet. But now, when you click anywhere on the sheet the hyperlink is activated.... I tryed to...
  3. Azban65

    Increase column letter

    Hello, I like to increase the column letter or number in VBA. But none of the code I tried work. I like to do: For i = 15 To 196 For j = 15 To 196 if Workbooks(Myname2).Sheets("training").Range(i & "15")= Workbooks(Myname2.Sheets("training").Range(j & "15") Then...

Part and Inventory Search

Back
Top