Page 259

view full version: back to formated view

1: Charts with Combobox

2: Limit Dates in Pivot Table

3: General Question

4: Problem with IF formula

5: Newbie vba ranges

6: Macro Help

7: Placing an array on the active sheet

8: Quick Inverted Comma Question

9: Worksheet Functions that Change Other Cells

10: Enter negative time

11: CELL ( )

12: How do I set up an APR calculation in Excel?

13: Bind Columns

14: sending HTML content with Excel MIME type

15: VBA VLookup Problem: Run-Time error '1004'

16: Holy Macro!

17: Formatting street address's for comparison

18: On open, resize page

19: Auto number invoices in Excel

20: cifras en letra

21: please check this formula

22: quick question

23: Forcing all caps in a column

24: How can I sort groups of repeating data?

25: SUMPRODUCT AND TEXT INM FORMULA

26: Track Changes compatibility between versions of Excel

27: Exporting XL data

28: Average

29: VB question

30: count cells since last non-zero value

31: Help! Query table refresh hangs excel

32: How do I reserve a document

33: How can I make a Macro work multiple rows instead of one?

34: Is there formulas which set text to equal a number?

35: sorted

36: comparing values

37: Normalize

38: excel database lookup

39: Simple? How do I average data while skipping #N/A errors?

40: Excel hangs on close when using Web services in add-in

41: synchronize worksheets with master worksheet

42: Addin - 1. Links & 2. Install/Uninstall Error Message

43: can you help me set up a macro

44: Variable upper and Lower row selection

45: Getting data for pivot table from another spreadsheet

46: Find text and print its corresponding worksheet name and row

47: Showing 3:54PM instead of 3:54:03PM

48: How to find the top 5% observations

49: Drag/fill colums and Delete Columns

50: Rounding Up Decimals

51: How do I set up a macro to automatically update links upon openin.

52: TEXT(Cell1,"MMMM YYYY") to work in all locale.

53: Data Validation Problems/Questions

54: problem assigning range returned by function, to combobox rowsource

55: Simple Warning Box

56: In VBA set Slection.AutoFilter show all

57: Excel2000 Upgrades

58: activate marco command

59: Obtain Value in sheet from C#

60: NETWORKDAYS gives #NAME even though Analysis Toolpak is installed

61: Converting Dates to 8 digits

62: Formatting cell

63: FORMAT NOT DATE

64: ugh! Match/Index problem

65: How To Make A Customer List With Extra Entries Per Customer

66: Disable X button on excel

67: Excel 2000 Macro

68: Why are my columns numbered instead of lettered?

69: Help with saving an file to an FTP site

70: Numbers after specific text

71: formulas and colorindex don't work after opentext

72: Reduce file size by removing comments from code?

73: Can you link HLOOKUP AND VLOOKUP formulas and return their interce

74: Advanced VBA Question: Copy data to another sheet to make Validation List

75: convert files to text

76: How do I print comments individually?

77: Send cmd to com1 record result to new cell

78: If date is in the month of Sept, then "1", otherwise "2"

79: link between list on same sheet

