Page 89

view full version: back to formated view

1: Lookup value

2: Formula Req'd - Autofilter limitation workaround

3: Grab Password Name

4: SIMPLE MACRO!!!

5: IF, AND, OR Function

6: list, search, and display

7: Checking HasPassword property without opening

8: Huge Memory Leaks using ODBC Drivers from Excel to retrieve data

9: getting selected listbox values

10: Grey text prints as black..

11: named range not specific to worksheet

12: Lookup problem

13: msgbox to display a cell value, HOW, If possible?

14: How to look up a value?

15: DATE Functions???

16: How to leave the lines on my exel work sheet

17: Change from Numeric to Alpha

18: How do I use auto sum with hidden cells?

19: Selecting columns with column numbers not letters

20: Monthly Change Using Nested IFs?

21: Comments on a pivot table

22: findings text in columns

23: Really tricky excel problem

24: Excel close/save/prompt problem

25: Looking for a specific Excel function/formula

26: insert real time to EXVCEL spread sheets?

27: Declaring Multi-Dimensional Arrays

28: Calculate a 30-day moving average based on the last x number of entries and date

29: Password on VBA causing problem

30: "Slidey Bar" for Code Progess

31: Ignore #N/A in a formula

32: Custom Menus

33: Type Mismatch error

34: Excel to Access using VBA

35: text comparision

36: Data Import

37: Can a replaced excel file be recovered?

38: Copying new activesheet after other activesheet is hidden?

39: open OQY file from http:// folder

40: Print enveloppes' address from Excel

41: Code Cleaner (Rob Bovey): Compile? Means what?

42: What's it take for Canadian Application?

43: Excell 2000 worksheet

44: make backup excel

45: Regression error - "NUM!"

46: bringing in data from another worksgroup to a current workgroup

47: How to detect excess rows in txt or csv files before opening?

48: counting number of particular items in a list

49: Resizing Userform to screen size

50: Copy Problem

51: Insert 19 cells "Shift to the right" if cell contains "->"

52: formating numbers

53: OT - Collaboratons

54: Filter options disabled for pivot tables.

55: SumIf(values of non calculated cells in a row...)

56: Referencing Spreadsheet in VBA

57: run macro on a CommandButton from another sheet

58: save from template to worksheet without update commands

59: Counting cells with same info in them

60: WATCH WINDOW

61: Tab Order within a frame

62: How do add time/hours to get answer in hours if Ans>24

63: Print Preview moves command buttons

64: How to put this formula using VBA

65: Vlookup Problem on Excel

66: how to display different content depends on some conditions?

67: PDFing an Excel Workbook

68: FInding a Date with wildcard

69: Practical Excel Range Looping Project

70: Formula Help Again

71: how to display answer as whole number and remainder

72: If formula with score total

73: Help with this code please

74: Make macro-button sheet reference relative

75: VBA 2003 Save|Change|Restore builtin menu OnAction

76: Cross Referance

77: Compare and group like numbers and info

78: Excel Query error

79: Page set up for a workbook, so each sheet gets the same format ?

80: Comma Style

81: Excel Macro- sort issue in Excel2003

82: Searching For Duplicates

83: Excel Addin Install via Registry

84: Old function is not working.

85: Can anybody crack this VBA problem?

86: command button on top

87: quick double-criteria lookup?

88: new user needs help with programing

89: colored baloon chart in Excel

90: Sum ? / Numbers with Text

91: Copy Sub Totals

92: vlookup in VBA

93: ADO recordset XML format for globalization

94: Macros in Formulas

95: Excel 2000 hangs when I exit. Reloading failed. Now what?

96: Help generating combinations

97: Search Specific Column for a matched entry

98: UserForm including TextBox with date (UK format)

99: Automaticall disable Protection menu

100: Calc Prorated Cost based Specific Days in a Gven Month & Year Range.

101: run a macro in a protected sheet

102: Range Matrix

103: Change font size?

104: copy worksheet from previous month and rename to current month

105: Pivot table drop down lists

106: Pivot table text field limit of 255

107: Transfering Info

108: listbox control in VBA

109: SUMIF + INDIRECT?

110: VBS starts Excel. How to point to different macro when run?

111: If's conditions about matching

112: protection/pivot table

113: Cells with formulas won't update unless I click in browser Why?

114: Choosing cells based on date...

115: Referencing worksheet names

116: Greek Letters or Symbols in Excel

117: Adding Code Module to Workbook

118: Macro slow down

119: User form to comments

120: utility to add standard comment

