Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy Excel VB question (I think!)
Hi, I was wondering if someone could just help me out with (what I
think is) an easy query on VB syntax in Excel. I have the following statement... Sheets("rm tab4").Select ActiveSheet.PivotTables("PivotTable1").PivotSelect "", xlDataAndLabel, True With Selection.Borders(xlInsideHorizontal) .LineStyle = xlContinuous End With This works just fine, except it needs to visit the 'rm tab4' page in order to execute. This is a pain because when I run the macro from a page other than 'rm tab4' (which I need to be able to do), it transports me to rm tab4 and then leaves me there. To run this without having to visit the page I think I need to lose the ..Select statement. My attempt at this has been... Sheets("rm tab4").PivotTables("PivotTable1").PivotSelect "", xlDataAndLabel, True Sheets("rm tab4").PivotTables("PivotTable1").Borders(xlInside Horizontal).LineStyle = xlContinuous ....but Excel just laughs at me. Can anyone help me please? Cheers. Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy Excel Question | Excel Discussion (Misc queries) | |||
Easy Excel formula question | Excel Discussion (Misc queries) | |||
excel easy question !!!! | Setting up and Configuration of Excel | |||
new user with easy question? not easy for me | New Users to Excel | |||
easy question on excel/outlook | Excel Programming |