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!

Recent content by Azban65

  1. Azban65

    Copy a sheet from a closed workbook?

    aaaaaaaaaaarrrrgggg sure??? Anyway, It's working like that, but it's just long... Thanks
  2. 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
  3. Azban65

    Hyperlink in a protected sheet

    yes, it's exactly what I'm saying. But at the first time, with the same settings, even in a locked cell the hyperlink was working. I don't know for which obscure reason but now it's not th ecase anymore. Is there any easy way to add a shape into a box? because a shape is place by coordonate....
  4. 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...
  5. Azban65

    Increase column letter

    Thank you PHV, Sorry I wrote the last answer as the same time as you answered me! It work perfectly this way! Many Thanks subsiduary question: How do I keep a button action link to the new workbook when i create and save it? I did that Windows(Workbookname).Activate...
  6. Azban65

    Increase column letter

    ermmm, My understanding of VBA is really limited. I do that by learning on forum etc... I don't understand what you mean by Data tabular. The both data are on the same row and nearly same column. the fact is that I look for the same OP instruction on the whole for each instructions. It's...
  7. Azban65

    Increase column letter

    I got two training matrix, One new generate by a macro I wrote with the new operator instruction and their number. The second training matrix is the old one. The code select the old file through a windows, and open it. MyName is the new file and Myname2 the old file. Now the macro copy the line...
  8. Azban65

    Increase column letter

    I don't know how to use this property correctly with my coding. The fact that I'm working on 2 windows seems to be a problem here. Here is the code: Set MyRange = Workbooks(Myname2).Sheets("training").Range(Cells(19, i), Cells(opend, i)) MyRange.Copy That Doesn't...
  9. Azban65

    Increase column letter

    Hi sorry, It's still about the same problem. I need to select a range, I don't know how to do it with the column number andthe cells property. So I use when i>=27 columni = Chr(Int(i / 26) + 64) & Chr((i Mod 26) + 64) But I got an error when I reach AB I got A@ instead...
  10. Azban65

    Increase column letter

    Hi tony, Many thanks!!! it works!
  11. 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...
See more

Part and Inventory Search

Back
Top