Page 424

view full version: back to formated view

1: Unprotecting the VBProject

2: remove background of a picture in Excel & Power Point

3: Referencing Cells on Different Worksheets

4: Drag and drop Web services in Excel

5: Activex command to Hide/Unhide

6: Decimal to Binary conversion

7: search for Index+average in threads

8: Need help to enter text in Polish language

9: Help please with formula

10: Determing if user input is on list in Combo Box

11: Problem with dates in excel

12: How do I simplify a macro in excel?

13: additional lines from filters

14: count rows that match conditional formatting

15: Sending data in certain cells to another worksheet by pressing a button

16: Disable warning on macros

17: Copy, paste to another sheet

18: Creating new excel docs with links

19: write digit in alphabets in excell sheet

20: Application.GetOpenFilename

21: Open Access form from excel hyperlink

22: Excel calculation of duration in hours and minutes

23: comment has name & is bold

24: saving .prn with more than 240 positions

25: excel expert with data

26: Possible to assign macro defined as private to a form control.

27: Export from Access to Excel

28: Unlock protected worksheet

29: how do you copy the same cell reference on different worksheets

30: Macro moves data and more!!!

31: show value but hide function

32: calculating a weighted average using formula

33: subtract the time difference from another time difference

34: Pasting to Excel sheet (getting desperate!)

35: Changing Save As Type in Save as dialog box

36: Why Comments Displaced to Top of Spreadsheet?

37: #N/A conditional formatting

38: Follow up area under the curve

39: No printing of drop down box

40: Check box formatting

41: Grey out

42: calling a webservice

43: How to record Keystrokes instead of keystroke actions

44: Error I cannot figure out

45: PIA compatability

46: Select cells copy/paste and repeat x times

47: Deleting a File

48: Using autofilter and saving changes

49: SUMPRODUCT vs Arrays

50: Using Excel Macros & Outlook Web Access

51: If any 3 of 5 values are 0 then 0.

52: HTMLElementCollection Dilemna

53: Random Selection of Some Lines in Excel Worksheet

54: Charts

55: Getting "=A1" instead of "4"

56: Using "double equal signs" in place of an IF statement

57: link a checkbox in a sheet to a checkbox on a userform?

58: Worksheet copy with rename

59: Help with Calling a subroutine in the ThisWorkbook Class

60: Want to Bind ADO Dataset to Excel 2003 Pivottable

61: button awareness. i dont know if it can be done.

62: Insert, position, and resize a picture w/ Macro

63: moving cells

64: Additional Help with range of cells

65: calculate hours without negative

66: Fill a ListBox with items using VBA

67: Multiple IF statements

68: VBA crashes Excel

69: Calculating tvl time in Excel 2000 Rev.9.2720

70: I overprotected my spreadsheet! Need help ASAP!!

71: add 1 to a sum by clicking mouse?

72: Using Icons wthin an Excel spreadsheet

73: Help with macro!!

74: create a dropdown list for data input

