Page 285

view full version: back to formated view

1: SUMPRODUCT

2: Bob Phillips Excel Site

3: RE: Install that important patch

4: Finding duplicated entries in a llist

5: simple inventory totals

6: Analyzing code speed

7: Inputbox

8: Question about Pie Charts

9: index match 2 rows 1 col

10: Need code to Autofit Row Height on recalculation

11: Cancelling Safe Mode Programatically

12: Format Event Trigger (XL2002)

13: tlbimp vs. primary in VS project file

14: Consolidating data from seperate files

15: Count If

16: How do I remove an old command button from an EXCEL worksheet?

17: VLOOKUP and Combo Boxes

18: How to change Network Diagram Box Size (MS Proj 2000)

19: check for two blank cells before populating a 3rd.

20: Xl2003: Validation.Add method gives error from Command Button

21: VLookup Problem (Bug?)

22: Mail Function

23: DCOUNT

24: Code Wont Work

25: CheckBox assistance?

26: Validation data on exit Excel or save

27: VB Application for Advanced filter Macro

28: Building a drop down selection menu

29: What is going on with my Excel 2000 spreadsheet?

30: Would like to create Inventory

31: A constant update

32: stop timer

33: How to count occurrence?

34: Yes / No Feature

35: Trying to insert a row. Insert wont Activate

36: Refrsh all pivot tables in a workbook automatically

37: List of all Macro's in Personal.xls

38: getting the filter items

39: Excel date conversion-UK to US

40: Looking up values

41: Edit SQL Command in Mail Merge

42: list separator

43: Cannot "X" out of Excel - Greyed Out

44: How to use Tab in Excel

45: getting values without using "select"

46: Footer... Entering Serial Nos and incremnting daily

47: Position in a list of numbers

48: AutoComplete/AutoFill

49: Allow users to edit range query

50: Importing a large amount of data using Basic

51: Disable sheet copy/move

52: Scambled print order?

53: Error in max character limit(urgent help)

54: Excel 2003: Cannot access directory

55: How to list all sheets

56: file name

57: Interesting challenge

58: Excel VLookup

59: how to insert an email hyperlink in an excel header

60: draw a math function

61: Date Range problems

62: How to get thousand seperator after every two digits

63: Before close and workbook open!

64: Collumns and rows

65: Dynamic pivot table

66: commandbuttons on worksheet move to the left

67: Macro Help

68: CheckBox open File

69: Investment performance tracking

70: Find cell color index

71: Formatting in Forms

72: End of Month Function in Visual Basic

73: series of dates, step by 1, Mon-Thurs only, for 2007

74: any good reference material out there?

75: Network Planning

76: Should grand total equal average of sub total

77: Printing multiple copies

78: code cleaner

79: Excel link to Access Database

80: Adding quotes around text, i.e. "text"

81: Capital letters in names written by lower case

82: Line of Code to set references

83: calculating time with tenths

84: Remedy timestamp incl milliseconds conversion to real time/date

85: Formula

86: Frequency

87: SaveAsUI

88: Combo Boxes linked to Cells will not clear.

89: Is there a way to link Auto Filter values to a Cell

90: How to use Excel Functions in VBA?

91: Help with getting data from a worksheet

92: CELL("Format") function and Locale

93: Network days rounding off hours

94: Yet another issue

95: attach custom toolbar to spreadsheet: how?

96: Using certain data from lists in other cells in Excel.

97: Tab list position in Excel

98: Code assistance

99: Changing Font Color meeting an argument

100: Formula equivalent of CurrentRegion

101: Nonlinear R-squared (R2)

102: Function "Networkdays"

103: Consolidation Array

104: Can't see Trace Precidents sometimes.

105: Use Windows 'search' to find Excel files containing 'a word or phr

106: External Data Questions

107: Deleting rows without losing formulas

108: Count Repeat Clients Visits only

109: Updating Formulas

110: VBA Project Properties

111: UserForm/If Help

112: calculate date by subtracting months

113: Merging Worksheets from different employees

114: Help with code

115: Files properties

116: Macro to delete specific rows in different worksheets

117: Newbie vba - How do I reference cells in another workbook

118: Turning Off Cut & Copy in a Workbook

119: # Days Between Dates Formula Question

120: Question on Ganttool AddIn Code(formula)

