Blogs

Nick's picture

XLA routines: EE_PivotRemoveTotals

EE_PivotRemoveTotals is a simple routine that removes the totals from a pivot
Sub EE_PivotRemoveTotals(Optional pt As PivotTable)
'http://excelexperts.com/xla-routines-eePivotRemoveTotals  for updates on this routine
    If pt Is Nothing Then
        If ActiveSheet.PivotTables.Count = 0 Then Exit Sub
        Set pt = ActiveSheet.PivotTables(1)
    End If
 
    pt.RowGrand = False
    pt.ColumnGrand = False
End Sub

VBA to paste Excel Range into Powerpoint (it should not be a picture and excel linked table)

Hello,
I would need a help to copy an excel range as editable table in a powerpoint. When i tried, It was pasted as a picture or as a excel linked table which were annoying.

and i would need to paste it as an editable one (similar to a powerpoint table). please post your reply soon.

Thanks,
Vinod.

Nick's picture

XLA routines: EE_SortCols

EE_SortCols sorts columns by a predefined range of headers...
Nick's picture

VBA Developer Jobs in the UK

Live VBA Developer Jobs in the UK

{"what":" VBA developer","where":"","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Developer Jobs in the UK

Live Excel Developer Jobs in the UK

{"what":" excel developer","where":"","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel VBA Jobs in the UK

Excel VBA Jobs in the UK

{"what":" excel vba","where":"","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel VBA Jobs in the UK

Nick's picture

Excel Jobs in Cardiff

Live Excel Jobs in Cardiff

{"what":"Excel","where":"Cardiff","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Dundee

Live Excel Jobs in Dundee

{"what":"Excel","where":"Dundee","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Perth

Live Excel Jobs in Perth 

{"what":"Excel","where":"Perth ","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Inverness

Live Excel Jobs in Inverness

{"what":"Excel","where":"Inverness","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Aberdeen

Live Excel Jobs in Aberdeen

{"what":"Excel","where":"Aberdeen","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Edinburgh

Live Excel Jobs in Edinburgh

{"what":"Excel","where":"Edinburgh","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Glasgow

Live Excel Jobs in Glasgow

{"what":"Excel","where":"Glasgow","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Belfast

Live Excel Jobs in Belfast

{"what":"Excel","where":"Belfast","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Leeds

Live Excel Jobs in Leeds

{"what":"Excel","where":"Leeds","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Bristol

Live Excel Jobs in Bristol

{"what":"Excel","where":"Bristol","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Birmingham

Live Excel Jobs in Birmingham

{"what":"Excel","where":"Birmingham","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Liverpool

Live Excel Jobs in Liverpool

{"what":"Excel","where":"Liverpool","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Manchester

Live Excel Jobs in Manchester

{"what":"Excel","where":"Manchester","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in London

Live Excel Jobs in London

{"what":"Excel","where":"London","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Cardiff

Live VBA Jobs in Cardiff

{"what":"vba","where":"Cardiff","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Dundee

Live VBA Jobs in Dundee

{"what":"vba","where":"Dundee","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Perth

Live VBA Jobs in Perth 

{"what":"vba","where":"Perth ","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Inverness

Live VBA Jobs in Inverness

{"what":"vba","where":"Inverness","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Aberdeen

Live VBA Jobs in Aberdeen

{"what":"vba","where":"Aberdeen","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Edinburgh

Live VBA Jobs in Edinburgh

{"what":"vba","where":"Edinburgh","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Glasgow

Live VBA Jobs in Glasgow

{"what":"vba","where":"Glasgow","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Belfast

Live VBA Jobs in Belfast

{"what":"vba","where":"Belfast","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Leeds

Live VBA Jobs in Leeds

{"what":"vba","where":"Leeds","results_per_page":"20","country":"gb","widget":"job-feed"}

Syndicate content