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 Westi 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: *

  1. Naomi72

    How do you delete a row in excel using vba based on several cells

    Thank you all, very helpful, I'll try them out in my code. Many thanks!!
  2. Naomi72

    How do you delete a row in excel using vba based on several cells

    HI Skip, I've spent qute a while sifting through the results on delete rows, and picked up quite a few interesting tips, however none addressed my dilemma, all seven cells in that row must contain 0 for me to delete the row. Any ideas ? Many thanks!!
  3. Naomi72

    How do you delete a row in excel using vba based on several cells

    Hi, I'm trying to delete rows in an excel spreadsheet using vba based on the fact that all the cells in a row in columns l -> r contain 0. Many thanks!!
  4. Naomi72

    How can I use values in a formula in VBA

    Thanks a million Geoff, that worked fantastically. Kind Regards Naomi
  5. Naomi72

    How can I use values in a formula in VBA

    I'm trying to automate some excel procedures using vba. Currently I'm having difficulties when I need to insert a formula into a cell that takes values such as the row and the sheet name in a file, and passes then into the formula. SheetName is entered in a form. MyRow = Selection.Row Formula1...

Part and Inventory Search

Back
Top