121: Need help with named ranges in VBA

122: How to calculate portfolio performance

123: Absolute Worksheet References

124: Merging Groups of Cells in a Column

125: Range Name from Another Workbook conflicts with INDEX and INDIRECT

126: Named range reference in VBA for Excel 2007

127: Merge contents of cells and insert line space

128: Data Set Frequency

129: Number entered into cell is dividide by 100. Not fixed by Cell For

130: Read Variable from Another Module

131: dealing with blank cells in a range

132: How to assign a value as a Named Area

133: I need dedupe software

134: Regex Question

135: Cell shatracter length limiting.

136: limit of characters in Excell

137: Code for Sending files using lotus note

138: Cell contents in header/footer

139: Analysis ToolPak Not Working in Browser mode

140: Determining the size of a range.

141: Excel 2003 file conversion problem

142: Loop & add number list

143: Personal Macro Mystery

144: How do I Hide frozen panes when printing?

145: Print causes crash

146: Using IF command

147: How to define a Named Range in VBA?

148: busted workaround for 255 character limit in cells

149: change default collate setting

150: Help with selecting a range of cells

151: Removing with formula

152: external data from multiple sources

153: Need old version of Excel.

154: sum function

155: Unable to Set XValues property of the Series class

156: Update worksheet formula

157: Checking to see if a worksheet exists

158: More Space ?

159: SUM OF TIME

160: Formula to long

161: questions

162: How can i make numbers have text format without insering ' at each

163: How do I make a cell allow only 24 alpha/num. char.to be entered

164: Help, how to find a range of data?

165: How to put the value form cell into the msgbox

166: VBA Find and Replace (Tidy Up)

167: SumIf: use of greater or less than operators in Criteria

168: Series Collection Question

169: code is not selecting correct range

170: Combining an IF and SUMIF statement, also Typing a string and excel will finish it

171: Macros with shared workbooks

172: Allocating usage across aging buckets

173: Hi all,

174: Documentation for VBProject

175: Pivot Table

176: Removing numbers to the left

177: Looking for the latest date

178: must read

179: Convert .qif or .ofx to .xls or Open Office format?

180: pivot table

181: Formula Problem

182: Formula Variable

183: Timesheet

184: Extract numbers from text

185: View data as a form

186: Autofill UP - Is this the Best Way?

187: can anyone help me with a payday calculator?

188: Last Row

189: Cell drop menu

190: What of these commands ruin my copy - paste operation between workbooks?

191: Newbie: Reading color information

192: Formatted numbers problem - How to get rid of those "1.00043E+11"

193: formula returning incorrect blanks

194: Formatting columnar data to a monthly matrix

195: Refreshing Formulas

196: FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL

197: saving fcell contents in a separate list

198: Reset Sheet

199: reformating worksheet

200: Tool tips on UDF

201: How to create a worksheet to accelerate debts

202: The formula for NORMSDIST is wrong?

203: Link textbox2 to textbox1 via a vlookup

204: *URGENT*

205: dates - how to get 2nd tuesday for 5 years

206: How to calculate # days between business days

207: Getting the values of the points in a trendline

208: Different Calculations in Excel 2000 and on Calculator

209: Is there any way to switch among different sheets in a workbook while an inputbox is popped?

210: Code for Access file manipulation from Excel

211: How to calculate based on Validation LOV items?

212: Creating a printers list

213: Object vs. New File in beforeSave event

214: Compare and Delete rows in EXcel

215: Sort Based off of an Input Box

216: CHIINV error

217: Question regarding how to search a column and print a row(s)

218: conditional formatting

219: VBA to extract sheet name

220: Zeros and blanks ruin average and median

221: Graph Data Range not fixed

222: mirror image

223: Scrolling a lstBox automatically

224: =COUNTIF(D4:D29,">0")

225: Selection.QueryTable problem

226: sumifs in excel 2003

227: Retrieving External Data from Access

228: calculating after vlookup

229: IF/Then/Weekday (I think?)

230: Pivot table not refreshing

231: Find Protected Cells

232: Advice for a newbie

233: Populating 'Comments' with cell value

234: Excel database to mail merge

235: Data Selection Help

236: Array formula to give blank

237: File size(shared workbook)-huge increases on save.

238: Inserting line breaks in text formula

239: simple conditional find, copy and paste

