Page 328

view full version: back to formated view

1: shorten connection time <<Macro Tweak needed>>

2: Help.. Add an event to a sheet module

3: seperating a group of common cells

4: Excel Format Cell - first letter upper case

5: 2 separate passwords (both valid) to open file

6: Searching a text and filling a cell with the result

7: Formatting cells based on the data they contain.

8: Code to ignore on-screen message concerning "Enable Macros."

9: Picture behind cell contents

10: shapes

11: Array or Pivot Tables???

12: Control on worksheet to display 2 col's of data

13: Changing PivotTable source

14: INSERT ROWS

15: Delete Macro

16: Macro to summarize data

17: Substitute for Dragging

18: Sorting a sheet

19: Repeating a sort

20: ElseIf Statement problem

21: Vlookup if #N/A then enter enter data in cell I4

22: Excel 2002 Automatic Macros

23: Please help a Stinkin' Rookie get started!?!!

24: rewrite sheet with some saved values

25: Find & Replace

26: INSTERING A ROW

27: export XLS to CSV with particular delimiter

28: Changing % to whole numbers

29: how to? set my range= my UDF argument (range vs. value in range) [advanced?]

30: adding ranges

31: SUMIF with AND

32: How do I count in column A when it meets all criteria in three col

33: Run only part of a macro for testing

34: Using VSTools for Addin-Programming

35: Select sheet

36: Remove all borders from a range

37: delete data from excel without openning it

38: Extracting word from phrase within column

39: prevent overtyping cells

40: Button disable

41: How to turn on Shapes conditionally?

42: Improving Excel Stability

43: Help with activex listbox control

44: new user of excel

45: "document not saved"

46: VBA Code works in Excel 2003 but won't work in Excel 2000

47: Excel rows into columns

48: Conditional Formatting with Percents

49: Validation of Postal Code

50: Calculating return for multiple separate time periods

51: Play and stop sound

52: Excel frustrates me

53: calculate number of months from date entry

54: Sharing variable values between open workbooks?

55: Worksheet is not updated

56: Help with "IF" Formula

57: setting a range not working, please help

58: Hyperlink problem

59: Deleting Range using VB

60: Code-signing certificate problems in Excel 2000 with Windows 2000

61: Eliminate flickering

62: Charts/Graphs/Printing

63: Pivot tables-multiple payments

64: Creating a Master List from sub-lists

65: File transfer

66: VBA Books - Detailed

67: Calculate Once

68: RichTexBox1_KeyDown Event Not Working

69: Need a macro to compare values in a workbook

70: index or filter?

71: Clarification on "Application.Worbooks.Count" proceedure

72: Cut and paste by reference

73: E-Mail using BCC Fields

74: how can i recover an old saved spreadsheet

75: how to subtract a range from another?

76: Custom exel functions

77: Size of Report Mysteriously Increasing Daily

78: Date entry and format changing?

79: multiplication of a blank cell

80: Validation Formula

81: calling modules

82: MACRO TO SAVE & EXIT ALL WORKSHEET/WORKBOOKS

83: Finding whether a date falls between a certain category

84: Still trying to find the "MAX"

85: INT, MOD help

86: not urgent

87: R/T error 1004 - App-defin or obj defin error on last presented li

88: How to store Range for "home-made" Undo Function?

89: How to get the time stamp in VBA for EXCEL

90: NEED HELP - I want last line of the sheet to go down automatically

91: Conditional Format Cells containing formula

92: Setting up hashtable class module - tools procedure attributes dialog

93: example if IF(ISNA()) function

94: How to remove spaces in a cell

95: creating list

96: Determine last row in columns 1-4 to copy a formula in column 5

97: date formula

98: Conditional formatting does not work with MATCH / VLOOKUP

99: AutoFilter Unavailable?

100: Help: How do I create a column of fixed width data?

101: Last days for Early Bird Registration - Excel User Conference

102: Conditional formating

103: How to determine the value?

104: how do you flip a table around?

105: working with images

106: Graph Ranges

107: Bug? AutoShape position properties incorrect

108: Merge & Center

109: macros in pivot table

110: Creating formulas

111: how to combine formulas to.........

112: Re: Problem in ODBC Query

113: Conditional format oddity in Excel 2007

114: Changes made to toolbars disapear when admin rights are removed from users computers