75: Save File to specific place`

76: Link Merged cell value

77: If stmnt

78: VBA running VERY slow

79: summing the same cell in multiple workbooks

80: Bulk row deletion

81: hours x rate calculation

82: Using Pick Lists

83: Creating a loop

84: Activating a workbook

85: linking workbooks - expert advice needed!

86: populate conditional formating on a spreadsheet via VBA

87: Commas where decimals should be

88: how to program in excel

89: Handling Null Field in Macro Loop

90: data entry problems

91: How do I enter the same data no multiple cells with current data?

92: AppActivate problem when called twice

93: Decimal Dilemma

94: convert excel data to 2-D array using macro

95: Using VBA macros in all workbooks

96: Write a macro

97: Automatically generating a specified number of new rows (records)

98: Fraction in 16ths format reduced to LCD

99: Pre - emptive combo box.....

100: Within Range ? Greater than, etc.

101: look up a value in one column to another colum

102: Index Popup

103: Error on opening and clsoing Excel

104: How to force workbook to always open on the index sheet tab

105: show only the subtotals and grand total in a pivot table

106: Insert function

107: Check if ADO connection open

108: Number Group Seperator

109: Need Excel Function that will return # of char in preceding cell

110: Can a drop-down have multiple selections?

111: Access automation from Excel

112: Possible to relax workbook links??

113: Dynamic formula

114: What is keyboard shortcut equivalent to drag the fill handle

115: Worksheet_Change with discontinuous cells

116: selecting values

117: Interactive Text message

118: Connecting lines

119: Date in Combi Box

120: Copying Excel Screen Shots Into PowerPoint

121: How to change a chart in a shared workbook?

122: defign a function in one workbook and use it in another workbook

123: Anchor button to cell?

124: iif question

125: argh, can't get it to work

126: AsktoUpdateLinks Property

127: Addpolyline function

128: Hiding VBA code

129: corresponding text and numeric cells

130: Excel Addin altering date format on text file import

131: Workbook won't save

132: Adding formulas

133: Rounding on Entry

134: Sharing Workbook Nighmare

135: Sum product problem!! Help!!

136: Copy the URL of the Hyperlink

137: Validation List to fill adjacent cell with IF?

138: help on GPA formulas with null value

139: Vlookup Argument ?

140: Store cell data in a variable

141: Worksheets.add in VBScript overwrites existing worksheet

142: Run macro from command line

143: Can I use a drop down list to navigate to other spreadsheets

144: Use of a Key line

145: Compile Error! Can't find project or Library --- Help!

146: changing value of a list box

147: Excel windows media player links

148: Sumif or Sumproduct

149: how to change number to text with specific format in function

150: Calculations depending on the date aaaaaah!

151: Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?

152: Duplicating Text To Another Spreadsheet

153: can't make a chart from data imported from txt file

154: formula

155: Creating a vehicle running sheet??

156: Set Print Area

157: Make a sheet to enter score and score is copy to the proper cell..

158: Seting the minimum value in a cell

159: MS Query not finding network Access db

160: can a function do this?

161: how to sign Excel 97 AddIn

162: Alternative to multiple IF limits

163: AutoFilter list arrows won't respond

164: code to enter in returns

165: running a macro on several sheets

166: Code to add Formulas with new records

167: Font Size in Drop Down Menus

168: function for counting how many times a Q is answered wrong

169: Application.Run with multiple workbooks

170: Highest Value / Circular Reference Help

171: Excel Filename prgramatically

172: Select Range in VBA relative to another cell

173: Filename Variable?

174: Array as chart series data source

175: remove the border for all series for all charts

176: How do I create a sub function

177: Copy Sheet

178: I have a challenge for all you VBA experts out there!

179: Moving from range to range

180: Checking for the border style of a range

181: unprotect more than one password in macro

182: Excel 2003 in a WEB SERVICE - would like some input :)

183: Advanced Auto Filtering

184: Event proceedures

185: Class not registered error

186: use of mouse track wheel on user form combobox...

187: Help with ROUND

188: Dedupe

189: Is there a Mileage Tracking function?

190: Trim Function... does not work?

191: MROUND and negative/positive numbers

192: how to use VB code to define vlookup in two workbook

193: Cells.Find

194: Unlock Code

195: Percent Format

196: EntireColumn.AutoFit - Slow on Large Files???

197: naming formula

198: Insert Rows

199: Renaming worksheets

200: What relative row I'm in?

201: compaibility issues with tab-delimited files

202: run an exe file as a screensaver in excel

203: Strange Excel Problem need help with..

204: Tricky Conditional Count

205: Complex IF

206: HOw do you save a file using a macro?

207: Formulas language issues

208: Excel Personal settings/macros

209: Array formula on INDEX function not working

210: Create Access like report in Excel.

211: Zip codes that begin with a zero...

212: Where can I see VBA code for financial functions?

213: IF not working

214: Vlookup for multiple row data

215: Summarising data in multiple sheets

216: Compare 2 sheet and insert result into other

217: Single Quote

218: merging cells/data using a Macro

219: Passing array of strings to excel

220: Nested IF Formula Evaluation Pls

221: How do I assign a formula to an entire column?

222: Auto cell move

223: Can't launch Excel

224: Aquiring Directory names

225: VLOOKUP weirdness

226: Cubesets

227: copy paste values only using destination:=

228: Waiting for app to complete OLE action

229: Formatted query

230: Excel to input fields into a Word Form

231: number formatting/separators

232: Importing to Excel from an Outlook Form

233: Try this patch

234: Deleting rows with specific text with a macro

235: sheet tab order

236: Microsoft ProgressBar Control Version 6

237: Remove '

238: turn off scientific notation

239: Help on xl* and mso* Help ?

240: Reset Security Level with VBA?

241: Check Input, into Input box question

242: Runtime Error 1004 on selecting range

243: Web Query running in backg. -how to know when data retrieval compl

244: Multiple cell reference IF function

245: Parameter query with total

246: Help with dynamic sum formula

247: backing up

248: Lookup formula

249: alternate headers and footers

250: I need a macro to delete unwanted data

251: Re: Simple If Function Question

252: subpie from pie

253: Excel spreadsheet sending email based on cell formula

254: Changing several cells text color

255: Sending Excel file as attachment to Lotus Notes mail

256: Please help

257: use more than 4 condition in cf without using macro

258: sum/division calculation involving vlookup with array?

259: OPEN A FILE

260: Sumproduct() - Next best alternative

261: Macro inserting quotes "" in a cell

262: Printing Row number and Formula in Excel Worksheet

263: Creating a macro that reformats data in excel

264: Trap New File name before saving

265: Column width and pasting sections in excel? Formatting questions

266: Backing up work folder

267: How do I get time elapsed in terms of minute?

268: Prove the patch that comes from the MS

269: Help with scrubing two list of names

270: Open files...

271: Office 2003 integration - Great Plains

272: merged cells

273: Extract the value from a cell, and add it to a chart title

274: Auto Adjust the Width of a Column

275: Simply DLL in VB.NET and using it in VBA

276: Macro to change row number within formula

277: cells in a diagonal range

278: Complex User Input Box

279: Conditional format -blank

280: Ytd Calculation In Pivot

281: calculating speeds in mph

282: Replace text

283: Easy Question

284: Environment Variable

285: Cell Formats

286: What is the simplest way to do addtion of cells on reports.

287: proportionally fill a cell

288: How to Count values inside a cell when refered elsewhere?

289: Saving .csv files in Excel 2003

290: match, lookup ???

291: vlookup and validating data list

292: Columns and Rows Values

293: Why doesn't ths VBA Code work?

294: How can I Delete rows were the first cell is blank?

295: SaveCopyAs

296: sort subtotals?

297: Need help with loop to import data

298: Need help using VBA in excel.

299: moving average

300: Analysis of 2 groups?

301: row counter tool for excel 2003

2: remove background of a picture in Excel & Power Point

3: Referencing Cells on Different Worksheets

4: Drag and drop Web services in Excel

5: Activex command to Hide/Unhide

6: Decimal to Binary conversion

7: search for Index+average in threads

8: Need help to enter text in Polish language

9: Help please with formula

10: Determing if user input is on list in Combo Box

11: Problem with dates in excel

12: How do I simplify a macro in excel?

13: additional lines from filters

14: count rows that match conditional formatting

15: Sending data in certain cells to another worksheet by pressing a button

16: Disable warning on macros

17: Copy, paste to another sheet

18: Creating new excel docs with links

19: write digit in alphabets in excell sheet

20: Application.GetOpenFilename

21: Open Access form from excel hyperlink

22: Excel calculation of duration in hours and minutes

23: comment has name & is bold

24: saving .prn with more than 240 positions

25: excel expert with data

26: Possible to assign macro defined as private to a form control.

27: Export from Access to Excel

28: Unlock protected worksheet

29: how do you copy the same cell reference on different worksheets

30: Macro moves data and more!!!

31: show value but hide function

32: calculating a weighted average using formula

33: subtract the time difference from another time difference

34: Pasting to Excel sheet (getting desperate!)

35: Changing Save As Type in Save as dialog box

36: Why Comments Displaced to Top of Spreadsheet?

37: #N/A conditional formatting

38: Follow up area under the curve

39: No printing of drop down box

40: Check box formatting

41: Grey out

42: calling a webservice

43: How to record Keystrokes instead of keystroke actions

44: Error I cannot figure out

45: PIA compatability

46: Select cells copy/paste and repeat x times

47: Deleting a File

48: Using autofilter and saving changes

49: SUMPRODUCT vs Arrays

50: Using Excel Macros & Outlook Web Access

51: If any 3 of 5 values are 0 then 0.

52: HTMLElementCollection Dilemna

53: Random Selection of Some Lines in Excel Worksheet

54: Charts

55: Getting "=A1" instead of "4"

56: Using "double equal signs" in place of an IF statement

57: link a checkbox in a sheet to a checkbox on a userform?

58: Worksheet copy with rename

59: Help with Calling a subroutine in the ThisWorkbook Class

60: Want to Bind ADO Dataset to Excel 2003 Pivottable

61: button awareness. i dont know if it can be done.

62: Insert, position, and resize a picture w/ Macro

63: moving cells

64: Additional Help with range of cells

65: calculate hours without negative

66: Fill a ListBox with items using VBA

67: Multiple IF statements

68: VBA crashes Excel

69: Calculating tvl time in Excel 2000 Rev.9.2720

70: I overprotected my spreadsheet! Need help ASAP!!

71: add 1 to a sum by clicking mouse?

72: Using Icons wthin an Excel spreadsheet

73: Help with macro!!

74: create a dropdown list for data input

75: Save File to specific place`

