Page 470

view full version: back to formated view

1: Setting colors for Controls

2: Infinite Loop in Error Handler

3: Return Value that exists more than all other values

4: Templates

5: Sending an email from a macro

6: Use lookup to write to cell

7: Customizing Excel

8: Auto Recovery won't work

9: Currency

10: code for closing out an excel file while in the browser?

11: Paste Selction In First Empty Cell

12: second event

13: Can't open XLS's from Outlook Express after installing MS07-036

14: Sum up results from If statement

15: Creating summary table from detail table

16: Function arguments dialog box

17: Finding duplicates in distinct ranges...

18: Can you load part of a worksheet into a userform

19: Pasting dates changes values

20: calculate which cells arrives first

21: Use a keyboard button to run a macro

22: Excel: How to insert current time (static) to the nearest second?

23: Web Tables (Querying, Using a Looping Macro)

24: Finding Time difference

25: Calculating working hours

26: checking the format of a string in a cell

27: Data validation using calculated list

28: Copy data in column based on cell value

29: For Each...won't loop through worksheets

30: Moving home

31: HOW TO HIDE FORMULA

32: Is it possible to import pic with look up formula?

33: Calculating percentages based on the number of checked boxes in a column

34: Hlookup getting confused

35: How to convert data from Columns to rows

36: 18 digits

37: Macro to Open and Compile Multiple Worksheets that are password protected

38: Question for Jim Thomlinson

39: Is there a way to have two different sheets work in one document?

40: How do you calculate text into numerical answers?

41: How can I link to a specific worksheet from a webpage?

42: Error Application.ScreenUpdating

43: display sheet choices in combo box

44: Increment linked worbook

45: SUMIF with 2 conditions

46: worksheets equaling other worksheets

47: Control Not Licensed Error

48: #N/A ErrorVLOOKUP HELP

49: if formula

50: Conditional formatting, simple question...

51: Copying data from multiple worksheets

52: Is There A Better Way To Do This Formula?

53: Central Macro Workbook

54: Can you capture worksheet double click event from an Add-In????

55: Text to the left and right of a character

56: How to change column headings from A, B, etc, to 1, 2, 3, etc.?

57: macro over range, deleting blanks

58: Attaching One Worksheet to Email

59: AutoFit function

60: COUNTA in Array Formula

61: IF Statement

62: Macro to combine data based on IF,THENs?

63: Loop/copy rows variable times to new sheet

64: Vlookup, Index or Match - Problem

65: Problem with #VALUE/0! error

66: Change font to red and bold

67: run-time error '438'

68: Debra Dalgleish's Excel file that displays a comment in a cell instead of a pop-up

69: Sumif Fucntion

70: I want to close down excel after 1 hour automatically

71: Locate a change in Col

72: Rounding

73: Extracting the Month from the Date in other cell

74: how do I format the sheet so that I may click on 1 cell at a time

75: Group rows / columns: +/- symbol at top or to the left?

76: Excel Workbook too large

77: Sorting Rows

78: Macro Help!!

79: I want to count days between two dates including start date

80: delay on copy

81: copy non-contu.data into new sheet

82: Lookup Formula Help

83: how to Interrupt text to speech run from word

84: CSV Dates Not Sorting

85: How to change hours and minutes to calculate charges?

86: Help: weild checkbox problem

87: Rounding numbers so that they are divisable by 3

88: ACTIVATING FORMULA BAR SHORTCUT

89: Using sheet names in menus etc

90: combined HLOOKUP (urgent for a friend)

91: RPC Server Unavailable

92: Textbox formatting

93: Conditional Information on Printing

94: I am seek for powerful program for SEO!!!

95: Retrieven data from closed workbooks - Ron de Bruin

96: TODAY'S DATE PLUS "BUSINESS" DAYS

97: Changing upper case characters to upper/lower

98: Help with Check Box and VBA

99: enable spell check

100: Table array in VLOOKUP (EXcel 2003)

101: Counting Dates - Not Text

102: Help - my toolbars have disappeared

103: How can I check if a pop-up menu exists...

104: I want a non-blank cell to return 25% in an adjacent cell.

105: Linear regression errors

106: Organizing functions

107: How can i calculate the age as on aparticular date on excel

108: How can I pass an array as TextToDisplay to a hyperlink?

109: Opposite of Concatenation!

110: How do I add a theme in Excel?

111: with weekly score sheet how do I column a weekly progressive aver.

112: Counting unique items based on date

113: help with IF statement

