Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Recent content by minnesota

  1. minnesota

    Get 2nd parameter of ROW reference to use contents of a specific cell

    In VBA how do I enhance this line in a macro to use the contents of cell A1 as the end of the range? Current: Rows("2:200").Select Desired: Rows("2:A1").Select I have guessed at various syntax and cannot get it to work. Thanks very much.

Part and Inventory Search