76: Link Merged cell value

77: If stmnt

78: VBA running VERY slow

79: summing the same cell in multiple workbooks

80: Bulk row deletion

81: hours x rate calculation

82: Using Pick Lists

83: Creating a loop

84: Activating a workbook

85: linking workbooks - expert advice needed!

86: populate conditional formating on a spreadsheet via VBA

87: Commas where decimals should be

88: how to program in excel

89: Handling Null Field in Macro Loop

90: data entry problems

91: How do I enter the same data no multiple cells with current data?

92: AppActivate problem when called twice

93: Decimal Dilemma

94: convert excel data to 2-D array using macro

95: Using VBA macros in all workbooks

96: Write a macro

97: Automatically generating a specified number of new rows (records)

98: Fraction in 16ths format reduced to LCD

99: Pre - emptive combo box.....

100: Within Range ? Greater than, etc.

101: look up a value in one column to another colum

102: Index Popup

103: Error on opening and clsoing Excel

104: How to force workbook to always open on the index sheet tab

105: show only the subtotals and grand total in a pivot table

106: Insert function

107: Check if ADO connection open

108: Number Group Seperator

109: Need Excel Function that will return # of char in preceding cell

110: Can a drop-down have multiple selections?

111: Access automation from Excel

112: Possible to relax workbook links??