240: Parse text & numbers & format

241: If user says "No" to FileSaveAs Overwrite?

242: Allow only 12 entries in a column

243: Moving Data From Cell To Cell

244: Pivot Table Formatting

245: Match Function

246: ClearContents command causes routine to stop

247: Time or row cell updated

248: Just Excel VBA, skip rest

249: clipboard monitor

250: Msgbox text properties & Spacing

251: Borders with aligned text

252: Calling of simple function in Excel 97

253: Searching for data and placing in new worksheet

254: Averaging

255: MIN/MAX functions and reporting from a different column

256: Link to fortran

257: Setting chart size in macro

258: Excel, client access & AS400

259: #VALUE! position in column of data

260: Sheet Reference

261: Bookmarking feature for the discussion group topics

262: Linking one worksheet to another worksheet?

263: Vlookup using if condition or any other way to slove problem

264: Input a date using a Form Button.

265: Boucle sur ligne relative

266: word works

267: a1 = sum(a1;a2)

268: Defining Names Programmatically

269: Unable to fill Listbox thru VBA

270: I PUT A FORMULA IN A CELL BUT I DON'T GET NUMBERS BUT THE FORMULA

271: Determine File Type

272: how do I troubleshoot date formats in a pivot table report?

273: Excel VBA against Oracle

274: Read Only

275: Creating macro for find and replace

276: VBA: Auto Grouping

277: First Question

278: Pivot table Data field question

279: Getting a cell reference

280: Calculate the difference between two times

281: Increasing Excel stability?

282: using hyperlinks to navigate around a protected worksheet

283: extract unique records from one column

284: OnKey query

285: Time series calculation

286: how to increase size of button's image of custom toolbar of Excel

287: Weighting a Percent of Change

288: Where do I find my digital CERTIFICATE

289: Not close thead when I close excel

290: Date query

291: Trouble with copy to newly created sheet

292: Help with complicated formula!

293: Copy and paste when using subtotal

294: Looking for range values in another range/sheet

295: Put Excel data to text file????

296: Re: How can I determine who has workbook open?

297: file name

298: Put a timer on a MsgBox?

299: UserForm help

300: Conditional Formatting in Excel 2007

301: networkdays

2: Bob Phillips Excel Site

3: RE: Install that important patch

4: Finding duplicated entries in a llist

5: simple inventory totals

6: Analyzing code speed

7: Inputbox

8: Question about Pie Charts

9: index match 2 rows 1 col

10: Need code to Autofit Row Height on recalculation

11: Cancelling Safe Mode Programatically

12: Format Event Trigger (XL2002)

13: tlbimp vs. primary in VS project file

14: Consolidating data from seperate files

15: Count If

16: How do I remove an old command button from an EXCEL worksheet?

17: VLOOKUP and Combo Boxes

18: How to change Network Diagram Box Size (MS Proj 2000)

19: check for two blank cells before populating a 3rd.

20: Xl2003: Validation.Add method gives error from Command Button

21: VLookup Problem (Bug?)

22: Mail Function

23: DCOUNT

24: Code Wont Work

25: CheckBox assistance?

26: Validation data on exit Excel or save

27: VB Application for Advanced filter Macro

28: Building a drop down selection menu

29: What is going on with my Excel 2000 spreadsheet?

30: Would like to create Inventory

31: A constant update

32: stop timer

33: How to count occurrence?

34: Yes / No Feature

35: Trying to insert a row. Insert wont Activate

36: Refrsh all pivot tables in a workbook automatically

37: List of all Macro's in Personal.xls

38: getting the filter items

39: Excel date conversion-UK to US

40: Looking up values

41: Edit SQL Command in Mail Merge

42: list separator

43: Cannot "X" out of Excel - Greyed Out

44: How to use Tab in Excel

45: getting values without using "select"

46: Footer... Entering Serial Nos and incremnting daily

47: Position in a list of numbers

48: AutoComplete/AutoFill

49: Allow users to edit range query

50: Importing a large amount of data using Basic

51: Disable sheet copy/move

52: Scambled print order?

53: Error in max character limit(urgent help)

54: Excel 2003: Cannot access directory

55: How to list all sheets

56: file name

57: Interesting challenge

58: Excel VLookup

59: how to insert an email hyperlink in an excel header

60: draw a math function

61: Date Range problems

