Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.69 seconds.

  1. Re: Excel VBA: Copy multiple Column of a Table

    Similar if you want to use .DataBodyRange


    lstO.DataBodyRange.Offset(1, 0).Resize(18).Copy Destination:=Range("Z1")
  2. Re: Excel VBA: Copy multiple Column of a Table

    Hi
    Welcome to the board

    See if this helps:



    Dim lstO As ListObject

    Set lstO = ActiveSheet.ListObjects("MyTable")
  3. Replies
    1
    Views
    36

    Re: Issue scrolling on a spreadsheet

    Hi

    Mayb you have restricted the scroll area of the worksheet?

    Try executing in vba:


    ActiveSheet.ScrollArea = ""

    or use the sheet properties dialog and clear the scrollarea (for ex. in...
  4. Thread: columns question

    by pgc01
    Replies
    4
    Views
    172

    Re: columns question

    Hi

    If you have a long list of columns, is there not some logic to it, like every 4th column, or columns that have a header starting with "MKT" or something that allows you to identify the ...
  5. Replies
    1
    Views
    129

    Re: Filter only displays 10,000 unique items

    Hi

    You can't, not directly using the autofilter.

    You can check MS support here:

    https://support.microsoft.com/en-us/help/295971/not-all-items-are-displayed-in-the-autofilter-pivottable-list...
  6. Re: Search a string in one cell for an exact match of a value from another cell

    You're welcome.
  7. Re: Search a string in one cell for an exact match of a value from another cell

    Hi
    Welcome to the board

    Add the separator to the search

    =ISNUMBER(SEARCH(";"&$A2&";",";"&MachData!$B$2&";"))
  8. Re: [VBA] Adding string to each element in an Array

    You're welcome. Thanks for the feedback.
  9. 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
  10. Replies
    6
    Views
    232

    Re: Add shape to fixed position in a chart

    You're welcome.
  11. Replies
    6
    Views
    232

    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..."
  12. Replies
    6
    Views
    232

    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....
  13. 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
  14. 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
  15. Replies
    5
    Views
    175

    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:
  16. Replies
    6
    Views
    232

    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...
  17. Replies
    3
    Views
    115

    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
  18. Replies
    3
    Views
    115

    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?
  19. Replies
    24
    Views
    12,463

    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
    ...
  20. Replies
    24
    Views
    12,463

    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.
  21. Replies
    2
    Views
    185

    Re: Formule not refreshing

    Hi

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

    Re: Dividing fractions into new cell

    For a text value I'd use:

    =("0 "&A1)+0
  23. Replies
    8
    Views
    213

    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
  24. 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...
  25. Thread: VBA Graph

    by pgc01
    Replies
    1
    Views
    128

    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:

    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4