Page 440

view full version: back to formated view

1: Email worksheet from a list of names and email

2: MSForms 2.0 Combobox problem

3: Weekly Mortgage template

4: Code Erasing Cell Contents Inappropriately

5: Last, First Name Swap

6: Clear color but not pattern?

7: make the parameters show up when you create your own functions

8: VBA Macros that don't steal focus?

9: 50% formula

10: Copy worksheet template to all files

11: workbook.saved property

12: Printing with much text in a cell

13: replace unicode characters

14: Re: CSV with , not ;

15: How do I Open A UserForm in a Worksheet

16: Open File Location

17: Adding & Subtracting formula for a Cell

18: Conditional formatting as a formula

19: look up a set of values,copy a range of data into 2nd file

20: Macro Help replacing dropped zeros

21: Looking up a maximum value that matches criteria. VLOOKUP?

22: check for #N/A

23: How to use an array function in a macro

24: Autocalculate Missing

25: How to show data from other sheet depend on value??

26: Can I do this?

27: how to do a nested if statement

28: Grouping together cells with similar label.

29: Cell shading problem

30: Date Function

31: Change date format

32: Why does spreadsheet automatically open

33: Excel file bloat using ADO

34: Worksheet_SelectionChange

35: Helo with excel marco

36: Upload worksheer?

37: excel template that can add up hours and cost per hour

38: Excel automation

39: Disable Tools, Protect, Protect Workbook

40: Macro and probabilities

41: AVERAGE & SUMPRODUCT

42: Edit Query

43: viewing sheets

44: Variables

45: How do I subtotal data and then sort these subtotals in ascending.

46: how do you send a email from an specific excel column (database)..

47: Calculating Interest Earned

48: Advice for a newbie

49: HELP! How do I save Data

50: Data Validation Query: - Time H:MM Format

51: XLS - > frontpage

52: Formula to show cursor's whereabouts

53: "Application-defined or object-defined error" while printing excel report

54: update access mdb ...

55: create links to check boxes marked "good" fair"and "bad"

56: Custom Views

57: Excel throws -2147417851 (80010105) The server threw an exception. for no apparent reason

58: Open CSV In One Column or Multiple Columns?

59: Replace in Excel 97

60: Populating a listbox from range xl2003

61: Building automatic E-mail alerts or reports based on conditional a

62: Inserting a row when a value is entered

63: Working days and hours calculation - request assistance please!

64: Please help

65: Insert Total row if duplicates exists

66: why did the macro stopped working?

67: Extracting Data

68: Files in a dir

69: Last Part of Code won't run

70: Cell borders print default rather than custom setting.

71: VBA codes for macro to continue

72: bar graph colors?

73: How do I mail merge 2nd sheet of an excel sheet?

74: runtime error in macro

75: Re: Help with Excel VB macro...

76: cell format changed when data entered

77: symbol in a drop down list HELP!!!!!!

78: validate list xl2000

79: Creating a Pivot Table directly from an Array

80: READ ONLY RECORD SETS

81: copy named range

82: MACRO IS NOT COMPLETE

83: Formula

84: Excel 2003 vs Excel 2007 addins

85: Summarizing field quantities for specific records

86: Charts using Chart Wizard based Macro

87: Concatenating Functions

88: Industrial Limit Switch Interface with Excel

89: entering a matrix that contains formulae

90: Sorting a Range using VBA

91: finding odd due dates

92: User Defined Function - Title

93: Conditional Formula

94: Small Macro Revision - to highlight rows and enter how many times they appear in a cell rather than a msg box.

95: Printing Page Numbers for Multiple Worksheets

96: Worksheet_change

97: combobox problem

98: Code for modify a column

99: Sum if with a list as criteria

100: Adding hyperlink after the existing data in the cell

101: Variable Type - help me to solve this

102: Theuns

103: Calculate birth date from age

104: Extend series using ref cell formula transposed

105: Copy File into Worksheet

106: Problem with Sumif formula

107: OR

108: Using a macro to perform a mail merge

109: AutomaticLinks

110: lookup on Outlook contacts

111: How to use INDIRECT

112: ListBox drag & drop

113: Disabling or capturing a Delete Sheet command

114: class events stop firing with ADO 2.8

115: mouse pointer unstable

116: Help - old code inherited with project