113: Dynamic formula

114: What is keyboard shortcut equivalent to drag the fill handle

115: Worksheet_Change with discontinuous cells

116: selecting values

117: Interactive Text message

118: Connecting lines

119: Date in Combi Box

120: Copying Excel Screen Shots Into PowerPoint

121: How to change a chart in a shared workbook?

122: defign a function in one workbook and use it in another workbook

123: Anchor button to cell?

124: iif question

125: argh, can't get it to work

126: AsktoUpdateLinks Property

127: Addpolyline function

128: Hiding VBA code

129: corresponding text and numeric cells

130: Excel Addin altering date format on text file import

131: Workbook won't save

132: Adding formulas

133: Rounding on Entry

134: Sharing Workbook Nighmare

135: Sum product problem!! Help!!

136: Copy the URL of the Hyperlink

137: Validation List to fill adjacent cell with IF?

138: help on GPA formulas with null value

139: Vlookup Argument ?

140: Store cell data in a variable

141: Worksheets.add in VBScript overwrites existing worksheet

142: Run macro from command line

143: Can I use a drop down list to navigate to other spreadsheets

144: Use of a Key line

145: Compile Error! Can't find project or Library --- Help!

146: changing value of a list box

147: Excel windows media player links

148: Sumif or Sumproduct

149: how to change number to text with specific format in function

150: Calculations depending on the date aaaaaah!

151: Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?

152: Duplicating Text To Another Spreadsheet

153: can't make a chart from data imported from txt file

154: formula

155: Creating a vehicle running sheet??

156: Set Print Area

157: Make a sheet to enter score and score is copy to the proper cell..

158: Seting the minimum value in a cell

159: MS Query not finding network Access db

160: can a function do this?

161: how to sign Excel 97 AddIn

162: Alternative to multiple IF limits

163: AutoFilter list arrows won't respond

164: code to enter in returns

165: running a macro on several sheets

166: Code to add Formulas with new records

167: Font Size in Drop Down Menus

168: function for counting how many times a Q is answered wrong

169: Application.Run with multiple workbooks

170: Highest Value / Circular Reference Help

171: Excel Filename prgramatically

172: Select Range in VBA relative to another cell

173: Filename Variable?

174: Array as chart series data source

175: remove the border for all series for all charts