121: Excel 2002 - Internet Explorer Windows opening up uncontrollably

122: MI5 Persecution: Security Service Tribunal Denies

123: Converting Time Data

124: Problem Printing

125: Relative vs Absolute References (VBA Code)

126: Extract email addresses

127: HOW TO: Highlight cell if number in cell changes

128: Counting by colour dilemma!!

129: clicking shortcut opens excel prog, but not highlighted file-why?

130: Help with formula

131: projecting when a person is 70 from DOB

132: Sorting multiple columns in VBA

133: Icons at the top are suddenly large. How do I return them to norm

134: Combining related unique (distinct) values from two columns into an array

135: Locked in

136: Data referencing

137: Extracting Data

138: Setting cursor location on opening

139: save to multiple locations simultaneously

140: How to read data from xls files?

141: Pivot Table: Change dates to fiscal year

142: calculate date between

143: Add-ins Referencing

144: Protected Cells

145: Removing Hyperlinks

146: Circular reference problem

147: Running Code Automatically

148: Change checkbox value...

149: Listbox Question

150: collating 3 columns into one without redundancy

151: Various Random Codes not working from time to time

152: sum if and a range of cells

153: Data Consolidation w/ Multiple List Boxes

154: Greeting Function

155: conditional formatting consecutive cells

156: Blank Cell/IF Problem

157: comma "," on the fomatting toolbar

158: Additional column

159: How to catch the colorindex in a series

160: Referencing worksheet

161: Printing a Word document from Excel spreadsheet

162: searching names for '*', replacing it with first name

163: Control End

164: Sorting Columns - XL 2003

165: How do you compare 2 different spreadsheets for duplication?

166: Newbie question!

167: textbox in userform(vertical center)

168: how to specify "not equal to"?

169: total number from start date to end date

170: Pivot tables

171: How can I retrieve data from the same cell, from multiple sheets?

172: Excel External Data Selective Import.

173: Transpose macro?

174: Paste Error

175: help!! please with formatting excel to labels

176: Name of a Sheet in a Macro linked to a cell.

177: Delivery number for all dates in delivery period

178: excel formula and vba

179: Automatically opening several Excel Files at startup

180: Is It Possible in Excel ???

181: Display numbers only, no text formula

182: Formula to Get the Max of a column and its definition

183: Setting cell borders

184: work with multiple workbooks on separate monitor for 2003 edition

185: Define Print Area using Variables

186: Buttons disappear when projected

187: Can Vba Help With Auto-checking My Spreadsheet?

188: Excel Question

189: SUMPRODUCT #VALUE! problem

190: VBE Help

191: Unsaved data

192: Can I lock a row so that it's always the last row on the page?

193: Autosave

194: Why is coditional formatting not accessable?

195: Setting up a ledger theme in excel

196: pulling information from a closed workbook (revised)

197: Long Time Delay To Paste From UserForm To Sheet

198: find row

199: Excel fails to lock file across VPN?

200: Need help

201: File is saved on opening

202: Write Holidays between two dates?

203: Detail on formula language bug

204: Excel 97 Problem searching for character

205: How to repeat code for 11 files?

206: Limit to number of worksheets in an excel file?

207: Creating 1 Single Module For Several Sheets.

208: Yet another Newby question about selecting

209: Table to Table

210: Filter name and copy to another sheet.

211: How do I use sumif and mid function in same formula

212: Calendar

213: sum and count multiple conditions

214: I have two columns (A) and (G) that have like product codes however

215: NetWorkDays in VBA?

216: creating a drop down list of pricing

217: Deleting Checkbox Object in Cell

218: Opening "locked" application

219: How to create a .XLS file instead of a .CSV file

220: Multiple Cell References in GetPivotData

221: How to update a pivot table, without refreshinh the whole thing?

222: simple excel process not killed

223: Help w/Match or Lookup

224: INSERT PICTURE IN MACRO

225: Statement to ignore step if does not find text to Split

226: Links are broken and cannot fix

227: Filtered Validation List

228: Wrap Text problem

229: can someone help me with this formula

230: print preview

231: Request for help from Otto

232: Evaluating files without opening

233: how do i covert number to words in excel?

234: Sorting '# 9" numberically instead of alphbetically

235: Referencing a cell for a value in VBA code

236: Formula in Marksheet

237: adding border from userform

238: PivotChart Formatting and screen updating

239: Why when I go to sort does it automatically highlight from #1028?

240: Open CSV

241: Mail merge - Multiple entries

242: Background and cells

243: Pointer-like behaviour in Excel possible to build formulas?