114: VBA help (and other) please

115: Import xls file..vba excel2000

116: I need some help with some functions

117: Excel 2002, Menu and Tool bars are gone.

118: How do you hide macro names from showing in "Tools"?

119: SUMPRODUCT

120: xyz

121: Creating formula

122: formula CENTILE

123: command Button

124: Pivot Table Refresh Speed

125: Problems with an if (using rng Nothing) - only to produce sheet given

126: Option buttons in Excel to perform formulas in a several Absolute.

127: I cannot find an error in excel

128: Deleting characters after a hyphen

129: VLOOKUP-common look up entry with multiple results

130: Change an Excel workbook Icon

131: Transpose unique values in one column/mult. rows into a single row

132: timed macro

133: My large numbers are showing up as a formula

134: F8 and Yellow pattern for compile error

135: How to do a line feed in a Text Box

136: Passing a variable from Excel to Word

137: Update Chart in Pivottable

138: Lookup function???/Linking Worksheets?

139: ADO vs ODBC question

140: Get only child nodes?

141: Need help changing rows into columns

142: How do I change one repeated word in the spreadsheet to another?

143: how do I combine multiple worksheets into one? not summarize

144: Converting column letters to numbers

145: Sum Cells Based on Condition (2 problems)

146: Sumproduct: condition with >?

147: Embedding a reference in a cell with normal text.

148: If criteria not met use msgbox

149: return empty string value if cell is blank

150: How to add line at today's date in chart

151: Analysis ToolPak

152: Pull last word from a text string in Excel

153: How do I update worksheet 1 from data on worksheet 2

154: DeltaE formula

155: ISERROR VLOOKUP

156: User selection from a chart

157: userform problem

158: Adding and naming new worksheets

159: Separate lines in Excel cell

160: Embed PDF in Excel UserForm

161: Screen "Flickers" When macro Starts !!

162: Im literally a beginner, please help!

163: Yes No Auto-answer?

164: Need Info A.S.A.P.

165: match largest value that is exactly equal to lookup_value

166: standard data form direct to an excel spreadsheet

167: Problem disabling/avoiding refreshall popup

168: e-mail address formatting

169: Question on automating Dialogboxes in VBA

170: multiple cell selection/events?

171: Coverting time

172: Threaded programming in VBA

173: Array problem?

174: How can I combine loan amortization schedules

175: Conditional formating a row

176: Excel macros

177: how to parse through pivot filtered items

178: HELP CANNOT MODIFY BUTTON OBJECT OR SEE ITS PROPERTIES....

179: Zoom on selection

180: Credit Card Calculation

181: are these 2 statements equivalent?

182: Setting up a simple loop to fill labels?

183: What Function Should I Use. Is this a "What If" Type of Argument?

184: can i convert data copied as an image into data in excel ?

185: Export-Import XML data

186: using variables in formula in R1C1 mode

187: calculate remaining pay periods

188: Convert arabic number to english text

189: First time deleting macros

190: Intermittent Pseudo "Break Point" on First Run but not Subsequent Runs

191: Listing of contents within CHM file

192: hide unnecessary sheets when emailing to others

193: Page Length

194: VB from excel03 not working in 07

195: Specific list sorting

196: sum array not calculating properly

197: Pickfolder Method with Userform

198: Porgramme a undo,Redo on a form

199: Writing Batch File

200: error convert to number macro

201: Calculation mode retention

202: Shortcuts for mneu created from an add-In

203: OLE Container Control in VB.NET

204: Number Question

205: Clarification to previous question

206: Copying sheets into a new work book

207: Open new workbook(s) when userform and excel are minimized

208: Range.FormulaArray drops relative reference ?

209: excel97: filtering out the zeros macro

210: Reset Collection

211: Formula that referance a Cell

212: Lost toolbar

213: How to Paste Link A Formula

214: Selecting Range in non-active sheet

215: find

216: My appreciattion to Olly, X~!

217: How to open a specific MS office file using button in Access?

218: Switch images in VBA

219: WorkSheet Macro Help!

220: formula question please

221: Conditional Formating Bug when using HasFormula UDF

222: Importing Web Data

223: Add a Row to Multiple Worksheets Simultaneously

224: Function HELP!!!

225: linking a listbox to sql table

226: How can I track down where a value is getting lost?

227: Sumif

228: detect invalid cell reference

229: Edit listbox Items

230: Skip Weekends in date

231: Eliminating digits

232: Consecutive Numbered Pages

233: What Does -- Mean In A Formula