117: POP-UP

118: Disable right click

119: Adding values based on a VLOOKUP?

120: how 2 Count number of cells that have specific condition format?

121: listing items from listbox

122: vb help, convert excel formula to vb formula

123: Automated cell copy depending on cell content?

124: Rename sheet

125: Auto populate data from a table into cells after a match is found

126: Using a MACRO to sort data

127: Spinners aren't cutting it

128: SaveAs method fails when saving to FTP site.

129: Bold Font

130: List Box

131: Help with updating one spreadsheet off of another automatically

132: Help Vlookup from Validation List

133: CTRL+TAB!!!!!!

134: Error handling question

135: Worksheet Change Event

136: ActiveX HELP!!

137: how do i search for duplicated numbers?

138: Combining COUNTIF and AND functions

139: Average with 2 criteria including month

140: Absolute Reference

141: enter formula once for entire column

142: How to fix "complie error:procedures" in Excel?

143: Developing custom secure Excel add-ins

144: Complete newb, I know!

145: CSV grabbing html

146: Formula problem

147: Cell colors

148: open file, then call macro... won't work

149: Macro is not responding

150: Imbed SQL in Excel ?

151: Copy 1 Row to Multiple Rows

152: Unload/Hide Userform when switching to a new Wbk

153: Use INDIRECT function to reference a value in closed file

154: Number sorting

155: Case statement in variable range

156: Help with Macro

157: Can you automatically add a comment to a cell

158: Autofilter - showing # rows found (or NOT)

159: Select File Copy/Paste Macro Help....

160: Number Formatting within an If statement

161: conditional headings

162: How do I produce Automatic Quotation Numbers in Excel?

163: Jumping bar at bottom of screen

164: Help with calculation

165: display 0 instead of #DIV/0!

166: Copy Range but Skip blank rows Q Options

167: SAP interfaces

168: Problem with advanced filter

169: add a Text Box and a Check Box on a sheet

170: Simple? Formatting Question

171: hyperlink to sheet with name in cell

172: Unhiding workbook when loaded

173: editing multiple sheets at once

174: Big problem with references in formulas

175: conditional formatting formula

176: Printing

177: find all key-value pairs if there is key with different value

178: Disable Fill Down, Right, Up....

179: ASP to Excel

180: Macro help: VLOOKUP with conditions

181: Insert xls into html

182: Sum with #N/A

183: How to use Find

184: Lock only borders

185: How do I count based on conditions on two fields in data?

186: How to save selected cells as jpeg or pdf or webpage format?

187: Date format

188: conditional formula question

189: Relative standard deviation in Excel

190: Select column at run-time

191: progress box while macro is running

192: Find red cell in macro

193: auto Insert text ---- ' ----

194: testing for a string type

195: How to align entries in columns so other columns will follow ?

196: alfabet

197: Return the number of Sheets in a Workbook

198: how do i convert the number 1 as 01 or 001 in excell cell

199: Unwanted "text to columns" when pasting text

200: Too wrapped up in macros!

201: Can links created in a text box be conditional?

202: Find in Excel VBA

203: how can I know if a workbook is locked?

204: massaging duplicates

205: Use a button to create a table in excel without overwriting cells

206: Web Query Sleep or Wait for return values

207: Clear formulae

208: Several encryption schemes suddenly missing in Excel 2003

209: redim preserve

210: Setting Zoom according to User on a network

211: Largest Value

212: How can you find out where a VBA function is used in a spreadsheet?

213: quick way to combine 2 files?

214: Search for an asterisk

215: Counting in ranged intervals

216: ActiveWorkbook.VBProject

217: change cell contents

218: print visible data only

219: Problem in PasteSpecial function

220: how to display the column or cell the MIN() result came from?

221: Documenting external query for PivotTables

222: Programing a footer

223: Disable moving sheets

224: Setting the Send to Value xlDialogSendMail

225: DDEExecute With Very Long Strings

226: selecting every tenth row in excel

227: Macro to send email to multiple addresses

228: timer in Excel VBA

229: Last row - Selected Column

230: Sorting

231: Auto fill of cell with information from seperate sheet

232: hiding the Menu bar

233: Password Protection

234: Problems with Array

235: Data Validation Advice

236: how to include formula

237: User Forms

