Page 405

view full version: back to formated view

1: Visual basic Code

2: COM Add-in ?

3: Need to have control of the calculation to specific ranges

4: Delete every row if the cells in first 12 columns are empty

5: Import wizard does not display

6: 3 possible methods for adding value to a combobox

7: Filter by a Date that link to a cell

8: Keep Excel Formula constant

9: lookup using two columns

10: Combine text and formula

11: Pivot Table Group Hours

12: Working with more than 65000 rows in Excel

13: Need function for one value for two criterias and two columns

14: how to create excel file when clicking on the button.

15: SumIf for Variable Conditions

16: Conditional formats- paste special formats?

17: Code for opening Comment box

18: Sumproduct??

19: a cummulative or to-date total based on time and metrics

20: Greg Wilson - XY coordinates of a worksheet

21: Conditional Formatting, copy for rows

22: Call the edit-links dialog box

23: grayed area

24: Basic Rounding Format question

25: RUNNING WINZIP32 FROM EXCEL

26: Help needed for sorting the data and plotting graph

27: Custom Add-in - How to Manage

28: Macro coding needed.

29: I have a quandary with print preview in Excel 2000

30: SelectedItems

31: Joinig

32: How many rows fit a page

33: Dumping the contents of a VBA array to a sheet

34: EXCEL-VBA, ADO not connecting to a TXT file

35: Forms and Modules

36: If Statements - Multiple formulae

37: Check Box

38: How to auto update a spreadsheet with data from a .xls file?

39: Can a conditional formula display it's results on a new row?

40: removing duplicate rows

41: Macro to paste error

42: Posting data from worksheet to webquery ??

43: verify use of TIME Function, Find Quantity Level compare to time-d

44: Copy & PasteSpecial

45: Change event due to Cut & Paste, Drag & Drop or Edit

46: How to send an alert message to other apps?

47: forms

48: Pivot Table Refresh error "Problems Obtaining Data"

49: Converting Date to Beginning of the Month

50: Renaming VBA Modules

51: Filtering for exact text

52: Excel should allow "select all" and also "insert bookmark" as Wor.

53: Auto extend formula down a column

54: Math

55: Update Links Error

56: Add negs, Add positives

57: Color Coding Findings

58: formatting & programming

59: Excel-2003 Plug-In Program

60: Formatting a formula within a cell

61: Excel Free Training Online

62: NETWORKDAYS calculation returns inconsistent results

63: need help on updating figures

64: vlookup - i think

65: Get Cell Address From Lookup (Alternative to Lookup)

66: sort by subtotal values

67: How do I set up an error bar in Excel and a vertical line together

68: Finding a formula...

69: Rounding of Time

70: array data to cells

71: Validation list functionality disappered

72: All Projects Code

73: MODE() is there a way to return bi-modal or multimodal results?

74: End(xlDown) won't work

75: Menu Item on the Excel

76: dates

77: Select Case for Conditional Formatting

78: Counting Variable Length of Rows in a Named Range

79: Help Please

80: Move the cursor to a cell in button click event

81: Dialog Boxes

82: Changing File Location on General Tab

83: move formatted cells

84: CLOSE ALL macro for XL2K (but with prompt to save for each file)?

85: Opening Linked Workbooks from Summary

86: How do you stop the Review toolbar from appearing at start-up

87: userform stopping duplication

88: validation

89: Countif cell has shading

90: salary adjustment due to inflation,,how to ??

91: autosum

92: Jump to duplicat entries

93: Best extractor of rows and columns from a PDF to Excel

94: too many combos

95: Data table around multiple scenarios

96: HOW TO CALCULATE

97: Prevent certain cells from being copied

98: Excel2000: Formatting a range as Text in VBA

99: Duration problem

100: shorter formula / not array?: every other col..

101: Re: I said "Keep this text! Not a date!"

102: COUNTIF Formula problems

103: Can I import data into columns in Excel ?

104: VBA and Excel 2007

105: lookup problem..can you solve!??!

106: DDE Commands

107: BVE

108: can excel change number 1532 to 1235 running order

109: failed XP Pro update locks all Xcel functions

110: How do I convert numbers to words writing checks with Excel?

111: Stepping through For Each...Next backwards?

112: Variable Error

113: Right click menu is missing

114: How do I change the value in cell based on a future date

115: IF OR formula

116: Conflict with Workbooks

117: CheckBox to select pages to print?