234: Cut and Paste Data instead of Function Text

235: short way for using all sheets in one formula

236: Apply Sumprod on mix text & numbers arrays

237: PMT Function

238: MI5 Persecution: Website Index (2509)

239: run a userform by entering a number in a cell

240: finding duplicate records

241: function for conditional value from another worksheet

242: Match Last Occurrence of Numeric Value and Count BACK to Previous

243: Importing csv file all data is in first column

244: Disable Window Right Click

245: current cell in user-defined function

246: Closing Excel error message from Access 2K

247: deleting certain text from cells

248: Embedding Word Document within Excel

249: Question for dummy

250: colors for shading

251: How does Collection.Item search

252: How To Turn A Row One Of Two Colours Without CF

253: DateAdd function

254: Calculations

255: find text then insert new row above

256: CSV (Comma Separated Values) delimiter ?

257: How to make a llistbox selection to open another listbox?

258: VBA Project Deleted

259: Unique lists

260: Update Page During Hyperlink

261: Truncating numbers

262: locating cell info from one sheet

263: close window trapping

264: Formatting a single cell

265: Linking to Another Excel File (File Name Changes)

266: Parse out answers from a column

267: Excel "if" Bug?

268: Extract String based on condition

269: Color Indicator

270: Deleting a sheet if it exists?

271: Copy and paste special, values not working

272: Changing the font color in an Excel footer

273: help me. How to delete a menu

274: Saving A File

275: TABBING

276: lookup and return values using lists

277: Macro

278: text alignment

279: Mac excel

280: Password set/clear macros - help!

281: Unselect data in a Listbox

282: Re-Arranging a Block of Data

283: Creating an access log

284: Web service to Pivot table

285: How do I make a macro work in one worksheet only

286: Counting based on criteria from two cells???

287: VBA code for Deleting rows by verification

288: using autofilter custom function....filter of cells containing date...

289: how do you force a new line in a formula in Excel?

290: excell worksheets

291: using bahttext function

292: EXCEL VBA - Data compilation coming in from an external feed

293: VB 2005 and Excel

294: Averaging formula help, please.

295: ForumulaArrays - help needed.

296: Filter range array

297: International Issues

298: Creation of a range with no specified address

299: HELP! Someon's gotta know this

300: Automatically update worksheets

2: Infinite Loop in Error Handler

3: Return Value that exists more than all other values

4: Templates

5: Sending an email from a macro

6: Use lookup to write to cell

7: Customizing Excel

8: Auto Recovery won't work

9: Currency

10: code for closing out an excel file while in the browser?

11: Paste Selction In First Empty Cell

12: second event

13: Can't open XLS's from Outlook Express after installing MS07-036

14: Sum up results from If statement

15: Creating summary table from detail table

16: Function arguments dialog box

17: Finding duplicates in distinct ranges...

18: Can you load part of a worksheet into a userform

19: Pasting dates changes values

20: calculate which cells arrives first

21: Use a keyboard button to run a macro

22: Excel: How to insert current time (static) to the nearest second?

23: Web Tables (Querying, Using a Looping Macro)

24: Finding Time difference

25: Calculating working hours

26: checking the format of a string in a cell

27: Data validation using calculated list

28: Copy data in column based on cell value

29: For Each...won't loop through worksheets

30: Moving home

31: HOW TO HIDE FORMULA

32: Is it possible to import pic with look up formula?

33: Calculating percentages based on the number of checked boxes in a column

34: Hlookup getting confused

35: How to convert data from Columns to rows

36: 18 digits

37: Macro to Open and Compile Multiple Worksheets that are password protected

38: Question for Jim Thomlinson

39: Is there a way to have two different sheets work in one document?

40: How do you calculate text into numerical answers?

41: How can I link to a specific worksheet from a webpage?

42: Error Application.ScreenUpdating

43: display sheet choices in combo box

44: Increment linked worbook

45: SUMIF with 2 conditions

46: worksheets equaling other worksheets

47: Control Not Licensed Error

48: #N/A ErrorVLOOKUP HELP

49: if formula

50: Conditional formatting, simple question...

51: Copying data from multiple worksheets

52: Is There A Better Way To Do This Formula?

53: Central Macro Workbook

54: Can you capture worksheet double click event from an Add-In????

55: Text to the left and right of a character

56: How to change column headings from A, B, etc, to 1, 2, 3, etc.?

57: macro over range, deleting blanks

58: Attaching One Worksheet to Email

59: AutoFit function

60: COUNTA in Array Formula