115: Two Instances of Workbook

116: With End With question

117: Password on a sheet

118: Comparing two dates in one column

119: COUNT function... I think!

120: What function to determine the second small integer from a list?

121: copy cells to a comment

122: =DSUM(DIVOH,$CX$1,$DG$2:$DG$20)

123: Is it possible to choose a macro based upon a valve of a variable??

124: Multi-conditional count

125: OnTime

126: xvalues and null series

127: Set cell background based on date.

128: Test if ActiveCell is within a certain named range

129: Formula Help

130: Reading Excel Spreadsheets in VB.NET unattended

131: Column Comparison Trouble

132: Moving cells

133: Redim 2D Array Subscript Out Of Range Error

134: Limit characters

135: When to add the + sign in =+A2 instead of =A2 formula in Excel?

136: how can I trap the change event (Tab Press key) of these controls

137: Navigating with a macro

138: how to remove first record from a text file

139: Help with activating previous sheet

140: dave or someone, quick question

141: scrollbars in userforms

142: ROI formula

143: Copying in data from text files

144: Dynamic Cell References

145: Finding data by dates

146: Does anyone know how to do this?

147: Big Help

148: do not increment variables in excel

149: find a cell with a character

150: Runtime 28 - Out of stack space

151: Calculating number of days

152: Excell 2000

153: Can you change the function of the fill handle on a cell in Excel

154: Open Files Macro

155: checkboxes and cell-link references...is there a better way

156: Not excel, but try anyway

157: Can not set Y Values in XY chart

158: Array Formula

159: Adding a Range

160: merging text without using a formula

161: Sumif between values

162: sumif formula doesn't add up

163: Auto-fill

164: Datum

165: Update Access with a range from Excel,

166: Percentage Cal

167: How do I enter a date before 1900 in excel?

168: Message box if cell is greater than less than 0

169: sorting issue

170: Printing Comments

171: Macro to use find command

172: Can't open .xlsx file in excel 2007

173: Help with Formula-VLOOKUP Maybe????

174: Function written in VBA not recognized

175: protecting the workbook through a macro

176: REF errors when opening excel in xp. works fine when opening wor.

177: Excel 2000 VBA Question

178: Wav Warning Upon Attempt to Close Userform

179: Loop through a range

180: SKU011.cab

181: Scatter chart

182: how do i change a formula to its value

183: Updating Charts - Excel 2003

184: How do I create a template to fill in government forms?

185: Spreadsheet is being cut off

186: algebraic formula to calculate "net uniform series" (NUS)

187: Displaying form on startup?

188: time format

189: Conditional selection of two column, csv file

190: create an excel formula with contitions

191: Problem with Page Layout

192: Fast Export

193: Excel X for MacOS X

194: Function in objects.

195: editing liked cells

196: edit the build in headers and footers

197: Error in this code.

198: Poor performance in summing up values on another worksheet

199: More Worksheet and Copy Pase help

200: Excel: how do I set page3 to be locked until page 1, 2 are solved

201: Cut and Paste Macro to new file

202: seperating data

203: Block inser or delete rows

204: Excel 2000--printing borders

205: SQL Info

206: help with an average formula

207: How do I work on data starting to a cell a cell with a required va

208: refresh worksheet code

209: Help with "broken" formula!

210: $ dollar signs causing issues in Excel VBA - HTML

211: =WEEKNUM function

212: RANK function

213: Shade Columns based on criteria in cell.

214: Problem with Checkboxes... Help Required!!!

215: Number repeated in an array

216: Can I establish a link based on a date?

217: linking cells

218: Use this patch which comes from the MS Corporation

219: How to set a variable in Excel and loop

220: Capturing cell address and contents

221: Can I email my colleagues automatically when i update a workbook?

222: Limitation on MID function? - very large string

223: Prompt to calculate the date formula

224: Help! PRobelms with TODAY()?!

225: Match and Copy

226: Formatting numbers in a text box

227: Cell range expand or contract

228: Conditional formating

229: WATERMARK WITHIN EXCEL

230: Three graph into one

231: ###### in Excel Column

232: HELP how can I do this PLEASE!!!!!!!!!!!

233: Add Dynamic Array to List Box

234: I can't figure this out - please help

235: OWC - Excel Formatting

236: bahttext

237: how do I expand collapsed rows in excel

238: Print Area

