Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.05 seconds.

  1. Re: [VBA] Adding string to each element in an Array

    Hi
    Welcome to the board

    See if this helps:



    Sub Test()
    Dim v As Variant
    Dim str1 As String, str2 As String
  2. Replies
    6
    Views
    166

    Re: Add shape to fixed position in a chart

    You're welcome.
  3. Replies
    6
    Views
    166

    Re: Add shape to fixed position in a chart

    Sorry, you may have noticed that there's a typo in the code

    Where you see "ActiveSheet.Shapes..." should be "ws.Shapes..."
  4. Replies
    6
    Views
    166

    Re: Add shape to fixed position in a chart

    Hi

    This is an example.
    Assuming you have in worksheet Sheet1 a chart object named MyChart, this example add a rectangle to the worksheet just under the chart object, with half witdth and height....
  5. Re: Macro for Random Time Generator with values greater/lesser than previous cells

    Hi

    Another option

    In A1: =RAND()

    In B1: ="6:0"+SMALL($A$1:$A$3,ROWS($B$1:B1))*("16:0"-"6:0")+((ROWS($B$1:B1)-1)&":0")

    Copy A:B down till row 3
  6. Re: numbers in sequence =IF(ROW()-ROW(A$8)

    Hi

    In A9:
    =IF(ROWS($A$9:A9)<=$G$5,ROWS($A$9:A9),"")

    Copy down till A50
  7. Replies
    5
    Views
    134

    Re: List all subs into listbox

    Hi

    To get the names of all subs in your project you have to use the VBA Extensibility Model

    You can learn it here:

    http://www.cpearson.com/Excel/vbe.aspx

    Check in the page:
  8. Replies
    6
    Views
    166

    Re: Add shape to fixed position in a chart

    Hi Hans
    Welcome to the board

    Sorry, not clear.
    The title says "add shape in a chart" but then the text says "add a rectangle next to the chart"

    Do you want
    - to add a shape to the worksheet...
  9. Replies
    3
    Views
    81

    Re: Protect Three Columns

    Try:



    Sub lockSomeCells()
    Dim ws As Worksheet
    Dim LastRow As Long

    Set ws = Worksheets("Sheet1")
    LastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
  10. Replies
    3
    Views
    81

    Re: Protect Three Columns

    Hi

    You are locking the last cell in column C.
    Don't you want to lock all the cells above too?
  11. Replies
    24
    Views
    12,265

    Re: Apparently empty (blank) cells aren't empty

    Not very clear the first part of the Countifs()

    COUNTIFS(BO$3:BO$4001,BO3,BO$3:BO$4001,"<>",...

    both are testing BO3:BO4001?

    Can't you take the second test out, like
    ...
  12. Replies
    24
    Views
    12,265

    Re: Apparently empty (blank) cells aren't empty

    The cell is not empty, you said yourself it has a formula.

    You forgot to post the formula that you are using.
  13. Replies
    2
    Views
    153

    Re: Formule not refreshing

    Hi

    In the Edit Links dialog what's the option checked in the Startup prompt?
  14. Replies
    8
    Views
    164

    Re: Dividing fractions into new cell

    For a text value I'd use:

    =("0 "&A1)+0
  15. Replies
    8
    Views
    164

    Re: Dividing fractions into new cell

    Hi

    What do you have in A2

    The formula: =36/164 that displays the number 0.2195...

    or

    The text value: 36/164
  16. Re: Non-sequential Page Number total in Excel Footer?

    Hi
    Welcome to the board

    I also don't know of a code to get the number of pages of each worksheet.

    What I'd do is to build my own footer for each worksheet, getting the page count of each...
  17. Thread: VBA Graph

    by pgc01
    Replies
    1
    Views
    107

    Re: VBA Graph

    Hi

    The quick an easy way is to record a macro while you add the chart in the worksheet.

    You can then look at the code and adjust it to your needs.

    For something more:

    ...
  18. Replies
    1
    Views
    57

    Re: Generate unique combinations

    Hi

    Copy the table to the other worksheet and then use Remove Duplicates.
  19. Replies
    2
    Views
    111

    Re: Numeric value as a target for [mm]:ss

    Hi
    Welcome to the board

    The time unit in excel is the day. This means that to convert a decimal minute value to excel time you have to divide it by 24 (hours) and by 60 (minutes)

    Your formula...
  20. Replies
    8
    Views
    205

    Re: Getting spreadsheet to someone without XL

    I'm glad we could help.
  21. Replies
    8
    Views
    205

    Re: Getting spreadsheet to someone without XL

    Hi Mike

    Some options already. :) Here some others

    If what you want is for the receiver to just see your excel page I would suggest saving it as pdf (with the gridlines if you want).
    Everyone...
  22. Replies
    13
    Views
    533

    Re: Decompress Alternate Spellings

    I'm glad it helped.
    Marcelo, thanks much for helping out.
    I've been really tied up these last days.
  23. Replies
    13
    Views
    533

    Re: Decompress Alternate Spellings

    Hi Marcelo

    Thanks. Feel free to change/adapt the code.
    If I had the time I'd post the same algorithm without the regex's.
  24. Replies
    13
    Views
    533

    Re: Decompress Alternate Spellings

    Hi badman3000

    Try first to replicate the result that I posted.

    Like Marcelo said, write the value in A1, execute the code and see that the result is the same that I posted.
  25. Replies
    13
    Views
    533

    Re: Decompress Alternate Spellings

    With the source text in A1, you just have to insert the code in a module and then execute AlternativeSpellings

    If you don't know how, check Copy Excel VBA Code to a Regular Module here :
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4