61: IF Statement

62: Macro to combine data based on IF,THENs?

63: Loop/copy rows variable times to new sheet

64: Vlookup, Index or Match - Problem

65: Problem with #VALUE/0! error

66: Change font to red and bold

67: run-time error '438'

68: Debra Dalgleish's Excel file that displays a comment in a cell instead of a pop-up

69: Sumif Fucntion

70: I want to close down excel after 1 hour automatically

71: Locate a change in Col

72: Rounding

73: Extracting the Month from the Date in other cell

74: how do I format the sheet so that I may click on 1 cell at a time

75: Group rows / columns: +/- symbol at top or to the left?

76: Excel Workbook too large

77: Sorting Rows

78: Macro Help!!

79: I want to count days between two dates including start date

80: delay on copy

81: copy non-contu.data into new sheet

82: Lookup Formula Help

83: how to Interrupt text to speech run from word

84: CSV Dates Not Sorting

85: How to change hours and minutes to calculate charges?

86: Help: weild checkbox problem

87: Rounding numbers so that they are divisable by 3

88: ACTIVATING FORMULA BAR SHORTCUT

89: Using sheet names in menus etc

90: combined HLOOKUP (urgent for a friend)

91: RPC Server Unavailable

92: Textbox formatting

93: Conditional Information on Printing

94: I am seek for powerful program for SEO!!!

95: Retrieven data from closed workbooks - Ron de Bruin

96: TODAY'S DATE PLUS "BUSINESS" DAYS

97: Changing upper case characters to upper/lower

98: Help with Check Box and VBA

99: enable spell check

100: Table array in VLOOKUP (EXcel 2003)

101: Counting Dates - Not Text

102: Help - my toolbars have disappeared

103: How can I check if a pop-up menu exists...

104: I want a non-blank cell to return 25% in an adjacent cell.

105: Linear regression errors

106: Organizing functions

107: How can i calculate the age as on aparticular date on excel

108: How can I pass an array as TextToDisplay to a hyperlink?

109: Opposite of Concatenation!

110: How do I add a theme in Excel?

111: with weekly score sheet how do I column a weekly progressive aver.

112: Counting unique items based on date

113: help with IF statement

114: VBA help (and other) please

115: Import xls file..vba excel2000

116: I need some help with some functions

117: Excel 2002, Menu and Tool bars are gone.

118: How do you hide macro names from showing in "Tools"?

119: SUMPRODUCT

120: xyz

121: Creating formula

122: formula CENTILE

123: command Button

124: Pivot Table Refresh Speed

125: Problems with an if (using rng Nothing) - only to produce sheet given

126: Option buttons in Excel to perform formulas in a several Absolute.

127: I cannot find an error in excel

128: Deleting characters after a hyphen

129: VLOOKUP-common look up entry with multiple results

130: Change an Excel workbook Icon

131: Transpose unique values in one column/mult. rows into a single row

132: timed macro

133: My large numbers are showing up as a formula

134: F8 and Yellow pattern for compile error

135: How to do a line feed in a Text Box

136: Passing a variable from Excel to Word

137: Update Chart in Pivottable

138: Lookup function???/Linking Worksheets?

139: ADO vs ODBC question

140: Get only child nodes?

141: Need help changing rows into columns

142: How do I change one repeated word in the spreadsheet to another?

143: how do I combine multiple worksheets into one? not summarize

144: Converting column letters to numbers

145: Sum Cells Based on Condition (2 problems)

146: Sumproduct: condition with >?

147: Embedding a reference in a cell with normal text.

148: If criteria not met use msgbox

149: return empty string value if cell is blank

150: How to add line at today's date in chart

151: Analysis ToolPak

152: Pull last word from a text string in Excel

153: How do I update worksheet 1 from data on worksheet 2

154: DeltaE formula

155: ISERROR VLOOKUP

156: User selection from a chart

157: userform problem

158: Adding and naming new worksheets

159: Separate lines in Excel cell

160: Embed PDF in Excel UserForm

161: Screen "Flickers" When macro Starts !!

162: Im literally a beginner, please help!

163: Yes No Auto-answer?

164: Need Info A.S.A.P.

165: match largest value that is exactly equal to lookup_value

166: standard data form direct to an excel spreadsheet

167: Problem disabling/avoiding refreshall popup

168: e-mail address formatting

169: Question on automating Dialogboxes in VBA

170: multiple cell selection/events?

171: Coverting time

172: Threaded programming in VBA

173: Array problem?

