Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    102

    Re: row to repeat at top

    No Its not that easy. I have a sheet that using the first 5 row as a Header, now some of the header information may change from page to page, I was just wondering if it was possible to change the...
  2. Replies
    2
    Views
    102

    row to repeat at top

    Is it possible to modify the cells located in the "rows to repeat at top" when printing each page

    Thanks.
    Jim
  3. Replies
    4
    Views
    99

    Re: Number formating

    Great, is was sort of leaning that way.
    great job
  4. Replies
    4
    Views
    99

    Re: Number formating

    The cells will be in a range by columns, the numbers will be either negative or positive
    I also feel that it can only be done via VBA
  5. Replies
    4
    Views
    99

    Number formating

    I have a numeric cell, that I would like to be able to enter "-123" and the cell displays "-1.23" or if the user enters "-1.23" the cell will display "-1.23"

    is this even possible?

    Thanks
  6. Replies
    2
    Views
    178

    Cell formatting

    I would like to be able to format a cell for time in hours and minutes with the user entering either only the numbers or numbers with the colon. I can do "0\:00" for number only entries, but not both...
  7. Replies
    8
    Views
    337

    Re: Convert Cell address.

    What I'm trying to do is replicate the Fill command but filling the values only no formatting, I get the selected range, copy the first row, and loop by row and paste values only.


    Fraz
  8. Replies
    8
    Views
    337

    Re: Convert Cell address.

    Thanks that works great, didn't realize it was that complicated, well at least to me it is.
    Thank again.
  9. Replies
    8
    Views
    337

    Re: Convert Cell address.

    Sorry I wasn't so clear.
    What I am looking for is a way to convert a range in the form of

    Range("$D$4:$D$8" )

    TO
    Range(Cells(START_ROW,START_COL),Cells(END_ROW,END_COL))

    Again Sorry I...
  10. Replies
    8
    Views
    337

    Convert Cell address.

    How does one go about convert the cell address.
    I know that the absolute function converts the cell row, column to a cell address such as $a1 how would you convert a range a1:f10 to row and column...
  11. Replies
    2
    Views
    231

    Re: sheet protection

    Thanks
    that works...
  12. Replies
    2
    Views
    231

    sheet protection

    I am developing an application which in which the sheet acts as a list box to select Items (using either the "Enter" key or double click, and open a userform for editing, I have it set up to high...
  13. Replies
    2
    Views
    182

    Re: auto adjust row hieght

    Thanks I forgotten that, I been messing with open office for to long. Which is another story.
  14. Replies
    2
    Views
    182

    auto adjust row hieght

    How would one automatically adjust a rows height as the cell entry exceeds the column width.Thanks
  15. Replies
    2
    Views
    188

    Re: userform textbox data append

    will give it a try
    Thanks
  16. Replies
    2
    Views
    188

    userform textbox data append

    Does anybody know of a way to only append data to a text box.
    In other word prevent the editing of the previous data and allowing only new data to be entered.

    Thanks
  17. worksheet combo box- using column data and removing duplicaates

    How would one go about inserting column data into a worksheet combo box and remove duplicates?
    also the list of data will vary.

    Thanks
  18. Replies
    3
    Views
    628

    Re: counting non hidden rows in VBA

    thanks that worked.
  19. Replies
    3
    Views
    628

    counting non hidden rows in VBA

    After filtering a worksheet I would like to sequentially number each row for the non hidden rows

    row status
    1 visible 1
    2 hidden
    3 hidden
    4 visible ...
  20. Replies
    1
    Views
    147

    auto filter list boxes

    Just wondering if anyone has a way to emulate the worksheet auto filter in a list box.

    thanks
  21. Replies
    4
    Views
    317

    Re: data replication

    That is the way I was leaning toward. Was just looking for Idea's

    thanks
  22. Replies
    4
    Views
    317

    data replication

    Hello this is a general question, not looking for code.

    If I have two computers in different location and not on a network, with the same application, both computers are able to edit data. what I...
  23. Re: Using Row and Column addresses in a Formula

    Thanks that did it along with the indirect function.
    For years I have been doing those type of things using VBA. But now I am having to redo some apps in OPEN Office.
    The VBA code I used as an...
  24. Re: Using Row and Column addresses in a Formula

    Thanks
  25. Using Row and Column addresses in a Formula

    I need help with a formula to update a cell using the row and column number contained in separate cells.
    The VBA would look like this...



    Sub Macro1()
    '
    ' Macro1 Macro
    mrow =...
Results 1 to 25 of 57
Page 1 of 3 1 2 3