Page 332

view full version: back to formated view

1: Diverting output to another workbook?

2: pivot table

3: Append data if a duplicate found

4: Ranking

5: On Error GoTo If

6: macro too fast???

7: Shared workbook-VBA availability

8: Overwriting existing data in an Excel worksheet using ADO.Net

9: Time problem

10: use com technology to build excel addin for free distribution ?

11: Fill Handle

12: Excel VBA - Get data from 2nd workbook

13: Why doesn't it work?

14: Pasting line to a chart point

15: Use static arrays

16: Nested "if" for price list

17: hit counter question

18: Help - linking and/or formulas.

19: Another data across multiple worksheets question (ugh..)

20: KURT and SKEW functions

21: Copy excel table to Word, loss information in memory

22: PDF995 on NE00

23: Problem with formulas changing cell reference

24: file handling 2

25: compare name and copy to current worksheet

26: populating empty cell with value from above

27: MIN IF >0

28: Late Binding to Word Variables

29: Possible to have only one value in a listbox

30: Populate a form with data from a range

31: Interesting Office 12 information

32: Footer

33: Define Names

34: exporting e mail adresses from Excel into Outlook

35: Printing ranges error

36: Selection

37: Rank Formula

38: attendance sheet to add time but not.....

39: remove convert/extract the number from'12345.56; ie remove ' sign

40: Excel version comparison

41: Summing with identical Vlookup values

42: Adding a label to a data point in a chart??

43: Multi-Solving

44: Find/Replace from Table

45: Access Actions from Excel

46: Weekdays

47: Can a drop down list include multiple cells?

48: Creating a database and PivotTable with a Macro

49: how do i enable negative results in the lcm function?

50: IF/AND formulas within excel

51: Auto Editing the Row source.

52: Calculated Field in Pivot Table

53: Workbooks.Open / .Open Text - How do you stop the .xls addition?

54: Inserting Variable Number of Rows

55: Excel Problem - Delete Row Macro

56: Worksheet_Change /ActiveCell.CurrentRegion ?

57: Insert Copied Cells?

58: Create a "Send" button

59: Counting Rows - Fill ???

60: nested subtotals

61: Regresion

62: Help needed

63: Auto fill, I Think

64: forgot password

65: how to make hint of help or comment of a self-made function.

66: Updating Functions (Vlookup)

67: Trouble removing toolbar - why won't my code work?

68: Creating a Search Field?

69: 'ActiveWorkbook.Names.Add Name:' how to make range variable?

70: Finding first occurence of a number