118: Using Listbox to specify data in list to enter in textboxs

119: CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL

120: LineTo in Excel

121: Convert Excel 2003 XML file to Excel 97

122: Close workboook if it is open

123: help with sumproduct

124: Opening Excel spreadsheet from Word

125: Conditional Formatting, Formula Help Needed

126: Need Help

127: How can I ignore value from a workbook that are not in my collection?

128: Empty (blank) cell read as zero??

129: Save without prompts

130: Use a lookup with a variable for the workbook name

131: adding columns

132: how to copy only values and formats of worksheets to new workbook

133: another "400" error

134: Searching for Duplicates

135: How can I make a dialogue box pop up with a notice to user?

136: Problem adding a worksheet

137: Drop-down lists

138: Frequency Function

139: Excel Drop Down Lists

140: copying pivot table results to a new sheet.

141: How do you validate listed information with comment?

142: Printing Columns

143: Read .xls File Via C# Without Having Excel Installed

144: disable the windows 'minimize' & 'file exit' buttons

145: Very Minor "Cosmetic" Question

146: search multiple worksheets name with common text and process using

147: I can't find why my formula is inconsistant - please help

148: IF

149: greyed out compare and merge document

150: Sending Excel sheet by Lotus Notes

151: shortcut key help pls

152: Adding note numbers to cells

153: shared workbooks

154: how can i find cells which contain certain text?

155: Count consecutive absences with a limit

156: Loop Code?

157: Time interval worksheet function

158: hiding rows on worksheets

159: Remove File Extensions From a List of Files

160: How do you add "Ctrl+Shift+;" to a button?

161: Analysis ToolPak Translator

162: Excel not refreshing data for User Defined Functions

163: =?Utf-8?Q?Inds=C3=A6tte_diagram_fra_excel_i_wor?=

164: Userform updating

165: make heading stationairy

166: excel will not open

167: making drop downs "volatile"

168: How To Retrieve Data from Sheet2 into Sheet1

169: filling down automactically ?

170: CheckBoxes on MultiPage

171: Macros for Protect/Unprotect all sheets in a workbook

172: MSGBox based on If Statement

173: Formula for searching spreadsheet

174: validating input in textbox

175: Renaming Worksheets

176: Identifying duplicate entries

177: Finding missing numbers in a list

178: Condition Formatting based on due date

179: countif

180: converting continuous data into binary data

181: total Hours Worked for week PS thx for the formulars everyone!

182: Formating output.

183: Date Formatting Problem

184: Formulas dont work

185: Named Range formula questions

186: Matching Cells in different files to sum.

187: need to compare dates and count the results

188: I want to stop the help menu poping up in excel

189: Progress Bar

190: How to get different base systems so letters will show up like hex system tia sal2

191: Stand alone

192: IMAGE OVERLAY

193: locking cells

194: Changing Form Button Background Color

195: Count Unique Entries

196: Excel putting name in opened files

197: Impossible to find error

198: EXCEL help

199: How do I compare similar rows of data in same worksheet

200: Upcoming Support Webcasts

201: "Next Year" function

202: save file as cell value

203: sorting data

204: Pre-pending and post-pending cell data in Excel

205: Moving in multi-sheet document

206: macro error

207: how to use Filter in Macro

208: Cascading macros to new workbooks

209: Need formula for time between two events

210: How to Extract Data from a CSV file???

211: Formatting color and font to a logical statement result?

212: Deleting worksheets

213: help with formula

214: identical macros run fast and slow

215: Clear Contents Of Cells Where Value = 0

216: remembering sort selections

217: subtotals

218: Thank you! Toppers

219: one last macro question

220: How to insert a photo in the background for printing.

221: Error trying to select a cell

222: how to call a function procedure

223: how to display mainframe negative numbers on excel

224: Double variables initialize to zero??

225: Rounding time UP to nearest fourth-hour

226: Cumulative frequency chart question

227: Press the / key and the FILE menu highlights

228: Color

229: Reminder for backup

230: Link transposed data from one sheet to another for DB purposes

231: diagram with 2 values

232: =IF in VBA

233: need to transpose 1422 values from a column to row

234: trying to retrive number combo to = fixed amount

235: Comparing Data between two sheets

236: Underscoring

237: Range in wrong book

238: look up formula?

239: A Pivot Table challenge--I can't do it, can you?

240: Extract a percentage from a text

241: VBA Update to Excel Checkbox