62: How to get thousand seperator after every two digits

63: Before close and workbook open!

64: Collumns and rows

65: Dynamic pivot table

66: commandbuttons on worksheet move to the left

67: Macro Help

68: CheckBox open File

69: Investment performance tracking

70: Find cell color index

71: Formatting in Forms

72: End of Month Function in Visual Basic

73: series of dates, step by 1, Mon-Thurs only, for 2007

74: any good reference material out there?

75: Network Planning

76: Should grand total equal average of sub total

77: Printing multiple copies

78: code cleaner

79: Excel link to Access Database

80: Adding quotes around text, i.e. "text"

81: Capital letters in names written by lower case

82: Line of Code to set references

83: calculating time with tenths

84: Remedy timestamp incl milliseconds conversion to real time/date

85: Formula

86: Frequency

87: SaveAsUI

88: Combo Boxes linked to Cells will not clear.

89: Is there a way to link Auto Filter values to a Cell

90: How to use Excel Functions in VBA?

91: Help with getting data from a worksheet

92: CELL("Format") function and Locale

93: Network days rounding off hours

94: Yet another issue

95: attach custom toolbar to spreadsheet: how?

96: Using certain data from lists in other cells in Excel.

97: Tab list position in Excel

98: Code assistance

99: Changing Font Color meeting an argument

100: Formula equivalent of CurrentRegion

101: Nonlinear R-squared (R2)

102: Function "Networkdays"

103: Consolidation Array

104: Can't see Trace Precidents sometimes.

105: Use Windows 'search' to find Excel files containing 'a word or phr

106: External Data Questions

107: Deleting rows without losing formulas

108: Count Repeat Clients Visits only

109: Updating Formulas

110: VBA Project Properties

111: UserForm/If Help

112: calculate date by subtracting months

113: Merging Worksheets from different employees

114: Help with code

115: Files properties

116: Macro to delete specific rows in different worksheets

117: Newbie vba - How do I reference cells in another workbook

118: Turning Off Cut & Copy in a Workbook

119: # Days Between Dates Formula Question

120: Question on Ganttool AddIn Code(formula)

121: Need help with named ranges in VBA

122: How to calculate portfolio performance

123: Absolute Worksheet References

124: Merging Groups of Cells in a Column

125: Range Name from Another Workbook conflicts with INDEX and INDIRECT

126: Named range reference in VBA for Excel 2007

127: Merge contents of cells and insert line space

128: Data Set Frequency

129: Number entered into cell is dividide by 100. Not fixed by Cell For

130: Read Variable from Another Module

131: dealing with blank cells in a range

132: How to assign a value as a Named Area

133: I need dedupe software

134: Regex Question

135: Cell shatracter length limiting.

136: limit of characters in Excell

137: Code for Sending files using lotus note

138: Cell contents in header/footer

139: Analysis ToolPak Not Working in Browser mode

140: Determining the size of a range.

141: Excel 2003 file conversion problem

142: Loop & add number list

143: Personal Macro Mystery

144: How do I Hide frozen panes when printing?

145: Print causes crash

146: Using IF command

147: How to define a Named Range in VBA?

148: busted workaround for 255 character limit in cells

149: change default collate setting

150: Help with selecting a range of cells

151: Removing with formula

152: external data from multiple sources

153: Need old version of Excel.

154: sum function

155: Unable to Set XValues property of the Series class

156: Update worksheet formula

157: Checking to see if a worksheet exists

158: More Space ?

159: SUM OF TIME

160: Formula to long

161: questions

162: How can i make numbers have text format without insering ' at each

163: How do I make a cell allow only 24 alpha/num. char.to be entered

164: Help, how to find a range of data?

165: How to put the value form cell into the msgbox

166: VBA Find and Replace (Tidy Up)

167: SumIf: use of greater or less than operators in Criteria

168: Series Collection Question

169: code is not selecting correct range

170: Combining an IF and SUMIF statement, also Typing a string and excel will finish it

171: Macros with shared workbooks

172: Allocating usage across aging buckets

173: Hi all,

174: Documentation for VBProject

175: Pivot Table

176: Removing numbers to the left

177: Looking for the latest date

178: must read

179: Convert .qif or .ofx to .xls or Open Office format?

180: pivot table

181: Formula Problem

182: Formula Variable

183: Timesheet

