Home

Blogs

Nick's picture

XLA routines: EE_PivotRemoveTotals

Submitted by Nick on 3 March, 2015 - 13:31
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)

Submitted by PVINOD91 on 23 February, 2015 - 06:48

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

Submitted by Nick on 20 February, 2015 - 07:06
EE_SortCols sorts columns by a predefined range of headers...
»
Nick's picture

VBA Developer Jobs in the UK

Submitted by Nick on 15 February, 2015 - 11:50

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

Submitted by Nick on 15 February, 2015 - 11:47

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

Submitted by Nick on 15 February, 2015 - 11:43

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

Submitted by Nick on 15 February, 2015 - 11:15
»
Nick's picture

Excel Jobs in Cardiff

Submitted by Nick on 15 February, 2015 - 11:07

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

Submitted by Nick on 15 February, 2015 - 11:06

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

Submitted by Nick on 15 February, 2015 - 11:06

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

Submitted by Nick on 15 February, 2015 - 11:05

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

Submitted by Nick on 15 February, 2015 - 11:05

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

Submitted by Nick on 15 February, 2015 - 11:05

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

Submitted by Nick on 15 February, 2015 - 11:04

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

Submitted by Nick on 15 February, 2015 - 11:03

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

Submitted by Nick on 15 February, 2015 - 11:03
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

Submitted by Nick on 15 February, 2015 - 11:02
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

Submitted by Nick on 15 February, 2015 - 11:01
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

Submitted by Nick on 15 February, 2015 - 11:01
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

Submitted by Nick on 15 February, 2015 - 11:00
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

Submitted by Nick on 15 February, 2015 - 11:00
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

Submitted by Nick on 15 February, 2015 - 10:58
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

Submitted by Nick on 15 February, 2015 - 10:58
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

Submitted by Nick on 15 February, 2015 - 10:57
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

Submitted by Nick on 15 February, 2015 - 10:57
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

Submitted by Nick on 15 February, 2015 - 10:56
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

Submitted by Nick on 15 February, 2015 - 10:56
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

Submitted by Nick on 15 February, 2015 - 10:55
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

Submitted by Nick on 15 February, 2015 - 10:55
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

Submitted by Nick on 15 February, 2015 - 10:55
Live VBA Jobs in Leeds

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

Syndicate content