174: How can I combine loan amortization schedules

175: Conditional formating a row

176: Excel macros

177: how to parse through pivot filtered items

178: HELP CANNOT MODIFY BUTTON OBJECT OR SEE ITS PROPERTIES....

179: Zoom on selection

180: Credit Card Calculation

181: are these 2 statements equivalent?

182: Setting up a simple loop to fill labels?

183: What Function Should I Use. Is this a "What If" Type of Argument?

184: can i convert data copied as an image into data in excel ?

185: Export-Import XML data

186: using variables in formula in R1C1 mode

187: calculate remaining pay periods

188: Convert arabic number to english text

189: First time deleting macros

190: Intermittent Pseudo "Break Point" on First Run but not Subsequent Runs

191: Listing of contents within CHM file

192: hide unnecessary sheets when emailing to others

193: Page Length

194: VB from excel03 not working in 07

195: Specific list sorting

196: sum array not calculating properly

197: Pickfolder Method with Userform

198: Porgramme a undo,Redo on a form

199: Writing Batch File

200: error convert to number macro

201: Calculation mode retention

202: Shortcuts for mneu created from an add-In

203: OLE Container Control in VB.NET

204: Number Question

205: Clarification to previous question

206: Copying sheets into a new work book

207: Open new workbook(s) when userform and excel are minimized

208: Range.FormulaArray drops relative reference ?

209: excel97: filtering out the zeros macro

210: Reset Collection

211: Formula that referance a Cell

212: Lost toolbar

213: How to Paste Link A Formula

214: Selecting Range in non-active sheet

215: find

216: My appreciattion to Olly, X~!

217: How to open a specific MS office file using button in Access?

218: Switch images in VBA

219: WorkSheet Macro Help!

220: formula question please

221: Conditional Formating Bug when using HasFormula UDF

222: Importing Web Data

223: Add a Row to Multiple Worksheets Simultaneously

224: Function HELP!!!

225: linking a listbox to sql table

226: How can I track down where a value is getting lost?

227: Sumif

228: detect invalid cell reference

229: Edit listbox Items

230: Skip Weekends in date

231: Eliminating digits

232: Consecutive Numbered Pages

233: What Does -- Mean In A Formula

234: Cut and Paste Data instead of Function Text

235: short way for using all sheets in one formula

236: Apply Sumprod on mix text & numbers arrays

237: PMT Function

238: MI5 Persecution: Website Index (2509)

239: run a userform by entering a number in a cell

240: finding duplicate records

241: function for conditional value from another worksheet

242: Match Last Occurrence of Numeric Value and Count BACK to Previous

243: Importing csv file all data is in first column

244: Disable Window Right Click

245: current cell in user-defined function

246: Closing Excel error message from Access 2K

247: deleting certain text from cells

248: Embedding Word Document within Excel

249: Question for dummy

250: colors for shading

251: How does Collection.Item search

252: How To Turn A Row One Of Two Colours Without CF

253: DateAdd function

254: Calculations

255: find text then insert new row above

256: CSV (Comma Separated Values) delimiter ?

257: How to make a llistbox selection to open another listbox?

258: VBA Project Deleted

259: Unique lists

260: Update Page During Hyperlink

261: Truncating numbers

262: locating cell info from one sheet

263: close window trapping

264: Formatting a single cell

265: Linking to Another Excel File (File Name Changes)

266: Parse out answers from a column

267: Excel "if" Bug?

268: Extract String based on condition

269: Color Indicator

270: Deleting a sheet if it exists?

271: Copy and paste special, values not working

272: Changing the font color in an Excel footer

273: help me. How to delete a menu

274: Saving A File

275: TABBING

276: lookup and return values using lists

277: Macro

278: text alignment

279: Mac excel

280: Password set/clear macros - help!

281: Unselect data in a Listbox

282: Re-Arranging a Block of Data

283: Creating an access log

284: Web service to Pivot table

285: How do I make a macro work in one worksheet only

286: Counting based on criteria from two cells???

287: VBA code for Deleting rows by verification

288: using autofilter custom function....filter of cells containing date...

289: how do you force a new line in a formula in Excel?

290: excell worksheets

291: using bahttext function

292: EXCEL VBA - Data compilation coming in from an external feed

293: VB 2005 and Excel

294: Averaging formula help, please.

295: ForumulaArrays - help needed.

296: Filter range array

297: International Issues

298: Creation of a range with no specified address

299: HELP! Someon's gotta know this

300: Automatically update worksheets