242: Help with macro(saveas)

243: Formula falling over in more than one cell

244: Search Column then Paste Data at end of Row?

245: Formula Help - Time Difference in Days, Hours Mins & Seconds

246: Fiscal Calendar Date Function

247: Name each Worksheet with a name?

248: Email question

249: Is there any API to know that ocx files are registerd in the machine or not

250: Shared Workbook inexplicably grows in size

251: Excel menu dissappears

252: Is this possible?

253: How do I determine if it is a new file or an existing file?

254: Chart - stopping line from plotting when there is no data in cell

255: Adding or Deleteing Rows in a Range with an Array formula

256: Runtime Error 7, Out of Memory

257: (Complex) Loop within loop to create worksheets

258: Return to Original Workbook

259: Count Non-Blanks in one column based on criteria in another

260: Split, sort and mail

261: SUMIF Function

262: Save changes in Excel 97 from file created in 2000

263: Delete names

264: Wrong number entry over 16 digits

265: Replacing workbook with master copy

266: Calculation

267: Pivot table formulas based on text fields

268: instead of formula

269: Excel 2007

270: Autofilter - on select columns

271: Linked Cells on Separate Worksheets

272: Combobox drop down

273: Excel 2000

274: Delete text in a string marco help

275: First occurance greater than or equal to a specified value

276: Cell that is below given coordinates

277: Arrays

278: Is this wrong?

279: How can I name the Module or class after I insert it into the Excel

280: If Cell Includes

281: Formula for calculating # of days between dates minus a particular date if present

282: Copy/Fill cell values in a column

283: How can I update VBA code in a module that is running my VBA code?

284: Is it possible to count the day of Month/Year?

285: Landscape vs Portrait

286: Excel VB Script Not Working in Explorer

287: "Not enough memory"

288: Reference cell address of Hyperlink

289: specify a specific column to input text based on another cell's content

290: Add borders to certain cells using VBA

291: Formulas for Times

292: Work Request Template

293: AVERAGEIF Function out there?

294: disable right mouse click

295: PivotTables Refresh not work

296: Sort and calulate help or maybe even a if statement

297: My formulas return the formula not a result in the cell

298: Problem with comma seperated list

299: How to automate a import from a webpage

300: Macro Help

2: COM Add-in ?

3: Need to have control of the calculation to specific ranges

4: Delete every row if the cells in first 12 columns are empty

5: Import wizard does not display

6: 3 possible methods for adding value to a combobox

7: Filter by a Date that link to a cell

8: Keep Excel Formula constant

9: lookup using two columns

10: Combine text and formula

11: Pivot Table Group Hours

12: Working with more than 65000 rows in Excel

13: Need function for one value for two criterias and two columns

14: how to create excel file when clicking on the button.

15: SumIf for Variable Conditions

16: Conditional formats- paste special formats?

17: Code for opening Comment box

18: Sumproduct??

19: a cummulative or to-date total based on time and metrics

20: Greg Wilson - XY coordinates of a worksheet

21: Conditional Formatting, copy for rows

22: Call the edit-links dialog box

23: grayed area

24: Basic Rounding Format question

25: RUNNING WINZIP32 FROM EXCEL

26: Help needed for sorting the data and plotting graph

27: Custom Add-in - How to Manage

28: Macro coding needed.

29: I have a quandary with print preview in Excel 2000

30: SelectedItems

31: Joinig

32: How many rows fit a page

33: Dumping the contents of a VBA array to a sheet

34: EXCEL-VBA, ADO not connecting to a TXT file

35: Forms and Modules

36: If Statements - Multiple formulae

37: Check Box

38: How to auto update a spreadsheet with data from a .xls file?

39: Can a conditional formula display it's results on a new row?

40: removing duplicate rows

41: Macro to paste error

42: Posting data from worksheet to webquery ??

43: verify use of TIME Function, Find Quantity Level compare to time-d

44: Copy & PasteSpecial

45: Change event due to Cut & Paste, Drag & Drop or Edit

46: How to send an alert message to other apps?

47: forms

48: Pivot Table Refresh error "Problems Obtaining Data"

49: Converting Date to Beginning of the Month

50: Renaming VBA Modules

51: Filtering for exact text

52: Excel should allow "select all" and also "insert bookmark" as Wor.

53: Auto extend formula down a column

54: Math

55: Update Links Error

56: Add negs, Add positives

57: Color Coding Findings