176: How do I create a sub function

177: Copy Sheet

178: I have a challenge for all you VBA experts out there!

179: Moving from range to range

180: Checking for the border style of a range

181: unprotect more than one password in macro

182: Excel 2003 in a WEB SERVICE - would like some input :)

183: Advanced Auto Filtering

184: Event proceedures

185: Class not registered error

186: use of mouse track wheel on user form combobox...

187: Help with ROUND

188: Dedupe

189: Is there a Mileage Tracking function?

190: Trim Function... does not work?

191: MROUND and negative/positive numbers

192: how to use VB code to define vlookup in two workbook

193: Cells.Find

194: Unlock Code

195: Percent Format

196: EntireColumn.AutoFit - Slow on Large Files???

197: naming formula

198: Insert Rows

199: Renaming worksheets

200: What relative row I'm in?

201: compaibility issues with tab-delimited files

202: run an exe file as a screensaver in excel

203: Strange Excel Problem need help with..

204: Tricky Conditional Count

205: Complex IF

206: HOw do you save a file using a macro?

207: Formulas language issues

208: Excel Personal settings/macros

209: Array formula on INDEX function not working

210: Create Access like report in Excel.

211: Zip codes that begin with a zero...

212: Where can I see VBA code for financial functions?

213: IF not working

214: Vlookup for multiple row data

215: Summarising data in multiple sheets

216: Compare 2 sheet and insert result into other

217: Single Quote

218: merging cells/data using a Macro

219: Passing array of strings to excel

220: Nested IF Formula Evaluation Pls

221: How do I assign a formula to an entire column?

222: Auto cell move

223: Can't launch Excel

224: Aquiring Directory names

225: VLOOKUP weirdness

226: Cubesets

227: copy paste values only using destination:=

228: Waiting for app to complete OLE action

229: Formatted query

230: Excel to input fields into a Word Form

231: number formatting/separators

232: Importing to Excel from an Outlook Form

233: Try this patch

234: Deleting rows with specific text with a macro

235: sheet tab order

236: Microsoft ProgressBar Control Version 6

237: Remove '

238: turn off scientific notation

239: Help on xl* and mso* Help ?

240: Reset Security Level with VBA?

241: Check Input, into Input box question

242: Runtime Error 1004 on selecting range

243: Web Query running in backg. -how to know when data retrieval compl

244: Multiple cell reference IF function

245: Parameter query with total

246: Help with dynamic sum formula

247: backing up

248: Lookup formula

249: alternate headers and footers

250: I need a macro to delete unwanted data

251: Re: Simple If Function Question

252: subpie from pie

253: Excel spreadsheet sending email based on cell formula

254: Changing several cells text color

255: Sending Excel file as attachment to Lotus Notes mail

256: Please help

257: use more than 4 condition in cf without using macro

258: sum/division calculation involving vlookup with array?

259: OPEN A FILE

260: Sumproduct() - Next best alternative

261: Macro inserting quotes "" in a cell

262: Printing Row number and Formula in Excel Worksheet

263: Creating a macro that reformats data in excel

264: Trap New File name before saving

265: Column width and pasting sections in excel? Formatting questions

266: Backing up work folder

267: How do I get time elapsed in terms of minute?

268: Prove the patch that comes from the MS

269: Help with scrubing two list of names

270: Open files...

271: Office 2003 integration - Great Plains

272: merged cells

273: Extract the value from a cell, and add it to a chart title

274: Auto Adjust the Width of a Column

275: Simply DLL in VB.NET and using it in VBA

276: Macro to change row number within formula

277: cells in a diagonal range

278: Complex User Input Box

279: Conditional format -blank

280: Ytd Calculation In Pivot

281: calculating speeds in mph

282: Replace text

283: Easy Question

284: Environment Variable

285: Cell Formats

286: What is the simplest way to do addtion of cells on reports.

287: proportionally fill a cell

288: How to Count values inside a cell when refered elsewhere?

289: Saving .csv files in Excel 2003

290: match, lookup ???

291: vlookup and validating data list

292: Columns and Rows Values

293: Why doesn't ths VBA Code work?

294: How can I Delete rows were the first cell is blank?

295: SaveCopyAs

296: sort subtotals?

297: Need help with loop to import data

298: Need help using VBA in excel.

299: moving average

300: Analysis of 2 groups?

301: row counter tool for excel 2003