244: For guru's: textbox printing problems

245: getting Excel to create an extra column

246: Last Cell in a Column Value

247: Searching and Then Copy Cell to word

248: Top 10 Spreadsheets Program in the World

249: Refresh workbook changes without saving

250: E-mailing a Mail Merge via Excel

251: Search range add value

252: Application Event Scope Problem

253: Autofilter +Create Sheets

254: COUNT with Multiple Criteria Error

255: Using DateAdd with a text string

256: search and change without replacing-excel 2002

257: Formulas gone bonkers

258: why "..." would interpret as "?"

259: Nested IF Function and VLookup Alternatives

260: Workbook_Open() does not work

261: macro and/or functions

262: Sorting by cell or text format

263: customize a calculated field in a Pivot table

264: Count the blanks

265: Chart to show totals by monthly when source data is by day

266: Criteria Lookup based on Dates

267: Debug code in workbook open or activate events

268: Path in formula

269: If/Then and conditional formatting question

270: Need help with userform vb code, any help would be appreciated.

271: Problem with downloading data in Excel 2003

272: functions 33242

273: Reference a Sheet in Formula

274: Create Excel Grouping according to Merge Cells

275: Mapping Tables.Fields from a data source to my MS Access Table Structure

276: a test

277: Select in Listbox using keystrokes

278: Convert rows to Columns

279: Extract last name and insert into a different field.

280: Import External Data - Excel File

281: unprotect sheet macro

282: Simulate a doubleclick on Internet trough VBA

283: Need Help closing excel and documents

284: Parse Directory Filenames

285: Action Event, CheckBox, Add Row and Textbox

286: Large Based on Criteria

287: Excel 2003 - Ctrl-End selects last cell. How chg last cell addr?

288: Unlock

289: Help me make a function dependent on current sheet?!?

290: open excel and get runtime 429 error

291: Excel chart data points

292: Insert cell anywhere

293: Help!! copy worksheet and assign a name to new worksheet.

294: how to overwrite a write reserved file?

295: Please help with AddItem method

296: Excel only showing one tab when many workbooks are open

297: Macros reassigned by XL?

298: Running total of Found Substrings in MainString in Big Loop

299: Calculating dates based on the current date

300: How to code with the R1C1 Style of Reference?

301: Counting Variable Length of Rows in a Named Range

2: Formula Req'd - Autofilter limitation workaround

3: Grab Password Name

4: SIMPLE MACRO!!!

5: IF, AND, OR Function

6: list, search, and display

7: Checking HasPassword property without opening

8: Huge Memory Leaks using ODBC Drivers from Excel to retrieve data

9: getting selected listbox values

10: Grey text prints as black..

11: named range not specific to worksheet

12: Lookup problem

13: msgbox to display a cell value, HOW, If possible?

14: How to look up a value?

15: DATE Functions???

16: How to leave the lines on my exel work sheet

17: Change from Numeric to Alpha

18: How do I use auto sum with hidden cells?

19: Selecting columns with column numbers not letters

20: Monthly Change Using Nested IFs?

21: Comments on a pivot table

22: findings text in columns

23: Really tricky excel problem

24: Excel close/save/prompt problem

25: Looking for a specific Excel function/formula

26: insert real time to EXVCEL spread sheets?

27: Declaring Multi-Dimensional Arrays

28: Calculate a 30-day moving average based on the last x number of entries and date

29: Password on VBA causing problem

30: "Slidey Bar" for Code Progess

31: Ignore #N/A in a formula

32: Custom Menus

33: Type Mismatch error

34: Excel to Access using VBA

35: text comparision

36: Data Import

37: Can a replaced excel file be recovered?

38: Copying new activesheet after other activesheet is hidden?

39: open OQY file from http:// folder

40: Print enveloppes' address from Excel

41: Code Cleaner (Rob Bovey): Compile? Means what?

42: What's it take for Canadian Application?

43: Excell 2000 worksheet

44: make backup excel

45: Regression error - "NUM!"

46: bringing in data from another worksgroup to a current workgroup

47: How to detect excess rows in txt or csv files before opening?

48: counting number of particular items in a list

49: Resizing Userform to screen size

50: Copy Problem

51: Insert 19 cells "Shift to the right" if cell contains "->"

52: formating numbers

53: OT - Collaboratons

54: Filter options disabled for pivot tables.

55: SumIf(values of non calculated cells in a row...)

56: Referencing Spreadsheet in VBA

57: run macro on a CommandButton from another sheet

58: save from template to worksheet without update commands

59: Counting cells with same info in them