58: formatting & programming

59: Excel-2003 Plug-In Program

60: Formatting a formula within a cell

61: Excel Free Training Online

62: NETWORKDAYS calculation returns inconsistent results

63: need help on updating figures

64: vlookup - i think

65: Get Cell Address From Lookup (Alternative to Lookup)

66: sort by subtotal values

67: How do I set up an error bar in Excel and a vertical line together

68: Finding a formula...

69: Rounding of Time

70: array data to cells

71: Validation list functionality disappered

72: All Projects Code

73: MODE() is there a way to return bi-modal or multimodal results?

74: End(xlDown) won't work

75: Menu Item on the Excel

76: dates

77: Select Case for Conditional Formatting

78: Counting Variable Length of Rows in a Named Range

79: Help Please

80: Move the cursor to a cell in button click event

81: Dialog Boxes

82: Changing File Location on General Tab

83: move formatted cells

84: CLOSE ALL macro for XL2K (but with prompt to save for each file)?

85: Opening Linked Workbooks from Summary

86: How do you stop the Review toolbar from appearing at start-up

87: userform stopping duplication

88: validation

89: Countif cell has shading

90: salary adjustment due to inflation,,how to ??

91: autosum

92: Jump to duplicat entries

93: Best extractor of rows and columns from a PDF to Excel

94: too many combos

95: Data table around multiple scenarios

96: HOW TO CALCULATE

97: Prevent certain cells from being copied

98: Excel2000: Formatting a range as Text in VBA

99: Duration problem

100: shorter formula / not array?: every other col..

101: Re: I said "Keep this text! Not a date!"

102: COUNTIF Formula problems

103: Can I import data into columns in Excel ?

104: VBA and Excel 2007

105: lookup problem..can you solve!??!

106: DDE Commands

107: BVE

108: can excel change number 1532 to 1235 running order

109: failed XP Pro update locks all Xcel functions

110: How do I convert numbers to words writing checks with Excel?

111: Stepping through For Each...Next backwards?

112: Variable Error

113: Right click menu is missing

114: How do I change the value in cell based on a future date

115: IF OR formula

116: Conflict with Workbooks

117: CheckBox to select pages to print?

118: Using Listbox to specify data in list to enter in textboxs

119: CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL

120: LineTo in Excel

121: Convert Excel 2003 XML file to Excel 97

122: Close workboook if it is open

123: help with sumproduct

124: Opening Excel spreadsheet from Word

125: Conditional Formatting, Formula Help Needed

126: Need Help

127: How can I ignore value from a workbook that are not in my collection?

128: Empty (blank) cell read as zero??

129: Save without prompts

130: Use a lookup with a variable for the workbook name

131: adding columns

132: how to copy only values and formats of worksheets to new workbook

133: another "400" error

134: Searching for Duplicates

135: How can I make a dialogue box pop up with a notice to user?

136: Problem adding a worksheet

137: Drop-down lists

138: Frequency Function

139: Excel Drop Down Lists

140: copying pivot table results to a new sheet.

141: How do you validate listed information with comment?

142: Printing Columns

143: Read .xls File Via C# Without Having Excel Installed

144: disable the windows 'minimize' & 'file exit' buttons

145: Very Minor "Cosmetic" Question

146: search multiple worksheets name with common text and process using

147: I can't find why my formula is inconsistant - please help

148: IF

149: greyed out compare and merge document

150: Sending Excel sheet by Lotus Notes

151: shortcut key help pls

152: Adding note numbers to cells

153: shared workbooks

154: how can i find cells which contain certain text?

155: Count consecutive absences with a limit

156: Loop Code?

157: Time interval worksheet function

158: hiding rows on worksheets

159: Remove File Extensions From a List of Files

160: How do you add "Ctrl+Shift+;" to a button?

161: Analysis ToolPak Translator

162: Excel not refreshing data for User Defined Functions

163: =?Utf-8?Q?Inds=C3=A6tte_diagram_fra_excel_i_wor?=

164: Userform updating

165: make heading stationairy

166: excel will not open

167: making drop downs "volatile"

168: How To Retrieve Data from Sheet2 into Sheet1

169: filling down automactically ?

170: CheckBoxes on MultiPage

171: Macros for Protect/Unprotect all sheets in a workbook

172: MSGBox based on If Statement

173: Formula for searching spreadsheet

174: validating input in textbox

175: Renaming Worksheets

176: Identifying duplicate entries