80: How do I get my date to look like this in Excel (Monday June 19,.

81: concatenate

82: Open files in folder - skip if already open

83: Modèle « lié »

84: Need help with countif or another count function

85: Quotation Marks

86: How do I convert a nominal monthly compounded rate to a quarterly.

87: If then Macro in Excel

88: Counting ultiple constants in cell

89: Pop up windows

90: formula for named cell/range based on cell values

91: Creating a New Sheet

92: Workbook Copying

93: Need a spreadsheet that sorts by month/yr & 2 other sorts w/total

94: Average a part of a on going column

95: Create a button to Save As the workbook

96: error comparing dates

97: Error in vlookup formula

98: need a formula to convert pounds to tons( 2000) lbs per ton

99: Convert Data in Columns to Rows

100: Giving FOCUS to Print Preview

101: summarise multiple worksheets

102: right hand shift key in exel 2003 after 8 seconds--cancelling?

103: recalculation automatically every second - how to (for count-down)

104: Visual Studio Tools for Microsoft Office System 2003

105: Excel Vba -userform Tabular Column

106: Counting type of incidents

107: Need user unable to unhide sheets

108: Calculation of words into numbers

109: Vlookup using a range condition

110: summing multi entries

111: List of functions and what they do.

112: Can ActiveX controls be "disabled" and "enabled"?

113: VLOOKUP

114: Finding Nearest and Furthest Date

115: Filtering on Formulas (makes messy sheets)

116: Search Problem

117: Save in location button

118: deviding hours

119: "if" formula to sum several cells...

120: Large digit numbers

121: Application is already Calculating during a "Change" event

122: Format Help BOLD year in a specific vehicle application Column

123: Counting With Blank Rows

124: if cell is greater than "" then run macro

125: Please help, its urgent !!

126: Good used book

127: how do you count numbers in a row .. but onley the highlight on

128: Tab Name or Sheet Name in a Cell

129: Copy specific text from notepad into Excel

130: Part number surrounded by quotation text qualifier imports as a number not text

131: Loop until Sum equals Zero ($0.00) - then Insert Row

132: Range.Average Problem

133: Excel / VB is driving me nuts!!

134: list sheet tab names in listbox

135: using text from a cell in the header

136: Inserting data into a different worksheet

137: Formula to capture data on a date and preserve it

138: how do i create a template for certificates of completion

139: compare name lists

140: dynamic arrays as an argument/result in programmed functions

141: Time Between 2 intervals

142: "Listing Contents of Sub-Folders"

143: Change over time fornula

144: Credit Card Info w/ Invoice Template

145: WHY, indeed!

146: Confirming existence of dependents

147: function to return position in a list

148: Add Excel data to Access

149: Calculatng bowling averages

150: On Error Issues

151: Get floating CommandBar position

152: request code for right align and percentage

153: Macro code for INI file

154: Counting number of "N",s

155: How to transform formulas to the text?

156: How to protect a column?

157: Adding single cell in multiple worksheet then averaging

158: Random number with no repetition?

159: Only show certain columns

160: Cells formatted with "("@")" don't change when text pasted in (?).

161: Problems using outlines on a protected sheet

162: Autosum

163: problem with conditional in if

164: Populating a userform from data in a sheet problem. Is it an Obvious error ??

165: Adding workdays as part of the equation

166: Excel

167: SUMIF with dates

168: Custom colours in charts

169: Is there a way to average if in excel when looking at a range of d

170: How do you say "begins with"

171: Using buttons in Worksheet

172: Word to Excel

173: Problem moving records to another sheet

174: Regarding Crystal Report in Visual Basic 6.0

175: How can I detect abrupt changes in my data

176: Reduce the file size of Word file by removing all images in it

177: number of pages

178: match 2 cell with chinese character value

179: Fun with GetOpenFilename

180: Identifying value in a cell knowing R1C1 naming

181: VBA If condition

182: I need some VB script please

183: Entering Data

184: Help with Autofill Routine

185: john

186: How to select the last 6 entries in range with a formula?

187: Conditional formatting by day of the date in Excel 2003

188: excel

189: How do I copy the contents of a range of text cells and paste into one cell?

190: Where can I buy Microsoft Office pro 2003?

191: Analysis Toolpack Didn't Install?

192: Find a value in a column

193: Calculating system downtime, not including weekends help!

194: Automatically Delete Text at the end of an imported report into Ex

195: Help with deleting all files inside of a folder from Excel?

196: VB FORMs, buttons, window properties

197: conditional formatting

198: trace dependent tool doesn't work but trace precendent doesn't

199: Transferring data from on excel spreadsheet to another

200: multiple copies of XL

201: Cell is a Member of a range or Not

202: Sorting with blank cells

203: Conditional Formatting - Thick Border?

204: Adding a splash screen to an excel add-in causes double-clicking to not work

205: how to keep formula un-changed when I chage to file folder?

206: caculate a persons age

207: Expert help needed

208: New to macros...

209: Relative Addresses in equations

210: Saving one specific worksheet in a workbook

211: PC-created files used on a Mac - Problems

212: DATA FILTER ARROWS DISPLAY WHILE INACTIVE

213: Adding random noise to data

214: convert word document to excel spreadsheet

215: Duplicating cell properties

216: chart to gif

217: lookup in 1 workbook to get data for another workbook

218: Userform Control Paste

219: Lines fo code

220: Help, please. Anybody?

221: creating a excel spread sheet using ffinancial functions

222: How do I make a compound function?

223: how do i prepare reports for tasks completed

224: VBA questions

225: Moveing Data to another Worksheet

226: Code to Change Chart Type

227: How to Check if a Process is Running

228: #ref! in calculations off of a getpivot data sum

229: error message: merged cells must be same size

230: Controls names as varible?

231: Fill down function

232: Passing arrays to VBA module

233: Workbook.Open() Fails in Vista

234: Get rid of #N/A

235: trigger event if any data in modified on ONLY the current workshee

236: 'The process cannot access the file because it is in use by anothe

237: CSV Formatting

238: Unable to record complicated formula in macro

239: importing Data from access

240: macro help

241: increase the size of a worksheet

242: size limit when opening excel?

243: Index Match Problem

244: test for secondary monitor...

245: Automation from VB - slower than from Excel

246: how to increase the font size in a dropdown list?

247: Forcing a date entry?

248: copying text via linked cell from combo box to macro code

249: add three parts of text with one date into a string

250: Data Entry

251: Display a countdown timer

252: Evaluate sumproduct question

253: 2002: Conditional formatting question

254: Excel help

255: Grouping & Group Totals

256: Macro execution time

257: Excel 2003 bug

258: Changing a horizontal axis crosses value using VBA

259: Find the last cell in a selected range?

260: I need to analyze last value of each row and get top 10 of repeating values

261: Is there an Excel Viewer ONLY = Excel WITHOUT menues+toolbars around ?

262: overlapped functions in vba for excel

263: best way to get an updatable SQL Server 2000 recordset into Excel?

264: Can you print user forms

265: How to program a spreadsheet to do this?

266: Filter similar contact numbers.

267: test

268: Using With to speed up macro

269: Select Window Containing specific text

270: Sorting by Sections Problem

271: Problem with code

272: Multiple Lists from Unique Data

273: how to keep cell rounding to 2 places even when someone else pastes number with more.

274: Macro won't run from d: drive, but works on c: drive

275: Excel 2003 recalc issue

276: a number is replaced by text when inserted anywhere in the sheet

277: Compare two excel spread sheet with macro

278: Excel User Conference Update

279: Formatting cell and doing date arithmetic

280: cell gridlines

281: COMPLICATED LOOKUP

282: Can I change the Insert Function button to an equals sign?

283: FileCopy

284: Multiple Instances - troubleshooting

285: Printing on message box condition?

286: Highlighting Holidays in a Range with dates

287: Function to add zeros to IP address data

288: Formating values

289: Multiple Excel File Import

290: Web site with information on Functions

291: WHY DOES COPING FROM SHEET TO SHEET INCREASE SIZE DRAMATICALLY?

292: subtract date and time between columns

293: Getting Query Parameter from Worksheet Cell

294: Network Issues

295: Error handling

296: sheet protection question

297: return a " " for null values

298: Resizing an input box?

299: PULL FUNCTION

300: Printing Multiple Data Validation Lists

301: Copy all workbooks into one workbook

2: Limit Dates in Pivot Table

3: General Question

4: Problem with IF formula

5: Newbie vba ranges

6: Macro Help

7: Placing an array on the active sheet

8: Quick Inverted Comma Question

9: Worksheet Functions that Change Other Cells

10: Enter negative time

11: CELL ( )

12: How do I set up an APR calculation in Excel?

13: Bind Columns

14: sending HTML content with Excel MIME type

15: VBA VLookup Problem: Run-Time error '1004'

16: Holy Macro!

17: Formatting street address's for comparison

18: On open, resize page

19: Auto number invoices in Excel

20: cifras en letra

21: please check this formula

22: quick question

23: Forcing all caps in a column

24: How can I sort groups of repeating data?

25: SUMPRODUCT AND TEXT INM FORMULA

26: Track Changes compatibility between versions of Excel

27: Exporting XL data

28: Average

29: VB question

30: count cells since last non-zero value

31: Help! Query table refresh hangs excel

32: How do I reserve a document

33: How can I make a Macro work multiple rows instead of one?

34: Is there formulas which set text to equal a number?

35: sorted

36: comparing values

37: Normalize

38: excel database lookup

39: Simple? How do I average data while skipping #N/A errors?

40: Excel hangs on close when using Web services in add-in

41: synchronize worksheets with master worksheet

42: Addin - 1. Links & 2. Install/Uninstall Error Message

43: can you help me set up a macro

44: Variable upper and Lower row selection

45: Getting data for pivot table from another spreadsheet

46: Find text and print its corresponding worksheet name and row

47: Showing 3:54PM instead of 3:54:03PM

48: How to find the top 5% observations

49: Drag/fill colums and Delete Columns

50: Rounding Up Decimals

51: How do I set up a macro to automatically update links upon openin.

52: TEXT(Cell1,"MMMM YYYY") to work in all locale.

53: Data Validation Problems/Questions

54: problem assigning range returned by function, to combobox rowsource

55: Simple Warning Box

56: In VBA set Slection.AutoFilter show all

57: Excel2000 Upgrades

58: activate marco command

59: Obtain Value in sheet from C#

60: NETWORKDAYS gives #NAME even though Analysis Toolpak is installed

61: Converting Dates to 8 digits

62: Formatting cell

63: FORMAT NOT DATE

64: ugh! Match/Index problem

65: How To Make A Customer List With Extra Entries Per Customer

66: Disable X button on excel

67: Excel 2000 Macro

68: Why are my columns numbered instead of lettered?

69: Help with saving an file to an FTP site

70: Numbers after specific text

71: formulas and colorindex don't work after opentext

72: Reduce file size by removing comments from code?

73: Can you link HLOOKUP AND VLOOKUP formulas and return their interce

74: Advanced VBA Question: Copy data to another sheet to make Validation List

75: convert files to text

76: How do I print comments individually?

77: Send cmd to com1 record result to new cell

78: If date is in the month of Sept, then "1", otherwise "2"

79: link between list on same sheet

80: How do I get my date to look like this in Excel (Monday June 19,.

81: concatenate

82: Open files in folder - skip if already open

83: Modèle « lié »

84: Need help with countif or another count function

85: Quotation Marks

86: How do I convert a nominal monthly compounded rate to a quarterly.

87: If then Macro in Excel

88: Counting ultiple constants in cell

89: Pop up windows

90: formula for named cell/range based on cell values

91: Creating a New Sheet

92: Workbook Copying

93: Need a spreadsheet that sorts by month/yr & 2 other sorts w/total

94: Average a part of a on going column

95: Create a button to Save As the workbook

96: error comparing dates

97: Error in vlookup formula

98: need a formula to convert pounds to tons( 2000) lbs per ton

99: Convert Data in Columns to Rows

100: Giving FOCUS to Print Preview

101: summarise multiple worksheets

102: right hand shift key in exel 2003 after 8 seconds--cancelling?

103: recalculation automatically every second - how to (for count-down)

104: Visual Studio Tools for Microsoft Office System 2003

105: Excel Vba -userform Tabular Column

106: Counting type of incidents

107: Need user unable to unhide sheets

108: Calculation of words into numbers

109: Vlookup using a range condition

110: summing multi entries

111: List of functions and what they do.

112: Can ActiveX controls be "disabled" and "enabled"?

113: VLOOKUP

114: Finding Nearest and Furthest Date

115: Filtering on Formulas (makes messy sheets)

116: Search Problem

117: Save in location button

118: deviding hours

119: "if" formula to sum several cells...

120: Large digit numbers

121: Application is already Calculating during a "Change" event

122: Format Help BOLD year in a specific vehicle application Column

123: Counting With Blank Rows

124: if cell is greater than "" then run macro

125: Please help, its urgent !!

126: Good used book

127: how do you count numbers in a row .. but onley the highlight on

128: Tab Name or Sheet Name in a Cell

129: Copy specific text from notepad into Excel

130: Part number surrounded by quotation text qualifier imports as a number not text

131: Loop until Sum equals Zero ($0.00) - then Insert Row

132: Range.Average Problem

133: Excel / VB is driving me nuts!!

134: list sheet tab names in listbox

135: using text from a cell in the header

136: Inserting data into a different worksheet

137: Formula to capture data on a date and preserve it

138: how do i create a template for certificates of completion

139: compare name lists

140: dynamic arrays as an argument/result in programmed functions

141: Time Between 2 intervals

142: "Listing Contents of Sub-Folders"

143: Change over time fornula

144: Credit Card Info w/ Invoice Template

145: WHY, indeed!

146: Confirming existence of dependents

147: function to return position in a list

148: Add Excel data to Access

149: Calculatng bowling averages

150: On Error Issues

151: Get floating CommandBar position

152: request code for right align and percentage

153: Macro code for INI file

154: Counting number of "N",s

155: How to transform formulas to the text?

156: How to protect a column?

157: Adding single cell in multiple worksheet then averaging

158: Random number with no repetition?

159: Only show certain columns

160: Cells formatted with "("@")" don't change when text pasted in (?).

161: Problems using outlines on a protected sheet

162: Autosum

163: problem with conditional in if

164: Populating a userform from data in a sheet problem. Is it an Obvious error ??

165: Adding workdays as part of the equation

166: Excel

167: SUMIF with dates

168: Custom colours in charts

169: Is there a way to average if in excel when looking at a range of d

170: How do you say "begins with"

171: Using buttons in Worksheet

172: Word to Excel

173: Problem moving records to another sheet

174: Regarding Crystal Report in Visual Basic 6.0

175: How can I detect abrupt changes in my data

176: Reduce the file size of Word file by removing all images in it

177: number of pages

178: match 2 cell with chinese character value

179: Fun with GetOpenFilename

180: Identifying value in a cell knowing R1C1 naming

181: VBA If condition

182: I need some VB script please

183: Entering Data

184: Help with Autofill Routine

185: john

186: How to select the last 6 entries in range with a formula?

187: Conditional formatting by day of the date in Excel 2003

188: excel

189: How do I copy the contents of a range of text cells and paste into one cell?

190: Where can I buy Microsoft Office pro 2003?

191: Analysis Toolpack Didn't Install?

192: Find a value in a column

193: Calculating system downtime, not including weekends help!

194: Automatically Delete Text at the end of an imported report into Ex

195: Help with deleting all files inside of a folder from Excel?

196: VB FORMs, buttons, window properties

197: conditional formatting

198: trace dependent tool doesn't work but trace precendent doesn't

199: Transferring data from on excel spreadsheet to another

200: multiple copies of XL

201: Cell is a Member of a range or Not

202: Sorting with blank cells

203: Conditional Formatting - Thick Border?

204: Adding a splash screen to an excel add-in causes double-clicking to not work

205: how to keep formula un-changed when I chage to file folder?

206: caculate a persons age

207: Expert help needed

208: New to macros...

209: Relative Addresses in equations

210: Saving one specific worksheet in a workbook

211: PC-created files used on a Mac - Problems

212: DATA FILTER ARROWS DISPLAY WHILE INACTIVE

213: Adding random noise to data

214: convert word document to excel spreadsheet

215: Duplicating cell properties

216: chart to gif

217: lookup in 1 workbook to get data for another workbook

218: Userform Control Paste

219: Lines fo code

220: Help, please. Anybody?

221: creating a excel spread sheet using ffinancial functions

222: How do I make a compound function?

223: how do i prepare reports for tasks completed

224: VBA questions

225: Moveing Data to another Worksheet

226: Code to Change Chart Type

227: How to Check if a Process is Running

228: #ref! in calculations off of a getpivot data sum

229: error message: merged cells must be same size

230: Controls names as varible?

231: Fill down function

232: Passing arrays to VBA module

233: Workbook.Open() Fails in Vista

234: Get rid of #N/A

235: trigger event if any data in modified on ONLY the current workshee

236: 'The process cannot access the file because it is in use by anothe

237: CSV Formatting

238: Unable to record complicated formula in macro

239: importing Data from access

240: macro help

241: increase the size of a worksheet

242: size limit when opening excel?

243: Index Match Problem

244: test for secondary monitor...

245: Automation from VB - slower than from Excel

246: how to increase the font size in a dropdown list?

247: Forcing a date entry?

248: copying text via linked cell from combo box to macro code

249: add three parts of text with one date into a string

250: Data Entry

251: Display a countdown timer

252: Evaluate sumproduct question

253: 2002: Conditional formatting question

254: Excel help

255: Grouping & Group Totals

256: Macro execution time

257: Excel 2003 bug

258: Changing a horizontal axis crosses value using VBA

259: Find the last cell in a selected range?

260: I need to analyze last value of each row and get top 10 of repeating values

261: Is there an Excel Viewer ONLY = Excel WITHOUT menues+toolbars around ?

262: overlapped functions in vba for excel

263: best way to get an updatable SQL Server 2000 recordset into Excel?

264: Can you print user forms

265: How to program a spreadsheet to do this?

266: Filter similar contact numbers.

267: test

268: Using With to speed up macro

269: Select Window Containing specific text

270: Sorting by Sections Problem

271: Problem with code

272: Multiple Lists from Unique Data

273: how to keep cell rounding to 2 places even when someone else pastes number with more.

274: Macro won't run from d: drive, but works on c: drive

275: Excel 2003 recalc issue

276: a number is replaced by text when inserted anywhere in the sheet

277: Compare two excel spread sheet with macro

278: Excel User Conference Update

279: Formatting cell and doing date arithmetic

280: cell gridlines

281: COMPLICATED LOOKUP

282: Can I change the Insert Function button to an equals sign?

283: FileCopy

284: Multiple Instances - troubleshooting

285: Printing on message box condition?

286: Highlighting Holidays in a Range with dates

287: Function to add zeros to IP address data

288: Formating values

289: Multiple Excel File Import

290: Web site with information on Functions

291: WHY DOES COPING FROM SHEET TO SHEET INCREASE SIZE DRAMATICALLY?

292: subtract date and time between columns

293: Getting Query Parameter from Worksheet Cell

294: Network Issues

295: Error handling

296: sheet protection question

297: return a " " for null values

298: Resizing an input box?

299: PULL FUNCTION

300: Printing Multiple Data Validation Lists

301: Copy all workbooks into one workbook