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 Chriss Miller 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: opiess
  • Content: Threads
  • Order by date
  1. opiess

    getpivotdata in VB

    Is there a way to use the getpivotdata excel function in a vb function? I'm trying to write a function that pulls data from a pivot table based on the function inputs. For example, I'd like to enter this in excel: =myfunction(sheet2!a5,b1,b2,b3) where sheet2!a5 is a pivot table cell b1: time...
  2. opiess

    Function that returns cell location

    Is there a way to return the location of a cell as text in a function? For example, I'd like to write a function like this: =text(sheet1!a6) and it returns something like "The cell you are referencing is sheet1!a6

Part and Inventory Search

Back
Top