71: URGENT - SUMIF(AND

72: Deselecting a check box if cell value changes

73: If Statement

74: Error trapping & Handling

75: Pose questions to Microsoft when an answer is not forthcoming in g

76: Loading a Text Box

77: Change Application Security Settings

78: Has anyone a template for a surveyors field book

79: Force circular reference

80: SQL.REQUEST in Excel 2002 not supported in 2007. What is new func

81: How to apply colouring as in Cells associated with Forumla

82: Check for open workbooks

83: How can I get Excel to print dashes right across a cell

84: Macro

85: How do I exclude non-duplicates from an excel file?

86: Formula for Increasing a Cell Reference by a Given Number

87: getformat

88: Suspend window while Excel VBA macro is executing

89: Dynamic Range in VBA

90: How to ignore text on SUM() function...

91: How do I move cursor to next empty space??

92: Suggestion: Excel 2007- New Conditional Formatting Rules and Optio

93: Macro closing Excel file without saving changes

94: hide save as

95: CDO emailing

96: Splitting content of cell into 2 cells

97: Does anyone know how I can import Eudora mailbox info into Excel .

98: How do I find max then sum cells above & to the left?

99: Excel not responding

100: trouble with a growth rate

101: Find&Replace on a lot of *.doc' s via an excel macro?

102: Replace ^ in web query result

103: range.activate

104: ICT Room booking system

105: pivot tables, calculated fields, empty cells and zeros

106: How can I change what is in the "name box" in Excel?

107: Multiple workbook sheet numbers!

108: Macro to compare two list

109: File dialog box

110: Excel - Fill empty cells

111: [Excel XP] Orientation of cells etc.

112: Combo Box Question

113: number of mondays in period

114: Best method to retrieve table data

115: Cell Refrences in Addin

116: Date Function

117: macro to change multiple values in a column

118: negative numbers

119: Combo Box Font

120: Combine Today() with If function

121: Changing the vlookup cell

122: How to create a ListBox with 'hyperlink'-like items in VBA ?

123: Auto Fill Color of a particular Cell if conditions are put

124: Code to Advance filter a list in a shared workbook

125: Mandatory Field in Excel 2002

126: macros code & color based functions help

127: Capitalize first letter when type a name in each cell.

128: to display content of worksheet on a user form in visual basic

129: string

130: How do I combine two Excel Workbooks and delete the duplicate colu

131: Pivot Tables: Omitting Zero Values

132: "Unable to get the Hlookup property" VBA

133: Sumif with multiple criteria with an extra twist

134: Count values in Cells Across

135: UserForm Update on the Fly

136: Iteration performance issue

137: LA User Conference October 25-27, 2006

138: invisible text boxes becoming visible

139: TextBox in UserForm with > 24h time format

140: MACRO TO FIND SUBSTRING OR SUBTEXT !

141: =CONCATENATE(A10,B10,C10)

142: trouble finding object to use

143: Messages posted today not being displayed

144: Lookup or Match and copy Urgent

145: How Close Excel from CMD prompt?

146: Help with External Data Queries

147: combination of functions?

148: VLOOKUP may be?

149: Multilevel Ranges

150: Pivot Table from multiple sheets

151: Sorting Algorithm required!

152: duplicate last name and date of birth

153: Creating a Pivot Table with VBA

154: Copy a single cell to a cell in a range

155: Page numbering

156: Limit No of Colums

157: Scrolling gives me error 424

158: Hiding subtotal groups

159: Data Columns to table

160: Compile error, variable not defined

161: Field Validation for Length & Character Type

162: replace blanks in text with + signs

163: fill series

164: Can someone please help me set boundaries on a worksheet?

165: Help modify this code please

166: Help with a Script File

167: Getting RAND() value but NOT its Function?!?

168: lock / unlock dynamically

169: Macro to check "option button" and "check box"

170: Linking Forms across seperate addins

171: how do I get a spreedsheet to print an 8x11 size

172: On opening a file auto open another

173: pivot table subtotals

174: Excel---how do i automate adding a suffix to text?

175: countif when range to count is in a different workbook

176: lock out menus?

177: Splitting cells - please help!

178: If statement + date calculation

179: two lists of numbers

180: Conditional formatting

181: Pivot Table Programming

182: How do I get my formula to stop rounding up

183: Automatically Display a data input form when active sheet changes

184: Colour Problem in Excel 2002

185: Excel VBA functions

186: Is there a way to have a excel automatically alphabetize a sheet?

187: Can I get the inserted picture's original filename.

188: Excel Send To Options

189: is there a way I can modify the save as dialong box?

190: Excel 2002

191: HELP ME!!!!!

192: For loop...

193: hjf

194: getting ### in text field

195: Formula help!

196: cannot see rows

197: Comment Box

198: Upgrading Add-Ins to Excel 2007 -- Compatibility & Bugs

199: average with mulitple ciriteria

200: Excel 12 Add-In compatibility - registerXLL fails in Office2007

201: Why wont this work!

202: Input Cell

203: HELP: VBA help file

204: How to use a array as the input for a normal formula

205: COUNTIF and VLOOKUP

206: SUMPRODUCT PROBLEM

207: Macro Question - Variable

208: Protect Formatting

209: string function

210: Graph with 3 columns - having problems - help please

211: Maintaining links to cells for database query ranges

212: Character limit on CSV files in excel?

213: Referring to a worksheet in another file.

214: Change Cells into Folders

215: paste table from pdf to excel

216: userform

217: Rounding Dates

218: remove identical data entries

219: Crazy Formula or Macro

220: Datbase check

221: Why is font so small in the autofilter dropdown

222: What IF - formula question

223: Reading Data from the clipboard

224: Cheap Software

225: MVP Published articles

226: Last used row

227: Pop up calendar

228: Select a category from a list that populates related cells

229: defined name ranges

230: How to get rid of GETPIVOTDATA function?

231: Copy and email

232: Office Web Components 11 - Excel 2003

233: macro checking

234: paste macro to a workbook code

235: Number Formatting

236: test please ignore

237: Best way to do this!!

238: Proper Case

239: Timesheet to monitor flexi-time

240: windows installer

241: counting occurances

242: how do i delete just 1 hyperlink in a column of many?

243: Extract rows with specific text in a column

244: Formula to lookup info in a table

245: Using Data Form

246: Conditional formatting formulas

247: Event macro to extract data based on value of 2 cells - help

248: Drop down menu

249: Excel 2002: How to sort row totals in Pivot Table ?

250: Comparing columns

251: Macro to create format painter

252: Formula help

253: Macro question

254: Slow Load Help

255: How to return multiple instances using VLOOKUP

256: veryhidden with xl2000 & xl2003

257: In-cell progress bars?

258: Formula help - indirect & sumif & dates .....

259: number of times

260: Read only in excel

261: recent postings not seen

262: Copying non-contiguos cells.

263: How do I check for duplications in a range of data (excel)?

264: Calendar Control - closing out

265: HOW CAN I BRING MULTIPLES VALUES TO A CELL FROM OTHER SHEET

266: Sound Alarm when time expires

267: I need to link only certain cell...

268: How to create seperator in Right click..?

269: Lock Cells with a Forumlae

270: How do I calculate the statistical measure known as omega?

271: Count if cells have multiple data

272: Replace can't find text

273: Excel Autofill Method of Range Class Failed

274: SaveAs

275: Hidden Text in Fields - MS2003 Student Teacher edition

276: Any utility for joining two or more Excel or CVS files

277: In Pivot Table - can sum be changed to average?

278: Operator for "between"

279: How to write IF function in Excel 2000 when there are two conditi.

280: (reposte X 3) Anyone???? Have I stumped the Excel community?

281: Anyone have ideas on the Public Variant problem I posted about 5 or 8 posts ago

282: Common Data in Add_In

283: if any range on sheet2 change put "a" in sheet1 cell a111

284: Automate compacting database

285: Another Conditional Formatting Question

286: Workbook_BeforeClose problem

287: Sorting Issue (Mixde Fields)

288: how to stop created sheet from linking to another sheet

289: Command

290: Simplifying Excel Recorded Macro Code

291: freezing formulas after calculation

292: Autosaving files with different names

293: Protecting VBA Macros

294: How can I create customized help or instructions?

295: NEED TO CREATE A CONDITIONAL FORMULA

296: Barcode reader - to store data in Excel

297: Creating simplest Excel Hangman

298: How do you change Cell name reference from R[-2]C[-1] back to C2

299: Need small help with excel macro please

300: Pivot Table

301: DSUM function

2: pivot table

3: Append data if a duplicate found

4: Ranking

5: On Error GoTo If

6: macro too fast???

7: Shared workbook-VBA availability

8: Overwriting existing data in an Excel worksheet using ADO.Net

9: Time problem

10: use com technology to build excel addin for free distribution ?

11: Fill Handle

12: Excel VBA - Get data from 2nd workbook

13: Why doesn't it work?

14: Pasting line to a chart point

15: Use static arrays

16: Nested "if" for price list

17: hit counter question

18: Help - linking and/or formulas.

19: Another data across multiple worksheets question (ugh..)

20: KURT and SKEW functions

21: Copy excel table to Word, loss information in memory

22: PDF995 on NE00

23: Problem with formulas changing cell reference

24: file handling 2

25: compare name and copy to current worksheet

26: populating empty cell with value from above

27: MIN IF >0

28: Late Binding to Word Variables

29: Possible to have only one value in a listbox

30: Populate a form with data from a range

31: Interesting Office 12 information

32: Footer

33: Define Names

34: exporting e mail adresses from Excel into Outlook

35: Printing ranges error

36: Selection

37: Rank Formula

38: attendance sheet to add time but not.....

39: remove convert/extract the number from'12345.56; ie remove ' sign

40: Excel version comparison

41: Summing with identical Vlookup values

42: Adding a label to a data point in a chart??

43: Multi-Solving

44: Find/Replace from Table

45: Access Actions from Excel

46: Weekdays

47: Can a drop down list include multiple cells?

48: Creating a database and PivotTable with a Macro

49: how do i enable negative results in the lcm function?

50: IF/AND formulas within excel

51: Auto Editing the Row source.

52: Calculated Field in Pivot Table

53: Workbooks.Open / .Open Text - How do you stop the .xls addition?

54: Inserting Variable Number of Rows

55: Excel Problem - Delete Row Macro

56: Worksheet_Change /ActiveCell.CurrentRegion ?

57: Insert Copied Cells?

58: Create a "Send" button

59: Counting Rows - Fill ???

60: nested subtotals

61: Regresion

62: Help needed

63: Auto fill, I Think

64: forgot password

65: how to make hint of help or comment of a self-made function.

66: Updating Functions (Vlookup)

67: Trouble removing toolbar - why won't my code work?

68: Creating a Search Field?

69: 'ActiveWorkbook.Names.Add Name:' how to make range variable?

70: Finding first occurence of a number

71: URGENT - SUMIF(AND

72: Deselecting a check box if cell value changes

73: If Statement

74: Error trapping & Handling

75: Pose questions to Microsoft when an answer is not forthcoming in g

76: Loading a Text Box

77: Change Application Security Settings

78: Has anyone a template for a surveyors field book

79: Force circular reference

80: SQL.REQUEST in Excel 2002 not supported in 2007. What is new func

81: How to apply colouring as in Cells associated with Forumla

82: Check for open workbooks

83: How can I get Excel to print dashes right across a cell

84: Macro

85: How do I exclude non-duplicates from an excel file?

86: Formula for Increasing a Cell Reference by a Given Number

87: getformat

88: Suspend window while Excel VBA macro is executing

89: Dynamic Range in VBA

90: How to ignore text on SUM() function...

91: How do I move cursor to next empty space??

92: Suggestion: Excel 2007- New Conditional Formatting Rules and Optio

93: Macro closing Excel file without saving changes

94: hide save as

95: CDO emailing

96: Splitting content of cell into 2 cells

97: Does anyone know how I can import Eudora mailbox info into Excel .

98: How do I find max then sum cells above & to the left?

99: Excel not responding

100: trouble with a growth rate

101: Find&Replace on a lot of *.doc' s via an excel macro?

102: Replace ^ in web query result

103: range.activate

104: ICT Room booking system

105: pivot tables, calculated fields, empty cells and zeros

106: How can I change what is in the "name box" in Excel?

107: Multiple workbook sheet numbers!

108: Macro to compare two list

109: File dialog box

110: Excel - Fill empty cells

111: [Excel XP] Orientation of cells etc.

112: Combo Box Question

113: number of mondays in period

114: Best method to retrieve table data

115: Cell Refrences in Addin

116: Date Function

117: macro to change multiple values in a column

118: negative numbers

119: Combo Box Font

120: Combine Today() with If function

121: Changing the vlookup cell

122: How to create a ListBox with 'hyperlink'-like items in VBA ?

123: Auto Fill Color of a particular Cell if conditions are put

124: Code to Advance filter a list in a shared workbook

125: Mandatory Field in Excel 2002

126: macros code & color based functions help

127: Capitalize first letter when type a name in each cell.

128: to display content of worksheet on a user form in visual basic

129: string

130: How do I combine two Excel Workbooks and delete the duplicate colu

131: Pivot Tables: Omitting Zero Values

132: "Unable to get the Hlookup property" VBA

133: Sumif with multiple criteria with an extra twist

134: Count values in Cells Across

135: UserForm Update on the Fly

136: Iteration performance issue

137: LA User Conference October 25-27, 2006

138: invisible text boxes becoming visible

139: TextBox in UserForm with > 24h time format

140: MACRO TO FIND SUBSTRING OR SUBTEXT !

141: =CONCATENATE(A10,B10,C10)

142: trouble finding object to use

143: Messages posted today not being displayed

144: Lookup or Match and copy Urgent

145: How Close Excel from CMD prompt?

146: Help with External Data Queries

147: combination of functions?

148: VLOOKUP may be?

149: Multilevel Ranges

150: Pivot Table from multiple sheets

151: Sorting Algorithm required!

152: duplicate last name and date of birth

153: Creating a Pivot Table with VBA

154: Copy a single cell to a cell in a range

155: Page numbering

156: Limit No of Colums

157: Scrolling gives me error 424

158: Hiding subtotal groups

159: Data Columns to table

160: Compile error, variable not defined

161: Field Validation for Length & Character Type

162: replace blanks in text with + signs

163: fill series

164: Can someone please help me set boundaries on a worksheet?

165: Help modify this code please

166: Help with a Script File

167: Getting RAND() value but NOT its Function?!?

168: lock / unlock dynamically

169: Macro to check "option button" and "check box"

170: Linking Forms across seperate addins

171: how do I get a spreedsheet to print an 8x11 size

172: On opening a file auto open another

173: pivot table subtotals

174: Excel---how do i automate adding a suffix to text?

175: countif when range to count is in a different workbook

176: lock out menus?

177: Splitting cells - please help!

178: If statement + date calculation

179: two lists of numbers

180: Conditional formatting

181: Pivot Table Programming

182: How do I get my formula to stop rounding up

183: Automatically Display a data input form when active sheet changes

184: Colour Problem in Excel 2002

185: Excel VBA functions

186: Is there a way to have a excel automatically alphabetize a sheet?

187: Can I get the inserted picture's original filename.

188: Excel Send To Options

189: is there a way I can modify the save as dialong box?

190: Excel 2002

191: HELP ME!!!!!

192: For loop...

193: hjf

194: getting ### in text field

195: Formula help!

196: cannot see rows

197: Comment Box

198: Upgrading Add-Ins to Excel 2007 -- Compatibility & Bugs

199: average with mulitple ciriteria

200: Excel 12 Add-In compatibility - registerXLL fails in Office2007

201: Why wont this work!

202: Input Cell

203: HELP: VBA help file

204: How to use a array as the input for a normal formula

205: COUNTIF and VLOOKUP

206: SUMPRODUCT PROBLEM

207: Macro Question - Variable

208: Protect Formatting

209: string function

210: Graph with 3 columns - having problems - help please

211: Maintaining links to cells for database query ranges

212: Character limit on CSV files in excel?

213: Referring to a worksheet in another file.

214: Change Cells into Folders

215: paste table from pdf to excel

216: userform

217: Rounding Dates

218: remove identical data entries

219: Crazy Formula or Macro

220: Datbase check

221: Why is font so small in the autofilter dropdown

222: What IF - formula question

223: Reading Data from the clipboard

224: Cheap Software

225: MVP Published articles

226: Last used row

227: Pop up calendar

228: Select a category from a list that populates related cells

229: defined name ranges

230: How to get rid of GETPIVOTDATA function?

231: Copy and email

232: Office Web Components 11 - Excel 2003

233: macro checking

234: paste macro to a workbook code

235: Number Formatting

236: test please ignore

237: Best way to do this!!

238: Proper Case

239: Timesheet to monitor flexi-time

240: windows installer

241: counting occurances

242: how do i delete just 1 hyperlink in a column of many?

243: Extract rows with specific text in a column

244: Formula to lookup info in a table

245: Using Data Form

246: Conditional formatting formulas

247: Event macro to extract data based on value of 2 cells - help

248: Drop down menu

249: Excel 2002: How to sort row totals in Pivot Table ?

250: Comparing columns

251: Macro to create format painter

252: Formula help

253: Macro question

254: Slow Load Help

255: How to return multiple instances using VLOOKUP

256: veryhidden with xl2000 & xl2003

257: In-cell progress bars?

258: Formula help - indirect & sumif & dates .....

259: number of times

260: Read only in excel

261: recent postings not seen

262: Copying non-contiguos cells.

263: How do I check for duplications in a range of data (excel)?

264: Calendar Control - closing out

265: HOW CAN I BRING MULTIPLES VALUES TO A CELL FROM OTHER SHEET

266: Sound Alarm when time expires

267: I need to link only certain cell...

268: How to create seperator in Right click..?

269: Lock Cells with a Forumlae

270: How do I calculate the statistical measure known as omega?

271: Count if cells have multiple data

272: Replace can't find text

273: Excel Autofill Method of Range Class Failed

274: SaveAs

275: Hidden Text in Fields - MS2003 Student Teacher edition

276: Any utility for joining two or more Excel or CVS files

277: In Pivot Table - can sum be changed to average?

278: Operator for "between"

279: How to write IF function in Excel 2000 when there are two conditi.

280: (reposte X 3) Anyone???? Have I stumped the Excel community?

281: Anyone have ideas on the Public Variant problem I posted about 5 or 8 posts ago

282: Common Data in Add_In

283: if any range on sheet2 change put "a" in sheet1 cell a111

284: Automate compacting database

285: Another Conditional Formatting Question

286: Workbook_BeforeClose problem

287: Sorting Issue (Mixde Fields)

288: how to stop created sheet from linking to another sheet

289: Command

290: Simplifying Excel Recorded Macro Code

291: freezing formulas after calculation

292: Autosaving files with different names

293: Protecting VBA Macros

294: How can I create customized help or instructions?

295: NEED TO CREATE A CONDITIONAL FORMULA

296: Barcode reader - to store data in Excel

297: Creating simplest Excel Hangman

298: How do you change Cell name reference from R[-2]C[-1] back to C2

299: Need small help with excel macro please

300: Pivot Table

301: DSUM function