238: VIEWING adjacent/nonadjacent cells or cell ranges in Excel 2007

239: Leading single quote

240: Recorded macro's to be simplified??

241: Sum by Fill colour

242: border every other cell in range

243: Copy & Paste sections of data

244: selection

245: VLOOKUP gives duplicate results for "empty" searches

246: run an excelfile/macro automatically

247: Excel 2003/edit/replace. Under Options/Look In, values is AWOL bu.

248: Compile Error: Proceedure too large

249: Formula between Worksheets and Drop down list

250: Complex Pivot table formatting

251: Bloomberg print

252: Date functionality

253: Excel Display Problem???

254: Lists from other worksheets

255: Help!!

256: End of run 'clean up" . . .

257: Copy range from one workbook to another

258: Linking error

259: Need a formula to link colum cells to row cell in a different sheet

260: copy cell to next open line

261: Range Total

262: hiding data

263: counting cells using multiple criteria

264: Leftover formatting in code

265: total the column anyway

266: Excel 200 Automation and IIS7

267: Anyone has any idea about XF: Extended Format (E0h) record ?

268: random number generation

269: Excel AutoShape Effects

270: Printing

271: How to view a PDF file opening as Excel?

272: the If Statements

273: I want to add a checkbox at the end to return data to a separate s

274: Format external data

275: Using MATCH with parameters from functions...

276: Date formatting problem

277: Duplicate information

278: pivot chart exclude rows

279: Find and Replace

280: Hyperlinks

281: If condition

282: copying a chart and/or bookmarking a chart

283: Help with code

284: scroll records with distinct value in column

285: Follow a hyperlink

286: Transferring from CSV file to AS400...

287: =cell("filename")

288: Removing section of a string in VBA

289: vba for lookup and autofill

290: start a macro when file opens??

291: Worksheet_Change

292: Multiple cells to listbox

293: Filtering a database then copying visible cells based on CurrentRe

294: Worksheet change Event

295: Question on Linefeeds and Carriage returns...

296: How do I change the rows number?

297: Save as using cell content in file name

298: Number of occurances of the larges value in an array?

299: createfolder

300: How to marry two working countif formulas?

301: How do you create a random number generator in Excel?

2: MSForms 2.0 Combobox problem

3: Weekly Mortgage template

4: Code Erasing Cell Contents Inappropriately

5: Last, First Name Swap

6: Clear color but not pattern?

7: make the parameters show up when you create your own functions

8: VBA Macros that don't steal focus?

9: 50% formula

10: Copy worksheet template to all files

11: workbook.saved property

12: Printing with much text in a cell

13: replace unicode characters

14: Re: CSV with , not ;

15: How do I Open A UserForm in a Worksheet

16: Open File Location

17: Adding & Subtracting formula for a Cell

18: Conditional formatting as a formula

19: look up a set of values,copy a range of data into 2nd file

20: Macro Help replacing dropped zeros

21: Looking up a maximum value that matches criteria. VLOOKUP?

22: check for #N/A

23: How to use an array function in a macro

24: Autocalculate Missing

25: How to show data from other sheet depend on value??

26: Can I do this?

27: how to do a nested if statement

28: Grouping together cells with similar label.

29: Cell shading problem

30: Date Function

31: Change date format

32: Why does spreadsheet automatically open

33: Excel file bloat using ADO

34: Worksheet_SelectionChange

35: Helo with excel marco

36: Upload worksheer?

37: excel template that can add up hours and cost per hour

38: Excel automation

39: Disable Tools, Protect, Protect Workbook

40: Macro and probabilities

41: AVERAGE & SUMPRODUCT

42: Edit Query

43: viewing sheets

44: Variables

45: How do I subtotal data and then sort these subtotals in ascending.

46: how do you send a email from an specific excel column (database)..

47: Calculating Interest Earned

48: Advice for a newbie

49: HELP! How do I save Data

50: Data Validation Query: - Time H:MM Format

51: XLS - > frontpage

52: Formula to show cursor's whereabouts

53: "Application-defined or object-defined error" while printing excel report

54: update access mdb ...

55: create links to check boxes marked "good" fair"and "bad"

56: Custom Views

57: Excel throws -2147417851 (80010105) The server threw an exception. for no apparent reason

58: Open CSV In One Column or Multiple Columns?

