Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SSS148 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 dehnemi

  1. dehnemi

    Viscous Heating Problem (reality check)

    I have been trying to solve several viscous heating problems using a CFD tool. I do not have a lot of wind tunnel experience and therefore do not have any way to “litmus check” the results I have been getting so far. The idea is to prove that one shape is better than another with respect to...
  2. dehnemi

    Associate a selected range of cells with a Named Range Object

    Thanks everyone for the help! Mutt, I kept getting the following error with your approachs: "Object variable or With block variable not set" ab123456, You nailed it on the head, I had tried something similar but did not have the syntax correct! Still learning this VBA notation...
  3. dehnemi

    Associate a selected range of cells with a Named Range Object

    In Excel VBA, how do you associate the currently selected cells to a named range object? Dim myRange As Range ' Set myRange = Selection ' Set myRange = ActiveCell.CurrentRegion neither of these seemed to work!

Part and Inventory Search