239: Forecasting with formulas HELP

240: Notes

241: formulas populating dates - 1st Tuesday

242: how do I make a cell flash

243: Using a collection class to implement mutliple find/replace strings in cells

244: How to check a range of cells is empty?

245: Error approching SQL server with DAO?

246: Calling a worksheet via a codename

247: How to dates column with values in next column

248: Combining references

249: Dick K - Move e-mail to different folder

250: How to run Macro functionality for a protected worksheet

251: round

252: Totaling Hours in Standard Format

253: Accumulating data

254: How do I restore my menu and tool bars in Excell?

255: filtered data

256: Opening files with a template

257: MSQuery question

258: Running Macro in Minimized Excel Window

259: Match data to find intersection

260: Numbers

261: adodb.recordset with excel

262: Concatenate different ranges

263: UNIQUE

264: how to use linest to get the result as ARRAY?

265: How do I use Excel to create labels?

266: Combo Box Fonts

267: Conitional copying of a serie of rows from one spreadsheet to another

268: vlookup in reverse

269: Variable File Name

270: VBA issue, debug

271: Help - How to check if value exists in closed workbook?

272: Excel Locks up at end of Sub

273: Excel - Summing common cell over mutiple sheets within a file?

274: COUNTIF WITH NAME A RANGE OF INFORMATION

275: Date + one year

276: Opening Different Programs using Excel.

277: Adding spaces into a variable

278: Sum on multiple columns

279: 20 minutes trying...

280: How to Reduce Spreadsheet Size and Speed

281: remove view format

282: Create Outlook Distribution lists in Excel VBA

283: Reregister Com Add-ins via vbs

284: If I have two reoated data-sets and a common code, how can I get i

285: Alter mask of image on button

286: macro abouut solver

287: vB code to analyse list

288: Sum range in Excel

289: Copying a calculations answer and not the calculation

290: Combo box hyperlink navigation

291: Multiple selections in Listbox

292: Loop through range and open files

293: Unwanted quotes in Unicode.txt saves

294: COUNT Function

295: Sort a list across collumns

296: Printing a Listbox

297: conditional formatting and insert cell

298: pop up

299: Lookup functions

300: Conditional Count 2 Columns

2: Help.. Add an event to a sheet module

3: seperating a group of common cells

4: Excel Format Cell - first letter upper case

5: 2 separate passwords (both valid) to open file

6: Searching a text and filling a cell with the result

7: Formatting cells based on the data they contain.

8: Code to ignore on-screen message concerning "Enable Macros."

9: Picture behind cell contents

10: shapes

11: Array or Pivot Tables???

12: Control on worksheet to display 2 col's of data

13: Changing PivotTable source

14: INSERT ROWS

15: Delete Macro

16: Macro to summarize data

17: Substitute for Dragging

18: Sorting a sheet

19: Repeating a sort

20: ElseIf Statement problem

21: Vlookup if #N/A then enter enter data in cell I4

22: Excel 2002 Automatic Macros

23: Please help a Stinkin' Rookie get started!?!!

24: rewrite sheet with some saved values

25: Find & Replace

26: INSTERING A ROW

27: export XLS to CSV with particular delimiter

28: Changing % to whole numbers

29: how to? set my range= my UDF argument (range vs. value in range) [advanced?]

30: adding ranges

31: SUMIF with AND

32: How do I count in column A when it meets all criteria in three col

33: Run only part of a macro for testing

34: Using VSTools for Addin-Programming

35: Select sheet

36: Remove all borders from a range

37: delete data from excel without openning it

38: Extracting word from phrase within column

39: prevent overtyping cells

40: Button disable

41: How to turn on Shapes conditionally?

42: Improving Excel Stability

43: Help with activex listbox control

44: new user of excel

45: "document not saved"

46: VBA Code works in Excel 2003 but won't work in Excel 2000

47: Excel rows into columns

48: Conditional Formatting with Percents

49: Validation of Postal Code

50: Calculating return for multiple separate time periods

51: Play and stop sound

52: Excel frustrates me

53: calculate number of months from date entry

54: Sharing variable values between open workbooks?

55: Worksheet is not updated

56: Help with "IF" Formula

57: setting a range not working, please help

58: Hyperlink problem

59: Deleting Range using VB

60: Code-signing certificate problems in Excel 2000 with Windows 2000

