Search:

Type: Posts; User: teachman; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Object Variable or With block variable not set error

    I'll give that a try the next time I need to ask you guys some questions. And, there WILL be a next time;)

    Thanks,

    George Teachman
  2. Re: Object Variable or With block variable not set error

    I think the problem is related to IE11. When I connect to Mr. Excel using IE over the Internet speed between me and the Mr. Excel server slows to a low baud speed. So slow that I have to physically...
  3. Matching value in Range("A5") against a list of items

    Hello,

    I have a script with an IF Range("A" & r) value is also in a lookup list AND Range("I" & r) THEN do something. I know I can do a bunch of ORs but that doesn't seem particularly neat.

    IF...
  4. Re: Object Variable or With block variable not set error

    MrExcel seems to have changed its way of replying to a thread answer or question. So, hopefully this will work. Buried deep in the code I found a stream.Close line after which there were other...
  5. Object Variable or With block variable not set error

    Hello,

    Using stream.WhiteLine in a VBA script is giving me the Object variable or With block variable not set error msgbox. Clicking on the Debug button brings me to the line that is written...
  6. Replies
    4
    Views
    129

    Re: 2013 workbooks don't work in 2016, WHY?

    Michael,

    There doesn't seem to be an option to save a workbook to a 2016 version.

    There really isn't any VBA involved here. The first worksheet is named Front the second worksheet is named...
  7. Replies
    4
    Views
    129

    2013 workbooks don't work in 2016, WHY?

    Hello,

    I'm starting to sweat over something I just discovered. An Excel workbook with a Form as the first worksheet and the values transferred to the second worksheet that I created in Excel 2013...
  8. Re: Can't find the ampersand character in a character string

    Well, son of b*.

    Just to be clear, I didn't have that check box checked. I originally started this trip thinking that the & was one of those special characters and I tried multiple ways of...
  9. Re: Can't find the ampersand character in a character string

    With Ctrl F
  10. Re: Can't find the ampersand character in a character string

    I'm really just trying to find cells with & in them. I'm not interested in where the & is in the cell.

    Thanks,

    George Teachman
  11. Can't find the ampersand character in a character string

    Hello,

    I'm using Excel 2016 and am trying to find the ampersand character (&) in a cells that are just characters. There is no = at the beginning of the string. Something like Victory &...
  12. Quick Access tool bar reverted to the default display.

    Hello,

    I have been in and out of Excel (365 ProPlus) several times today. After exiting the last time and then starting it again I noticed the Quick Access Toolbar has reverted to the default...
  13. Way to use type ahead in a validation list?

    Hello,

    I use a lot of lists in Data Validation. It gets tedious to bring up the list and scroll through until I find the one I want. Is there a way to use type ahead to select the choice without...
  14. Replies
    9
    Views
    301

    Re: Reducing a Selection by one cell.

    DanteAmor,

    Wow, that went through all records (> 28,000) so fast, I thought it hadn't worked. But it did.

    Mr Rothstein's suggestion also worked.
    Fluff's suggestion also worked.

    All were...
  15. Replies
    9
    Views
    301

    Re: Reducing a Selection by one cell.

    Cell A10's value should be entered into cells A11 to A19.
    Cell A30's value should be entered into cells A31 to A45.
    Cell A76's value should be entered into cells A77 to A99.
    etc.

    Thanks,
    ...
  16. Replies
    9
    Views
    301

    Reducing a Selection by one cell.

    Hello,

    Today is just one of those days that Excel just keeps beating my butt. After an hour of trying to write a simple three line code and getting nowhere I have come to the experts.

    The...
  17. Replies
    3
    Views
    111

    Re: Find in a column

    Ross,

    That worked like a charm. There were over 28,000 rows to look in and it all happened in the blink of an eye!

    Thanks for the help,

    George Teachman
  18. Replies
    3
    Views
    111

    Find in a column

    Hello,

    I want to find the string "Size" in a specific column and then delete that row. I'm having problems with the find function. When the sub is stepped thru I get a Type Mismatch error.
    ...
  19. Replies
    1
    Views
    788

    Copy Access table structure to Excel

    I have an Access database that is being converted to another language and I need to know all the various pieces and parts to create an SQL script that creates a table. So, I need to know the...
  20. Re: LEFT(A1,5) gives the same as LEFT(A2,5)

    Rory,

    Yep, that was it. It never dawned on me because I have never had any reason to use anything but automatic calculation. Looks like Excel is trying to think again.

    Thanks,

    George...
  21. LEFT(A1,5) gives the same as LEFT(A2,5)

    Hello,

    I'm having issues with the LEFT workbook function. See below for the example with the formula of =LEFT(A2,4).

    A B
    ...
  22. Re: Formula in a cell disappears when data is entered

    Their are no user forms. Their are no macros used to enter the data. All of the code their is is what is in the cells mentioned. I thought about if the cell was protected or unprotected but...
  23. Formula in a cell disappears when data is entered

    Hello,

    My problem is that I have a cell that concatenates 4 other cells. For example cell A1 has the following formula: =G6&K6&P6&V6 Let's say that G6 = 2019; K6 =MI; P6 = 031; and V6 = 037. ...
  24. Re: Create database from SQL script or multiple tables with SQL script

    I have a DDL SQL script created by another SQL database (My SQL Server) and I'd like to see what it looks like in Access.

    Thanks,

    George Teachman
  25. Re: Create database from SQL script or multiple tables with SQL script

    Sorry for the lack of clarity. In the create tab in ACCESS a user can create table(s) using the interface and make that process into a MAKE TABLE Query. So, that the query can be run directly as an...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4