177: Finding missing numbers in a list

178: Condition Formatting based on due date

179: countif

180: converting continuous data into binary data

181: total Hours Worked for week PS thx for the formulars everyone!

182: Formating output.

183: Date Formatting Problem

184: Formulas dont work

185: Named Range formula questions

186: Matching Cells in different files to sum.

187: need to compare dates and count the results

188: I want to stop the help menu poping up in excel

189: Progress Bar

190: How to get different base systems so letters will show up like hex system tia sal2

191: Stand alone

192: IMAGE OVERLAY

193: locking cells

194: Changing Form Button Background Color

195: Count Unique Entries

196: Excel putting name in opened files

197: Impossible to find error

198: EXCEL help

199: How do I compare similar rows of data in same worksheet

200: Upcoming Support Webcasts

201: "Next Year" function

202: save file as cell value

203: sorting data

204: Pre-pending and post-pending cell data in Excel

205: Moving in multi-sheet document

206: macro error

207: how to use Filter in Macro

208: Cascading macros to new workbooks

209: Need formula for time between two events

210: How to Extract Data from a CSV file???

211: Formatting color and font to a logical statement result?

212: Deleting worksheets

213: help with formula

214: identical macros run fast and slow

215: Clear Contents Of Cells Where Value = 0

216: remembering sort selections

217: subtotals

218: Thank you! Toppers

219: one last macro question

220: How to insert a photo in the background for printing.

221: Error trying to select a cell

222: how to call a function procedure

223: how to display mainframe negative numbers on excel

224: Double variables initialize to zero??

225: Rounding time UP to nearest fourth-hour

226: Cumulative frequency chart question

227: Press the / key and the FILE menu highlights

228: Color

229: Reminder for backup

230: Link transposed data from one sheet to another for DB purposes

231: diagram with 2 values

232: =IF in VBA

233: need to transpose 1422 values from a column to row

234: trying to retrive number combo to = fixed amount

235: Comparing Data between two sheets

236: Underscoring

237: Range in wrong book

238: look up formula?

239: A Pivot Table challenge--I can't do it, can you?

240: Extract a percentage from a text

241: VBA Update to Excel Checkbox

242: Help with macro(saveas)

243: Formula falling over in more than one cell

244: Search Column then Paste Data at end of Row?

245: Formula Help - Time Difference in Days, Hours Mins & Seconds

246: Fiscal Calendar Date Function

247: Name each Worksheet with a name?

248: Email question

249: Is there any API to know that ocx files are registerd in the machine or not

250: Shared Workbook inexplicably grows in size

251: Excel menu dissappears

252: Is this possible?

253: How do I determine if it is a new file or an existing file?

254: Chart - stopping line from plotting when there is no data in cell

255: Adding or Deleteing Rows in a Range with an Array formula

256: Runtime Error 7, Out of Memory

257: (Complex) Loop within loop to create worksheets

258: Return to Original Workbook

259: Count Non-Blanks in one column based on criteria in another

260: Split, sort and mail

261: SUMIF Function

262: Save changes in Excel 97 from file created in 2000

263: Delete names

264: Wrong number entry over 16 digits

265: Replacing workbook with master copy

266: Calculation

267: Pivot table formulas based on text fields

268: instead of formula

269: Excel 2007

270: Autofilter - on select columns

271: Linked Cells on Separate Worksheets

272: Combobox drop down

273: Excel 2000

274: Delete text in a string marco help

275: First occurance greater than or equal to a specified value

276: Cell that is below given coordinates

277: Arrays

278: Is this wrong?

279: How can I name the Module or class after I insert it into the Excel

280: If Cell Includes

281: Formula for calculating # of days between dates minus a particular date if present

282: Copy/Fill cell values in a column

283: How can I update VBA code in a module that is running my VBA code?

284: Is it possible to count the day of Month/Year?

285: Landscape vs Portrait

286: Excel VB Script Not Working in Explorer

287: "Not enough memory"

288: Reference cell address of Hyperlink

289: specify a specific column to input text based on another cell's content

290: Add borders to certain cells using VBA

291: Formulas for Times

292: Work Request Template

293: AVERAGEIF Function out there?

294: disable right mouse click

295: PivotTables Refresh not work

296: Sort and calulate help or maybe even a if statement

297: My formulas return the formula not a result in the cell

298: Problem with comma seperated list

299: How to automate a import from a webpage

300: Macro Help