61: Eliminate flickering

62: Charts/Graphs/Printing

63: Pivot tables-multiple payments

64: Creating a Master List from sub-lists

65: File transfer

66: VBA Books - Detailed

67: Calculate Once

68: RichTexBox1_KeyDown Event Not Working

69: Need a macro to compare values in a workbook

70: index or filter?

71: Clarification on "Application.Worbooks.Count" proceedure

72: Cut and paste by reference

73: E-Mail using BCC Fields

74: how can i recover an old saved spreadsheet

75: how to subtract a range from another?

76: Custom exel functions

77: Size of Report Mysteriously Increasing Daily

78: Date entry and format changing?

79: multiplication of a blank cell

80: Validation Formula

81: calling modules

82: MACRO TO SAVE & EXIT ALL WORKSHEET/WORKBOOKS

83: Finding whether a date falls between a certain category

84: Still trying to find the "MAX"

85: INT, MOD help

86: not urgent

87: R/T error 1004 - App-defin or obj defin error on last presented li

88: How to store Range for "home-made" Undo Function?

89: How to get the time stamp in VBA for EXCEL

90: NEED HELP - I want last line of the sheet to go down automatically

91: Conditional Format Cells containing formula

92: Setting up hashtable class module - tools procedure attributes dialog

93: example if IF(ISNA()) function

94: How to remove spaces in a cell

95: creating list

96: Determine last row in columns 1-4 to copy a formula in column 5

97: date formula

98: Conditional formatting does not work with MATCH / VLOOKUP

99: AutoFilter Unavailable?

100: Help: How do I create a column of fixed width data?

101: Last days for Early Bird Registration - Excel User Conference

102: Conditional formating

103: How to determine the value?

104: how do you flip a table around?

105: working with images

106: Graph Ranges

107: Bug? AutoShape position properties incorrect

108: Merge & Center

109: macros in pivot table

110: Creating formulas

111: how to combine formulas to.........

112: Re: Problem in ODBC Query

113: Conditional format oddity in Excel 2007

114: Changes made to toolbars disapear when admin rights are removed from users computers

115: Two Instances of Workbook

116: With End With question

117: Password on a sheet

118: Comparing two dates in one column

119: COUNT function... I think!

120: What function to determine the second small integer from a list?

121: copy cells to a comment

122: =DSUM(DIVOH,$CX$1,$DG$2:$DG$20)

123: Is it possible to choose a macro based upon a valve of a variable??

124: Multi-conditional count

125: OnTime

126: xvalues and null series

127: Set cell background based on date.

128: Test if ActiveCell is within a certain named range

129: Formula Help

130: Reading Excel Spreadsheets in VB.NET unattended

131: Column Comparison Trouble

132: Moving cells

133: Redim 2D Array Subscript Out Of Range Error

134: Limit characters

135: When to add the + sign in =+A2 instead of =A2 formula in Excel?

136: how can I trap the change event (Tab Press key) of these controls

137: Navigating with a macro

138: how to remove first record from a text file

139: Help with activating previous sheet

140: dave or someone, quick question

141: scrollbars in userforms

142: ROI formula

143: Copying in data from text files

144: Dynamic Cell References

145: Finding data by dates

146: Does anyone know how to do this?

147: Big Help

148: do not increment variables in excel

149: find a cell with a character

150: Runtime 28 - Out of stack space

151: Calculating number of days

152: Excell 2000

153: Can you change the function of the fill handle on a cell in Excel

154: Open Files Macro

155: checkboxes and cell-link references...is there a better way

156: Not excel, but try anyway

157: Can not set Y Values in XY chart

158: Array Formula

159: Adding a Range

160: merging text without using a formula

161: Sumif between values

162: sumif formula doesn't add up

163: Auto-fill

164: Datum

165: Update Access with a range from Excel,

166: Percentage Cal

167: How do I enter a date before 1900 in excel?

168: Message box if cell is greater than less than 0

169: sorting issue

170: Printing Comments

171: Macro to use find command

172: Can't open .xlsx file in excel 2007

173: Help with Formula-VLOOKUP Maybe????

174: Function written in VBA not recognized

175: protecting the workbook through a macro

176: REF errors when opening excel in xp. works fine when opening wor.

177: Excel 2000 VBA Question

178: Wav Warning Upon Attempt to Close Userform