184: Extract numbers from text

185: View data as a form

186: Autofill UP - Is this the Best Way?

187: can anyone help me with a payday calculator?

188: Last Row

189: Cell drop menu

190: What of these commands ruin my copy - paste operation between workbooks?

191: Newbie: Reading color information

192: Formatted numbers problem - How to get rid of those "1.00043E+11"

193: formula returning incorrect blanks

194: Formatting columnar data to a monthly matrix

195: Refreshing Formulas

196: FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL

197: saving fcell contents in a separate list

198: Reset Sheet

199: reformating worksheet

200: Tool tips on UDF

201: How to create a worksheet to accelerate debts

202: The formula for NORMSDIST is wrong?

203: Link textbox2 to textbox1 via a vlookup

204: *URGENT*

205: dates - how to get 2nd tuesday for 5 years

206: How to calculate # days between business days

207: Getting the values of the points in a trendline

208: Different Calculations in Excel 2000 and on Calculator

209: Is there any way to switch among different sheets in a workbook while an inputbox is popped?

210: Code for Access file manipulation from Excel

211: How to calculate based on Validation LOV items?

212: Creating a printers list

213: Object vs. New File in beforeSave event

214: Compare and Delete rows in EXcel

215: Sort Based off of an Input Box

216: CHIINV error

217: Question regarding how to search a column and print a row(s)

218: conditional formatting

219: VBA to extract sheet name

220: Zeros and blanks ruin average and median

221: Graph Data Range not fixed

222: mirror image

223: Scrolling a lstBox automatically

224: =COUNTIF(D4:D29,">0")

225: Selection.QueryTable problem

226: sumifs in excel 2003

227: Retrieving External Data from Access

228: calculating after vlookup

229: IF/Then/Weekday (I think?)

230: Pivot table not refreshing

231: Find Protected Cells

232: Advice for a newbie

233: Populating 'Comments' with cell value

234: Excel database to mail merge

235: Data Selection Help

236: Array formula to give blank

237: File size(shared workbook)-huge increases on save.

238: Inserting line breaks in text formula

239: simple conditional find, copy and paste

240: Parse text & numbers & format

241: If user says "No" to FileSaveAs Overwrite?

242: Allow only 12 entries in a column

243: Moving Data From Cell To Cell

244: Pivot Table Formatting

245: Match Function

246: ClearContents command causes routine to stop

247: Time or row cell updated

248: Just Excel VBA, skip rest

249: clipboard monitor

250: Msgbox text properties & Spacing

251: Borders with aligned text

252: Calling of simple function in Excel 97

253: Searching for data and placing in new worksheet

254: Averaging

255: MIN/MAX functions and reporting from a different column

256: Link to fortran

257: Setting chart size in macro

258: Excel, client access & AS400

259: #VALUE! position in column of data

260: Sheet Reference

261: Bookmarking feature for the discussion group topics

262: Linking one worksheet to another worksheet?

263: Vlookup using if condition or any other way to slove problem

264: Input a date using a Form Button.

265: Boucle sur ligne relative

266: word works

267: a1 = sum(a1;a2)

268: Defining Names Programmatically

269: Unable to fill Listbox thru VBA

270: I PUT A FORMULA IN A CELL BUT I DON'T GET NUMBERS BUT THE FORMULA

271: Determine File Type

272: how do I troubleshoot date formats in a pivot table report?

273: Excel VBA against Oracle

274: Read Only

275: Creating macro for find and replace

276: VBA: Auto Grouping

277: First Question

278: Pivot table Data field question

279: Getting a cell reference

280: Calculate the difference between two times

281: Increasing Excel stability?

282: using hyperlinks to navigate around a protected worksheet

283: extract unique records from one column

284: OnKey query

285: Time series calculation

286: how to increase size of button's image of custom toolbar of Excel

287: Weighting a Percent of Change

288: Where do I find my digital CERTIFICATE

289: Not close thead when I close excel

290: Date query

291: Trouble with copy to newly created sheet

292: Help with complicated formula!

293: Copy and paste when using subtotal

294: Looking for range values in another range/sheet

295: Put Excel data to text file????

296: Re: How can I determine who has workbook open?

297: file name

298: Put a timer on a MsgBox?

299: UserForm help

300: Conditional Formatting in Excel 2007

301: networkdays