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!

  • Congratulations strongm 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: markozzz
  • Content: Threads
  • Order by date
  1. markozzz

    Excel vba - Easy Range question

    Hi, I couldnt figure this out.. In this sentence: ...Sheets("Sheet1").Range("G:J"), 4, False) in .Range("G:J") i would like "G" to be a variable. Like .Range("(Var),J").. But that obviously doesnt work. Help please? Rgds, Markozzz
  2. markozzz

    Excel - converting IF statement to Select Case

    Hi, i have a rather easy problem, but i cant seem to work it out correctly.. I have a looong IF-statement, which i have to convert to an SelectCase statement. The statement should apply to all rows in a distinct column (H), or at least 10000 rows The IF-statement i originally made, was like...

Part and Inventory Search

Back
Top