60: WATCH WINDOW

61: Tab Order within a frame

62: How do add time/hours to get answer in hours if Ans>24

63: Print Preview moves command buttons

64: How to put this formula using VBA

65: Vlookup Problem on Excel

66: how to display different content depends on some conditions?

67: PDFing an Excel Workbook

68: FInding a Date with wildcard

69: Practical Excel Range Looping Project

70: Formula Help Again

71: how to display answer as whole number and remainder

72: If formula with score total

73: Help with this code please

74: Make macro-button sheet reference relative

75: VBA 2003 Save|Change|Restore builtin menu OnAction

76: Cross Referance

77: Compare and group like numbers and info

78: Excel Query error

79: Page set up for a workbook, so each sheet gets the same format ?

80: Comma Style

81: Excel Macro- sort issue in Excel2003

82: Searching For Duplicates

83: Excel Addin Install via Registry

84: Old function is not working.

85: Can anybody crack this VBA problem?

86: command button on top

87: quick double-criteria lookup?

88: new user needs help with programing

89: colored baloon chart in Excel

90: Sum ? / Numbers with Text

91: Copy Sub Totals

92: vlookup in VBA

93: ADO recordset XML format for globalization

94: Macros in Formulas

95: Excel 2000 hangs when I exit. Reloading failed. Now what?

96: Help generating combinations

97: Search Specific Column for a matched entry

98: UserForm including TextBox with date (UK format)

99: Automaticall disable Protection menu

100: Calc Prorated Cost based Specific Days in a Gven Month & Year Range.

101: run a macro in a protected sheet

102: Range Matrix

103: Change font size?

104: copy worksheet from previous month and rename to current month

105: Pivot table drop down lists

106: Pivot table text field limit of 255

107: Transfering Info

108: listbox control in VBA

109: SUMIF + INDIRECT?

110: VBS starts Excel. How to point to different macro when run?

111: If's conditions about matching

112: protection/pivot table

113: Cells with formulas won't update unless I click in browser Why?

114: Choosing cells based on date...

115: Referencing worksheet names

116: Greek Letters or Symbols in Excel

117: Adding Code Module to Workbook

118: Macro slow down

119: User form to comments

120: utility to add standard comment

121: Excel 2002 - Internet Explorer Windows opening up uncontrollably

122: MI5 Persecution: Security Service Tribunal Denies

123: Converting Time Data

124: Problem Printing

125: Relative vs Absolute References (VBA Code)

126: Extract email addresses

127: HOW TO: Highlight cell if number in cell changes

128: Counting by colour dilemma!!

129: clicking shortcut opens excel prog, but not highlighted file-why?

130: Help with formula

131: projecting when a person is 70 from DOB

132: Sorting multiple columns in VBA

133: Icons at the top are suddenly large. How do I return them to norm

134: Combining related unique (distinct) values from two columns into an array

135: Locked in

136: Data referencing

137: Extracting Data

138: Setting cursor location on opening

139: save to multiple locations simultaneously

140: How to read data from xls files?

141: Pivot Table: Change dates to fiscal year

142: calculate date between

143: Add-ins Referencing

144: Protected Cells

145: Removing Hyperlinks

146: Circular reference problem

147: Running Code Automatically

148: Change checkbox value...

149: Listbox Question

150: collating 3 columns into one without redundancy

151: Various Random Codes not working from time to time

152: sum if and a range of cells

153: Data Consolidation w/ Multiple List Boxes

154: Greeting Function

155: conditional formatting consecutive cells

156: Blank Cell/IF Problem

157: comma "," on the fomatting toolbar

158: Additional column

159: How to catch the colorindex in a series

160: Referencing worksheet

161: Printing a Word document from Excel spreadsheet

162: searching names for '*', replacing it with first name

163: Control End

164: Sorting Columns - XL 2003

165: How do you compare 2 different spreadsheets for duplication?

166: Newbie question!

167: textbox in userform(vertical center)

168: how to specify "not equal to"?

169: total number from start date to end date

170: Pivot tables

171: How can I retrieve data from the same cell, from multiple sheets?

172: Excel External Data Selective Import.

173: Transpose macro?

174: Paste Error

175: help!! please with formatting excel to labels

176: Name of a Sheet in a Macro linked to a cell.

177: Delivery number for all dates in delivery period

178: excel formula and vba

179: Automatically opening several Excel Files at startup

180: Is It Possible in Excel ???

181: Display numbers only, no text formula

182: Formula to Get the Max of a column and its definition

183: Setting cell borders