59: Replace in Excel 97

60: Populating a listbox from range xl2003

61: Building automatic E-mail alerts or reports based on conditional a

62: Inserting a row when a value is entered

63: Working days and hours calculation - request assistance please!

64: Please help

65: Insert Total row if duplicates exists

66: why did the macro stopped working?

67: Extracting Data

68: Files in a dir

69: Last Part of Code won't run

70: Cell borders print default rather than custom setting.

71: VBA codes for macro to continue

72: bar graph colors?

73: How do I mail merge 2nd sheet of an excel sheet?

74: runtime error in macro

75: Re: Help with Excel VB macro...

76: cell format changed when data entered

77: symbol in a drop down list HELP!!!!!!

78: validate list xl2000

79: Creating a Pivot Table directly from an Array

80: READ ONLY RECORD SETS

81: copy named range

82: MACRO IS NOT COMPLETE

83: Formula

84: Excel 2003 vs Excel 2007 addins

85: Summarizing field quantities for specific records

86: Charts using Chart Wizard based Macro

87: Concatenating Functions

88: Industrial Limit Switch Interface with Excel

89: entering a matrix that contains formulae

90: Sorting a Range using VBA

91: finding odd due dates

92: User Defined Function - Title

93: Conditional Formula

94: Small Macro Revision - to highlight rows and enter how many times they appear in a cell rather than a msg box.

95: Printing Page Numbers for Multiple Worksheets

96: Worksheet_change

97: combobox problem

98: Code for modify a column

99: Sum if with a list as criteria

100: Adding hyperlink after the existing data in the cell

101: Variable Type - help me to solve this

102: Theuns

103: Calculate birth date from age

104: Extend series using ref cell formula transposed

105: Copy File into Worksheet

106: Problem with Sumif formula

107: OR

108: Using a macro to perform a mail merge

109: AutomaticLinks

110: lookup on Outlook contacts

111: How to use INDIRECT

112: ListBox drag & drop

113: Disabling or capturing a Delete Sheet command

114: class events stop firing with ADO 2.8

115: mouse pointer unstable

116: Help - old code inherited with project

117: POP-UP

118: Disable right click

119: Adding values based on a VLOOKUP?

120: how 2 Count number of cells that have specific condition format?

121: listing items from listbox

122: vb help, convert excel formula to vb formula

123: Automated cell copy depending on cell content?

124: Rename sheet

125: Auto populate data from a table into cells after a match is found

126: Using a MACRO to sort data

127: Spinners aren't cutting it

128: SaveAs method fails when saving to FTP site.

129: Bold Font

130: List Box

131: Help with updating one spreadsheet off of another automatically

132: Help Vlookup from Validation List

133: CTRL+TAB!!!!!!

134: Error handling question

135: Worksheet Change Event

136: ActiveX HELP!!

137: how do i search for duplicated numbers?

138: Combining COUNTIF and AND functions

139: Average with 2 criteria including month

140: Absolute Reference

141: enter formula once for entire column

142: How to fix "complie error:procedures" in Excel?

143: Developing custom secure Excel add-ins

144: Complete newb, I know!

145: CSV grabbing html

146: Formula problem

147: Cell colors

148: open file, then call macro... won't work

149: Macro is not responding

150: Imbed SQL in Excel ?

151: Copy 1 Row to Multiple Rows

152: Unload/Hide Userform when switching to a new Wbk

153: Use INDIRECT function to reference a value in closed file

154: Number sorting

155: Case statement in variable range

156: Help with Macro

157: Can you automatically add a comment to a cell

158: Autofilter - showing # rows found (or NOT)

159: Select File Copy/Paste Macro Help....

160: Number Formatting within an If statement

161: conditional headings

162: How do I produce Automatic Quotation Numbers in Excel?

163: Jumping bar at bottom of screen

164: Help with calculation

165: display 0 instead of #DIV/0!

166: Copy Range but Skip blank rows Q Options

167: SAP interfaces

168: Problem with advanced filter

169: add a Text Box and a Check Box on a sheet

170: Simple? Formatting Question

171: hyperlink to sheet with name in cell

172: Unhiding workbook when loaded

173: editing multiple sheets at once

174: Big problem with references in formulas

175: conditional formatting formula

176: Printing

177: find all key-value pairs if there is key with different value

