1
Reply
VBA Excel: Refer to Pivot Table without knowing the name
( 141 views )  Submitted By
Rowland Hamilton
on 15-Mar-13 06:39 PM in
Microsoft Excel
.
0
Replies
Convert String Array to Variant Array like "Array("111", "222")" to Array("111", "222")
( 113 views )  Submitted By
Rowland Hamilton
on 17-Feb-13 11:45 PM in
Microsoft Excel
.
0
Replies
re: fso.GetFolder(myDir).Files.Count - 1 'Why is -1 needed sometimes, not always
( 0 views )  Submitted By
Rowland Hamilton
on 16-Feb-13 04:31 PM in
Microsoft Excel
.
0
Replies
re: fso.GetFolder(myDir).Files.Count - 1 'Why is -1 needed sometimes, not always
( 0 views )  Submitted By
Rowland Hamilton
on 16-Feb-13 03:43 PM in
Microsoft Excel
.
1
Reply
re: fso.GetFolder(myDir).Files.Count - 1 'Why is -1 needed sometimes, not always
( 1 views )  Submitted By
Rowland Hamilton
on 16-Feb-13 03:21 PM in
Microsoft Excel
.
5
Replies
fso.GetFolder(myDir).Files.Count - 1 'Why is -1 needed sometimes, not always
( 157 views )  Submitted By
Rowland Hamilton
on 16-Feb-13 02:58 AM in
Microsoft Excel
.
0
Replies
Skip Row if No Match, Do Loop and For Next Syntax
( 115 views )  Submitted By
Rowland Hamilton
on 11-Feb-13 10:47 PM in
Microsoft Excel
.
1
Reply
Found value in quotes not matching cell value without quotes, VBA Excel
( 139 views )  Submitted By
Rowland Hamilton
on 11-Feb-13 04:27 PM in
Microsoft Excel
.
1
Reply
Macro to Identify cells containing 1 of Top 10 values in range, without sorting
( 148 views )  Submitted By
Rowland Hamilton
on 07-Feb-13 05:55 PM in
Microsoft Excel
.
1
Reply
Earn up to 10 points.
Using Text to convert date to YY format
( 334 views )  Submitted By
Rowland Hamilton
on 30-Mar-12 08:33 PM in
Microsoft Excel
.
0
Replies
re: VBA Data Validation populate error in For Next loop
( 0 views )  Submitted By
Rowland Hamilton
on 21-Mar-12 07:04 PM in
Microsoft Excel
.
2
Replies
VBA Data Validation populate error in For Next loop
( 183 views )  Submitted By
Rowland Hamilton
on 21-Mar-12 04:08 PM in
Microsoft Excel
.
3
Replies
Earn up to 10 points.
Recreate date from split vba excel
( 254 views )  Submitted By
Rowland Hamilton
on 01-Feb-12 09:16 PM in
Microsoft Excel
.
1
Reply
re: Mid addr formula pulling wrong date
( 1 views )  Submitted By
Rowland Hamilton
on 01-Feb-12 09:15 PM in
Microsoft Excel
.
1
Reply
re: Mid addr formula pulliing wrong date
( 1 views )  Submitted By
Rowland Hamilton
on 31-Jan-12 08:05 PM in
Microsoft Excel
.
5
Replies
Mid addr formula pulliing wrong date
( 251 views )  Submitted By
Rowland Hamilton
on 31-Jan-12 01:46 PM in
Microsoft Excel
.
4
Replies
Date and time format
( 207 views )  Submitted By
Rowland Hamilton
on 21-Dec-11 03:55 PM in
Microsoft Excel
.
2
Replies
Earn up to 10 points.
vba pass through variable to procedure
( 233 views )  Submitted By
Rowland Hamilton
on 05-Dec-11 05:22 PM in
Microsoft Excel
.
1
Reply
VBA Array for Sumif procedure, multiple columns
( 283 views )  Submitted By
Rowland Hamilton
on 05-Dec-11 02:10 PM in
Microsoft Excel
.
3
Replies
Find Last Row with Application.Match Method
( 230 views )  Submitted By
Rowland Hamilton
on 17-Nov-11 07:30 PM in
Microsoft Excel
.
3
Replies
VBA: Identify dates in a range as belonging to latest 2 quarters CQ PQ
( 207 views )  Submitted By
Rowland Hamilton
on 07-Nov-11 08:35 PM in
Microsoft Excel
.
0
Replies
re: How to refresh, maintain structure of an existing pivot table
( 0 views )  Submitted By
Rowland Hamilton
on 20-Oct-11 04:31 PM in
Microsoft Excel
.
0
Replies
re: How to refresh, maintain structure of an existing pivot table
( 0 views )  Submitted By
Rowland Hamilton
on 20-Oct-11 04:26 PM in
Microsoft Excel
.
3
Replies
How to refresh, maintain structure of an existing pivot table
( 269 views )  Submitted By
Rowland Hamilton
on 20-Oct-11 01:47 PM in
Microsoft Excel
.
0
Replies
re: How to make an Uneven Pivot Table?
( 0 views )  Submitted By
Rowland Hamilton
on 20-Oct-11 02:43 AM in
Microsoft Excel
.
0
Replies
re: How to make an Uneven Pivot Table?
( 0 views )  Submitted By
Rowland Hamilton
on 20-Oct-11 01:50 AM in
Microsoft Excel
.
7
Replies
How to make an Uneven Pivot Table?
( 862 views )  Submitted By
Rowland Hamilton
on 19-Oct-11 10:35 PM in
Microsoft Excel
.
0
Replies
re: Fix scroll bar but keep named range
( 0 views )  Submitted By
Rowland Hamilton
on 18-Oct-11 01:13 PM in
Microsoft Excel
.
2
Replies
Fix scroll bar but keep named range
( 216 views )  Submitted By
Rowland Hamilton
on 17-Oct-11 01:59 PM in
Microsoft Excel
.
1
Reply
re: Sort date column by year Excel vba
( 1 views )  Submitted By
Rowland Hamilton
on 14-Oct-11 02:58 PM in
Microsoft Excel
.
1
Reply
re: Sort date column by year Excel vba
( 1 views )  Submitted By
Rowland Hamilton
on 14-Oct-11 12:46 PM in
Microsoft Excel
.
8
Replies
Sort date column by year Excel vba
( 431 views )  Submitted By
Rowland Hamilton
on 13-Oct-11 08:16 PM in
Microsoft Excel
.
0
Replies
re: Filter/Copy Paste noncontiguous columns to ws in loop code
( 0 views )  Submitted By
Rowland Hamilton
on 07-Oct-11 03:02 AM in
Microsoft Excel
.
1
Reply
re: Filter/Copy Paste noncontiguous columns to ws in loop code
( 1 views )  Submitted By
Rowland Hamilton
on 28-Sep-11 12:34 PM in
Microsoft Excel
.
1
Reply
re: Filter/Copy Paste noncontiguous columns to ws in loop code
( 1 views )  Submitted By
Rowland Hamilton
on 27-Sep-11 05:44 PM in
Microsoft Excel
.
6
Replies
Filter/Copy Paste noncontiguous columns to ws in loop code
( 341 views )  Submitted By
Rowland Hamilton
on 27-Sep-11 05:56 AM in
Microsoft Excel
.
0
Replies
re: VBA: Create an array for unique occurences in column F
( 0 views )  Submitted By
Rowland Hamilton
on 27-Sep-11 05:22 AM in
Microsoft Excel
.
1
Reply
VBA: Select workbook housing the macro
( 260 views )  Submitted By
Rowland Hamilton
on 27-Sep-11 05:12 AM in
Microsoft Excel
.
0
Replies
re: VBA: Create an array for unique occurences in column F
( 0 views )  Submitted By
Rowland Hamilton
on 27-Sep-11 02:52 AM in
Microsoft Excel
.
0
Replies
re: VBA: Create an array for unique occurences in column F
( 0 views )  Submitted By
Rowland Hamilton
on 26-Sep-11 08:04 PM in
Microsoft Excel
.
0
Replies
re: VBA: Create an array for unique occurences in column F
( 0 views )  Submitted By
Rowland Hamilton
on 26-Sep-11 07:13 PM in
Microsoft Excel
.
0
Replies
re: VBA: Create an array for unique occurences in column F
( 0 views )  Submitted By
Rowland Hamilton
on 26-Sep-11 07:09 PM in
Microsoft Excel
.
4
Replies
Store a lookup table in VBA module?
( 263 views )  Submitted By
Rowland Hamilton
on 26-Sep-11 06:29 PM in
Microsoft Excel
.
9
Replies
VBA: Create an array for unique occurences in column F
( 520 views )  Submitted By
Rowland Hamilton
on 26-Sep-11 03:02 PM in
Microsoft Excel
.
2
Replies
Get column letter from column number derived from a match formula
( 318 views )  Submitted By
Rowland Hamilton
on 26-Sep-11 12:19 PM in
Microsoft Excel
.
1
Reply
Earn up to 50 points.
Figured it out: VBA: expand all pivot table fields in Excel 2010
( 496 views )  Submitted By
Rowland Hamilton
on 23-Sep-11 12:24 PM in
Microsoft Excel
.
0
Replies
re: Excel 2010 Pivot table: group or create set based on column items
( 0 views )  Submitted By
Rowland Hamilton
on 20-Sep-11 11:50 AM in
Microsoft Excel
.
4
Replies
Excel 2010 Pivot table: group or create set based on column items
( 1,643 views )  Submitted By
Rowland Hamilton
on 19-Sep-11 07:11 PM in
Microsoft Excel
.
1
Reply
Convert Table to normal range, table name unknown-Resolved
( 350 views )  Submitted By
Rowland Hamilton
on 31-Aug-11 03:43 PM in
Microsoft Excel
.
1
Reply
IF Outline exists ,ClearOutline - converted table to normal range
( 259 views )  Submitted By
Rowland Hamilton
on 31-Aug-11 02:26 PM in
Microsoft Excel
.
0
Replies
re: Vlookup lookup value within alphanumeric string
( 0 views )  Submitted By
Rowland Hamilton
on 31-Aug-11 02:13 PM in
Microsoft Excel
.
3
Replies
re: Vlookup lookup value within alphanumeric string
( 3 views )  Submitted By
Rowland Hamilton
on 29-Aug-11 04:28 PM in
Microsoft Excel
.
6
Replies
Vlookup lookup value within alphanumeric string
( 332 views )  Submitted By
Rowland Hamilton
on 26-Aug-11 07:09 PM in
Microsoft Excel
.
0
Replies
re: VBA File Browser Option Out
( 0 views )  Submitted By
Rowland Hamilton
on 26-Aug-11 06:49 PM in
Microsoft Excel
.
1
Reply
re: VBA File Browser Option Out
( 1 views )  Submitted By
Rowland Hamilton
on 23-Aug-11 03:37 PM in
Microsoft Excel
.
2
Replies
Automatically Add New Items To Pivot Table Filter
( 659 views )  Submitted By
Rowland Hamilton
on 23-Aug-11 02:17 PM in
Microsoft Excel
.
1
Reply
re: VBA File Browser Option Out
( 1 views )  Submitted By
Rowland Hamilton
on 22-Aug-11 12:32 PM in
Microsoft Excel
.
7
Replies
Earn up to 10 points.
VBA File Browser Option Out
( 441 views )  Submitted By
Rowland Hamilton
on 19-Aug-11 07:46 PM in
Microsoft Excel
.
0
Replies
re: Excel VBA Input box to capture integer for vba code and calculations
( 0 views )  Submitted By
Rowland Hamilton
on 19-Aug-11 06:21 PM in
Microsoft Excel
.
0
Replies
re: Macro Convert Text to Numbers Allow Type mismatch
( 0 views )  Submitted By
Rowland Hamilton
on 19-Aug-11 01:41 PM in
Microsoft Excel
.
1
Reply
re: Macro Convert Text to Numbers Allow Type mismatch
( 1 views )  Submitted By
Rowland Hamilton
on 19-Aug-11 01:17 PM in
Microsoft Excel
.
1
Reply
re: Macro Convert Text to Numbers Allow Type mismatch
( 1 views )  Submitted By
Rowland Hamilton
on 19-Aug-11 01:10 PM in
Microsoft Excel
.
6
Replies
Macro Convert Text to Numbers Allow Type mismatch
( 420 views )  Submitted By
Rowland Hamilton
on 19-Aug-11 12:50 PM in
Microsoft Excel
.
0
Replies
re: Excel VBA Input box to capture integer for vba code and calculations
( 0 views )  Submitted By
Rowland Hamilton
on 18-Aug-11 03:52 AM in
Microsoft Excel
.
1
Reply
re: Excel VBA Input box to capture integer for vba code and calculations
( 1 views )  Submitted By
Rowland Hamilton
on 18-Aug-11 03:24 AM in
Microsoft Excel
.
2
Replies
re: Excel VBA Input box to capture integer for vba code and calculations
( 2 views )  Submitted By
Rowland Hamilton
on 18-Aug-11 03:03 AM in
Microsoft Excel
.
1
Reply
re: Excel VBA Input box to capture integer for vba code and calculations
( 1 views )  Submitted By
Rowland Hamilton
on 18-Aug-11 02:58 AM in
Microsoft Excel
.
0
Replies
re: VBA Excel Arrow Up to next visible cell or Offset up
( 0 views )  Submitted By
Rowland Hamilton
on 18-Aug-11 01:47 AM in
Microsoft Excel
.
0
Replies
re: VBA Excel Arrow Up to next visible cell or Offset up
( 0 views )  Submitted By
Rowland Hamilton
on 17-Aug-11 11:34 AM in
Microsoft Excel
.
14
Replies
Excel VBA Input box to capture integer for vba code and calculations
( 805 views )  Submitted By
Rowland Hamilton
on 16-Aug-11 08:26 PM in
Microsoft Excel
.
1
Reply
re: VBA Excel Arrow Up to next visible cell or Offset up
( 1 views )  Submitted By
Rowland Hamilton
on 16-Aug-11 07:22 PM in
Microsoft Excel
.
1
Reply
re: VBA Excel Arrow Up to next visible cell or Offset up
( 1 views )  Submitted By
Rowland Hamilton
on 16-Aug-11 04:55 PM in
Microsoft Excel
.
8
Replies
VBA Excel Arrow Up to next visible cell or Offset up
( 530 views )  Submitted By
Rowland Hamilton
on 16-Aug-11 01:42 PM in
Microsoft Excel
.
1
Reply
re: Last Row, VBA, Array, Dim, File browser, Copy/Paste between workbooks
( 1 views )  Submitted By
Rowland Hamilton
on 10-Aug-11 05:32 PM in
Microsoft Excel
.
0
Replies
re: Last Row, VBA, Array, Dim, File browser, Copy/Paste between workbooks
( 0 views )  Submitted By
Rowland Hamilton
on 10-Aug-11 11:55 AM in
Microsoft Excel
.
4
Replies
Earn up to 10 points.
Last Row, VBA, Array, Dim, File browser, Copy/Paste between workbooks
( 423 views )  Submitted By
Rowland Hamilton
on 09-Aug-11 08:03 PM in
Microsoft Excel
.
0
Replies
re: Find Text other wb's ws column, use cell location row as vba variable
( 0 views )  Submitted By
Rowland Hamilton
on 08-Aug-11 01:32 PM in
Microsoft Excel
.
0
Replies
re: Autifilter only working for 2 criteria, delete visible rows not header
( 0 views )  Submitted By
Rowland Hamilton
on 06-Aug-11 02:57 AM in
Microsoft Excel
.
0
Replies
re: Autifilter only working for 2 criteria, delete visible rows not header
( 0 views )  Submitted By
Rowland Hamilton
on 06-Aug-11 02:08 AM in
Microsoft Excel
.
5
Replies
Earn up to 20 points.
Autifilter only working for 2 criteria, delete visible rows not header
( 493 views )  Submitted By
Rowland Hamilton
on 05-Aug-11 03:05 PM in
Microsoft Excel
.
0
Replies
re: Find Text other wb's ws column, use cell location row as vba variable
( 0 views )  Submitted By
Rowland Hamilton
on 04-Aug-11 12:32 PM in
Microsoft Excel
.
1
Reply
re: Find Text other wb's ws column, use cell location row as vba variable
( 1 views )  Submitted By
Rowland Hamilton
on 04-Aug-11 02:37 AM in
Microsoft Excel
.
0
Replies
re: Not Like more than One thing vba excel
( 0 views )  Submitted By
Rowland Hamilton
on 04-Aug-11 01:57 AM in
Microsoft Excel
.
5
Replies
Find Text other wb's ws column, use cell location row as vba variable
( 352 views )  Submitted By
Rowland Hamilton
on 04-Aug-11 01:26 AM in
Microsoft Excel
.
2
Replies
Not Like more than One thing vba excel
( 324 views )  Submitted By
Rowland Hamilton
on 03-Aug-11 08:55 PM in
Microsoft Excel
.
0
Replies
re: Ignore Hidden Tabs VBA Copy Method
( 0 views )  Submitted By
Rowland Hamilton
on 03-Aug-11 06:32 AM in
Microsoft Excel
.
2
Replies
Ignore Hidden Tabs VBA Copy Method
( 412 views )  Submitted By
Rowland Hamilton
on 02-Aug-11 08:02 PM in
Microsoft Excel
.
1
Reply
re: VBA file browser command to open any workbook to define as SourceWB
( 1 views )  Submitted By
Rowland Hamilton
on 02-Aug-11 06:07 PM in
Microsoft Excel
.
5
Replies
VBA file browser command to open any workbook to define as SourceWB
( 403 views )  Submitted By
Rowland Hamilton
on 01-Aug-11 05:52 PM in
Microsoft Excel
.
1
Reply
re: Search worksheets by partial tab name copy data to other workbook
( 1 views )  Submitted By
Rowland Hamilton
on 01-Aug-11 05:42 PM in
Microsoft Excel
.
1
Reply
re: Search worksheets by partial tab name copy data to other workbook
( 1 views )  Submitted By
Rowland Hamilton
on 29-Jul-11 07:01 PM in
Microsoft Excel
.
5
Replies
Search worksheets by partial tab name copy data to other workbook
( 352 views )  Submitted By
Rowland Hamilton
on 28-Jul-11 02:18 PM in
Microsoft Excel
.
0
Replies
Earn up to 50 points.
One page to print multiple copies with sequential page numbering in inserted field
( 867 views )  Submitted By
Rowland Hamilton
on 11-Feb-10 05:11 PM in
Microsoft Word
.
0
Replies
Page Field to Update Multiple Pivot Tables‏
( 20 views )  Submitted By
Rowland Hamilton
on 05-Jan-10 05:00 PM in
Microsoft Excel
.
1
Reply
Page Field to Update Multiple Pivot Tables‏
( 1 views )  Submitted By
Rowland Hamilton
on 05-Jan-10 04:43 PM in
Microsoft Excel
.
2
Replies
RE: Page Field to Update Multiple Pivot Tables
( 54 views )  Submitted By
Rowland Hamilton
on 05-Jan-10 03:08 PM in
Microsoft Excel
.
0
Replies
RE: RE: RE: RE: Page Field to Update Multiple Pivot Tables
( 0 views )  Submitted By
Rowland Hamilton
on 05-Jan-10 02:33 PM in
Microsoft Excel
.
2
Replies
RE: RE: RE: Page Field to Update Multiple Pivot Tables
( 14 views )  Submitted By
Rowland Hamilton
on 05-Jan-10 02:08 PM in
Microsoft Excel
.
1
Reply
RE: Page Field to Update Multiple Pivot Tables
( 31 views )  Submitted By
Rowland Hamilton
on 05-Jan-10 12:55 PM in
Microsoft Excel
.
11
Replies
Page Field to Update Multiple Pivot Tables
( 1,819 views )  Submitted By
Rowland Hamilton
on 04-Jan-10 07:41 PM in
Microsoft Excel
.
1