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 bkrike 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: RandySS
  • Content: Threads
  • Order by date
  1. RandySS

    Excel Macro to Articulate & Reset MS Word List Bullets

    REFERENCE thread222-1723548 Hi All- Can you please advise how to use an Excel Selection Object to articulate a Word paragraph bullet from Excel. I'm told I'm trying to articulate via a Word Selection Object from Excel. Frankly, I don't know the difference. The particular piece of VBA that...
  2. RandySS

    Excel Macro to Articulate & Reset MS Word List Bullets

    Hi Folks, Am using Excel VBA macro to create a MS Word document. Seeking efficient method to reset bullet lettering in Word list back to its first value, that is, reset to “a)” prior to printing a second, or additional list. I'm using template and styles in Word to establish desired...
  3. RandySS

    Excel cell value used in formula as row number of address in 2nd cell.

    Hi Folks, Am trying to avoid using VB to accomplish.. What would be the formula in cell #3? Value in cell #1 is "85" , for example. Cell #2 is located at Column 10, row 85. I want formula in cell #3 to return value of cell #2. Column number in formula in cell #3 would be fixed, I use...
  4. RandySS

    "Teams" web page as entry point to Access dbase of zip codes.

    Hi Folks, Am trying to create a rudimentary "teams" web page that allows visitor to determine if a team exists in a nearby zip code region. ("Does your zip code exist on our list of team's zip codes?") Am trying to figure out how a data entry field in a web page can serve as criteria for a...
  5. RandySS

    Quotes Appearing

    Hi Folks! I'm sure I'm overlooking an obviouse, but can't put my finger on why quote signs are appearing in the value stored at the below tag's address. I want stored at Tag is: 12345 I'm getting stored at Tag is: "12345" '***START*** Dim Tag Dim VariableRow VariableRow = 1 'Value entered...
  6. RandySS

    Why do apostrophies appear in cell?

    Hi Folks, Below subroutine seems to create the desired formula okay. However, when formula is written to target cell apostrophies seem to have been inserted, making the formula non-functional. Desired formula is: =Sum(F1:F5) Inserted formula is: =Sum('F1':'F5') How do I build VB code such...
  7. RandySS

    Using Boolean logic in VB, AND, OR

    Does Excel's VBA support the use of Boolean logic, such as OR, or AND? For example, If ...Column = 1 OR 3 OR 8 Then... Specifically, as used in If Then Else statement is most applicable. Thanks!

Part and Inventory Search

Back
Top