178: Disable Fill Down, Right, Up....

179: ASP to Excel

180: Macro help: VLOOKUP with conditions

181: Insert xls into html

182: Sum with #N/A

183: How to use Find

184: Lock only borders

185: How do I count based on conditions on two fields in data?

186: How to save selected cells as jpeg or pdf or webpage format?

187: Date format

188: conditional formula question

189: Relative standard deviation in Excel

190: Select column at run-time

191: progress box while macro is running

192: Find red cell in macro

193: auto Insert text ---- ' ----

194: testing for a string type

195: How to align entries in columns so other columns will follow ?

196: alfabet

197: Return the number of Sheets in a Workbook

198: how do i convert the number 1 as 01 or 001 in excell cell

199: Unwanted "text to columns" when pasting text

200: Too wrapped up in macros!

201: Can links created in a text box be conditional?

202: Find in Excel VBA

203: how can I know if a workbook is locked?

204: massaging duplicates

205: Use a button to create a table in excel without overwriting cells

206: Web Query Sleep or Wait for return values

207: Clear formulae

208: Several encryption schemes suddenly missing in Excel 2003

209: redim preserve

210: Setting Zoom according to User on a network

211: Largest Value

212: How can you find out where a VBA function is used in a spreadsheet?

213: quick way to combine 2 files?

214: Search for an asterisk

215: Counting in ranged intervals

216: ActiveWorkbook.VBProject

217: change cell contents

218: print visible data only

219: Problem in PasteSpecial function

220: how to display the column or cell the MIN() result came from?

221: Documenting external query for PivotTables

222: Programing a footer

223: Disable moving sheets

224: Setting the Send to Value xlDialogSendMail

225: DDEExecute With Very Long Strings

226: selecting every tenth row in excel

227: Macro to send email to multiple addresses

228: timer in Excel VBA

229: Last row - Selected Column

230: Sorting

231: Auto fill of cell with information from seperate sheet

232: hiding the Menu bar

233: Password Protection

234: Problems with Array

235: Data Validation Advice

236: how to include formula

237: User Forms

238: VIEWING adjacent/nonadjacent cells or cell ranges in Excel 2007

239: Leading single quote

240: Recorded macro's to be simplified??

241: Sum by Fill colour

242: border every other cell in range

243: Copy & Paste sections of data

244: selection

245: VLOOKUP gives duplicate results for "empty" searches

246: run an excelfile/macro automatically

247: Excel 2003/edit/replace. Under Options/Look In, values is AWOL bu.

248: Compile Error: Proceedure too large

249: Formula between Worksheets and Drop down list

250: Complex Pivot table formatting

251: Bloomberg print

252: Date functionality

253: Excel Display Problem???

254: Lists from other worksheets

255: Help!!

256: End of run 'clean up" . . .

257: Copy range from one workbook to another

258: Linking error

259: Need a formula to link colum cells to row cell in a different sheet

260: copy cell to next open line

261: Range Total

262: hiding data

263: counting cells using multiple criteria

264: Leftover formatting in code

265: total the column anyway

266: Excel 200 Automation and IIS7

267: Anyone has any idea about XF: Extended Format (E0h) record ?

268: random number generation

269: Excel AutoShape Effects

270: Printing

271: How to view a PDF file opening as Excel?

272: the If Statements

273: I want to add a checkbox at the end to return data to a separate s

274: Format external data

275: Using MATCH with parameters from functions...

276: Date formatting problem

277: Duplicate information

278: pivot chart exclude rows

279: Find and Replace

280: Hyperlinks

281: If condition

282: copying a chart and/or bookmarking a chart

283: Help with code

284: scroll records with distinct value in column

285: Follow a hyperlink

286: Transferring from CSV file to AS400...

287: =cell("filename")

288: Removing section of a string in VBA

289: vba for lookup and autofill

290: start a macro when file opens??

291: Worksheet_Change

292: Multiple cells to listbox

293: Filtering a database then copying visible cells based on CurrentRe

294: Worksheet change Event

295: Question on Linefeeds and Carriage returns...

296: How do I change the rows number?

297: Save as using cell content in file name

298: Number of occurances of the larges value in an array?

299: createfolder

300: How to marry two working countif formulas?

301: How do you create a random number generator in Excel?