179: Loop through a range

180: SKU011.cab

181: Scatter chart

182: how do i change a formula to its value

183: Updating Charts - Excel 2003

184: How do I create a template to fill in government forms?

185: Spreadsheet is being cut off

186: algebraic formula to calculate "net uniform series" (NUS)

187: Displaying form on startup?

188: time format

189: Conditional selection of two column, csv file

190: create an excel formula with contitions

191: Problem with Page Layout

192: Fast Export

193: Excel X for MacOS X

194: Function in objects.

195: editing liked cells

196: edit the build in headers and footers

197: Error in this code.

198: Poor performance in summing up values on another worksheet

199: More Worksheet and Copy Pase help

200: Excel: how do I set page3 to be locked until page 1, 2 are solved

201: Cut and Paste Macro to new file

202: seperating data

203: Block inser or delete rows

204: Excel 2000--printing borders

205: SQL Info

206: help with an average formula

207: How do I work on data starting to a cell a cell with a required va

208: refresh worksheet code

209: Help with "broken" formula!

210: $ dollar signs causing issues in Excel VBA - HTML

211: =WEEKNUM function

212: RANK function

213: Shade Columns based on criteria in cell.

214: Problem with Checkboxes... Help Required!!!

215: Number repeated in an array

216: Can I establish a link based on a date?

217: linking cells

218: Use this patch which comes from the MS Corporation

219: How to set a variable in Excel and loop

220: Capturing cell address and contents

221: Can I email my colleagues automatically when i update a workbook?

222: Limitation on MID function? - very large string

223: Prompt to calculate the date formula

224: Help! PRobelms with TODAY()?!

225: Match and Copy

226: Formatting numbers in a text box

227: Cell range expand or contract

228: Conditional formating

229: WATERMARK WITHIN EXCEL

230: Three graph into one

231: ###### in Excel Column

232: HELP how can I do this PLEASE!!!!!!!!!!!

233: Add Dynamic Array to List Box

234: I can't figure this out - please help

235: OWC - Excel Formatting

236: bahttext

237: how do I expand collapsed rows in excel

238: Print Area

239: Forecasting with formulas HELP

240: Notes

241: formulas populating dates - 1st Tuesday

242: how do I make a cell flash

243: Using a collection class to implement mutliple find/replace strings in cells

244: How to check a range of cells is empty?

245: Error approching SQL server with DAO?

246: Calling a worksheet via a codename

247: How to dates column with values in next column

248: Combining references

249: Dick K - Move e-mail to different folder

250: How to run Macro functionality for a protected worksheet

251: round

252: Totaling Hours in Standard Format

253: Accumulating data

254: How do I restore my menu and tool bars in Excell?

255: filtered data

256: Opening files with a template

257: MSQuery question

258: Running Macro in Minimized Excel Window

259: Match data to find intersection

260: Numbers

261: adodb.recordset with excel

262: Concatenate different ranges

263: UNIQUE

264: how to use linest to get the result as ARRAY?

265: How do I use Excel to create labels?

266: Combo Box Fonts

267: Conitional copying of a serie of rows from one spreadsheet to another

268: vlookup in reverse

269: Variable File Name

270: VBA issue, debug

271: Help - How to check if value exists in closed workbook?

272: Excel Locks up at end of Sub

273: Excel - Summing common cell over mutiple sheets within a file?

274: COUNTIF WITH NAME A RANGE OF INFORMATION

275: Date + one year

276: Opening Different Programs using Excel.

277: Adding spaces into a variable

278: Sum on multiple columns

279: 20 minutes trying...

280: How to Reduce Spreadsheet Size and Speed

281: remove view format

282: Create Outlook Distribution lists in Excel VBA

283: Reregister Com Add-ins via vbs

284: If I have two reoated data-sets and a common code, how can I get i

285: Alter mask of image on button

286: macro abouut solver

287: vB code to analyse list

288: Sum range in Excel

289: Copying a calculations answer and not the calculation

290: Combo box hyperlink navigation

291: Multiple selections in Listbox

292: Loop through range and open files

293: Unwanted quotes in Unicode.txt saves

294: COUNT Function

295: Sort a list across collumns

296: Printing a Listbox

297: conditional formatting and insert cell

298: pop up

299: Lookup functions

300: Conditional Count 2 Columns