184: work with multiple workbooks on separate monitor for 2003 edition

185: Define Print Area using Variables

186: Buttons disappear when projected

187: Can Vba Help With Auto-checking My Spreadsheet?

188: Excel Question

189: SUMPRODUCT #VALUE! problem

190: VBE Help

191: Unsaved data

192: Can I lock a row so that it's always the last row on the page?

193: Autosave

194: Why is coditional formatting not accessable?

195: Setting up a ledger theme in excel

196: pulling information from a closed workbook (revised)

197: Long Time Delay To Paste From UserForm To Sheet

198: find row

199: Excel fails to lock file across VPN?

200: Need help

201: File is saved on opening

202: Write Holidays between two dates?

203: Detail on formula language bug

204: Excel 97 Problem searching for character

205: How to repeat code for 11 files?

206: Limit to number of worksheets in an excel file?

207: Creating 1 Single Module For Several Sheets.

208: Yet another Newby question about selecting

209: Table to Table

210: Filter name and copy to another sheet.

211: How do I use sumif and mid function in same formula

212: Calendar

213: sum and count multiple conditions

214: I have two columns (A) and (G) that have like product codes however

215: NetWorkDays in VBA?

216: creating a drop down list of pricing

217: Deleting Checkbox Object in Cell

218: Opening "locked" application

219: How to create a .XLS file instead of a .CSV file

220: Multiple Cell References in GetPivotData

221: How to update a pivot table, without refreshinh the whole thing?

222: simple excel process not killed

223: Help w/Match or Lookup

224: INSERT PICTURE IN MACRO

225: Statement to ignore step if does not find text to Split

226: Links are broken and cannot fix

227: Filtered Validation List

228: Wrap Text problem

229: can someone help me with this formula

230: print preview

231: Request for help from Otto

232: Evaluating files without opening

233: how do i covert number to words in excel?

234: Sorting '# 9" numberically instead of alphbetically

235: Referencing a cell for a value in VBA code

236: Formula in Marksheet

237: adding border from userform

238: PivotChart Formatting and screen updating

239: Why when I go to sort does it automatically highlight from #1028?

240: Open CSV

241: Mail merge - Multiple entries

242: Background and cells

243: Pointer-like behaviour in Excel possible to build formulas?

244: For guru's: textbox printing problems

245: getting Excel to create an extra column

246: Last Cell in a Column Value

247: Searching and Then Copy Cell to word

248: Top 10 Spreadsheets Program in the World

249: Refresh workbook changes without saving

250: E-mailing a Mail Merge via Excel

251: Search range add value

252: Application Event Scope Problem

253: Autofilter +Create Sheets

254: COUNT with Multiple Criteria Error

255: Using DateAdd with a text string

256: search and change without replacing-excel 2002

257: Formulas gone bonkers

258: why "..." would interpret as "?"

259: Nested IF Function and VLookup Alternatives

260: Workbook_Open() does not work

261: macro and/or functions

262: Sorting by cell or text format

263: customize a calculated field in a Pivot table

264: Count the blanks

265: Chart to show totals by monthly when source data is by day

266: Criteria Lookup based on Dates

267: Debug code in workbook open or activate events

268: Path in formula

269: If/Then and conditional formatting question

270: Need help with userform vb code, any help would be appreciated.

271: Problem with downloading data in Excel 2003

272: functions 33242

273: Reference a Sheet in Formula

274: Create Excel Grouping according to Merge Cells

275: Mapping Tables.Fields from a data source to my MS Access Table Structure

276: a test

277: Select in Listbox using keystrokes

278: Convert rows to Columns

279: Extract last name and insert into a different field.

280: Import External Data - Excel File

281: unprotect sheet macro

282: Simulate a doubleclick on Internet trough VBA

283: Need Help closing excel and documents

284: Parse Directory Filenames

285: Action Event, CheckBox, Add Row and Textbox

286: Large Based on Criteria

287: Excel 2003 - Ctrl-End selects last cell. How chg last cell addr?

288: Unlock

289: Help me make a function dependent on current sheet?!?

290: open excel and get runtime 429 error

291: Excel chart data points

292: Insert cell anywhere

293: Help!! copy worksheet and assign a name to new worksheet.

294: how to overwrite a write reserved file?

295: Please help with AddItem method

296: Excel only showing one tab when many workbooks are open

297: Macros reassigned by XL?

298: Running total of Found Substrings in MainString in Big Loop

299: Calculating dates based on the current date

300: How to code with the R1C1 Style of Reference?

301: Counting Variable Length of Rows in a Named Range