Page 32

view full version: back to formated view

1: Link a file to worksheet

2: Deleting Blank lines with VBA

3: Why I can't autofilter date (01-Jul-06 to 31-Jul-06) in Exel?

4: merging different workbook files

5: Sorting lots of data

6: SUMPRODUCT with AND's and OR's?

7: Extract Name from Range

8: How to copy a file from internet to local drive on VBA

9: Conditional Hyperlink?

10: How do I set up Reminders in an excel spreadsheet?

11: Data Validation Question

12: Selecting cells

13: How do I give permission for certain functions in excel in locked.

14: excel links break when access from network

15: Data sorting over a large number of worksheets

16: point protect

17: Name in cell ref used in a formula

18: numbers to time in same cell

19: Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How?

20: Linking Data for Proposal

21: Select paticular cells

22: Open workbooks - filenames change daily

23: Searching & Extracting Data

24: Problem with Activeworkbook.Close SaveChanges:=False

25: Can a function returning a date return an empty value?

26: Sumproduct (I think?)

27: How can I add scrollbar to a number of cells

28: STATUS BAR

29: ??? Copy conditional formating

30: Sub Error with Sheet Protection Enabled?

31: How to make sure a Cell is within the current visible window's ran

32: Find the average SAT scores of all student who applied to each college

33: Chart via Combo Box

34: Macro causes Excel to crash

35: how to compare time in hh:mm format using IF function?

36: VLOOKUP into another workbook

37: Documentation & testing

38: Multiple queries

39: Clearing the Clipboard task pane in XL ( XP ) !!!

40: Linking question

41: VB Question

42: Help determining a best "lineup"

43: Another question regarding Dates..

44: linest r-squared bug when calculating forced through zero?

45: Identifying Objects

46: How do I get an OLEObjects check box to call a function when click

47: Or statement

48: Resizing user form in excell

49: Type Mismatch Problem

50: how can i change the colum width for cells on the same worksheet

51: Renaming a sheet

52: Sorting a List Box

53: Needed help with if function

54: Can I fill colour in a excel cell from a return from an "IF" test.

55: Round numbers THEN add them

56: Combo Box

57: how to make language independent a chart application

58: How do I create Dynamic Dropdowns

59: Counting Update

60: Automated Popup on Opening of a Spreadsheet

61: Copy rows to new sheet based on variable cell reference

62: Changing color conditionally

63: Formula to Count keywords in cells

64: Excel Pivot Table from SQL Server

65: Excel 2007 filesearch

66: formula question

67: Within Range?

68: macro to create a pivot table

69: web query data

70: Copying forumla into another Cell.

71: calculating b-weekly pay

72: how was this built

73: Array Lookup to Find Closest Date and Next Closest Date

74: Automating conform of cell contents so they MATCH

75: count & If fomula

76: vlookup on changing range

77: Cell Merge, didn't...

78: How do i click on the iSeries book in excel worksheet?

79: Changing formulae for series in line charts

80: I want to create a check list with a count of entries at bottom.

81: Flow of control in VBA Question - Userform Interaction

82: Creating a list of job numbers, missing out irrelevant items

83: How do I create a Graphical Report from Survey responses in Excel

84: Subsequence value

85: Activate Userform (run macro?) from cell value

86: How to Save an Excel file using VBA

87: Converting Excel 97 macros to 2000

88: Excel Cell Formats

89: Matching two excel files

90: Stumped - What am I doing wrong?

91: executing a stored procedure on MS SQL Server 2000 within MS Excel 2000

92: If Statement

93: Calculating cells based on dates

94: Help deleting rows with vba

95: tks for help!!!

96: Not Detecting Open Workbook Status - Odd??

97: Excel spin button

98: Page Numbering

99: Conditional Formatting...

100: Color Text Macro

101: Mail Merge Wuestion

102: GOTO another sheet

103: Excel 2003 list of new functions in this version

104: Converting Text to Numbers

105: Cannot Autorecover. Downloaded Autosafe. What now?

106: Is it possible to split the page in columns like in word???

107: Disk id

108: how can I count duplicate entries in two ranges?

109: I just want to have my columns formatted without actually formatting 6000 rows.

110: Macro Still Won't Run in Excel 2003

111: What's wrong during VBA project compilatrion?

112: Sum data in workbook 1 and write result in workbook 2

113: If the total = between 17-20 give it a score of 5, and so on

114: Delete Row Select Case

115: reduce file size

116: Common Numbers Formula

117: Export SQL Server data to EXCEL cause all column become TEXT

118: Hide zero column in Pivotreport

119: Calender Help

120: Convert Number to look like Date format.

121: Concatenate Macro

122: How to refresh a pivot table that uses changing source data

123: Issue with form field lengths

124: Using Microsoft Query

125: NEED HELP PROGRAMMING EXCEL TO AUTHENTICATE EXCEL USER ID AND LICENSE NUMBER WHEN TEMPLATES ARE USED

126: Trying to add conditional formatting to every other cell...GOING .

127: accessing excel combo box control data from vb .net

128: Warning text triggered by values of a cell range

129: VLOOKUP

130: Secure File Server For Excel Files

131: Combine workbooks

132: lookup with a formula

133: Moving Cell Values Instead of Formulas to Another Sheet

134: ..scan a table in excel

135: Copying across VBE

136: % variance calculation

137: Common Dialog Control not properly licensed

138: Question regarding how to search a column and print a row(s)

139: Hyperlinks

140: comments

141: Calculation of Interest / How to find Monthly Payment w/ Offset First Payment More options

142: Checking and merging content from several worksheets

143: SUMPRODUCT Question....

144: Saving picture in clipboard into file

145: Find exact match.

146: Excel Slow File Open Directory Response

147: Rename active sheet

148: Pasting an unknown range

149: Format Row based on Cell Content

150: vlookup error

151: COPYING A CHART!

152: Inserting lines according to number of days, adjusting date

153: A rather complicated Macro needed.

154: Searching array for date and changing offset colour depeding on combobox content?

155: Detecting changes in results of formula

156: Pivot tables Excel 2007

157: Count or Sum based on more than 1 criteria

158: help file?

159: How to merge all selected areas into one area

160: Buttons they are moving on Me

161: find

162: Delete Sheet without warning message (no VBA)

163: Writing macros to sequentially change the address of a cell in Exc

164: Append the data given in diff sheets of an Excel File to one sheet

165: How to format cells

166: range search

167: MATCH limitations?

168: Lookup Data in two seperate Spreadsheets

169: Aligning comments

170: chart titles

171: Protecting Data Validation List from being modified in the formula

172: Keeping original data format into a Pivot Table

173: Help on sorting function

174: html

175: keeping track of orders

176: Selection Change Code - Value less than another problem

177: How to draw a object and erase it programmatically

178: If Cell Contents Don't Match, Move All Data Down One Row

179: Hmmm

180: VLOOKUP Woes

181: sorting a column

182: Matching Formula ??

183: Using VB to format Excel cells

184: Changing a Parameter Of A Formula

185: Excel 2002: A few more rows of page tab would be very helpful

186: IF - AND Function

187: Difficult (for me) question about conditional SUM

188: Excel List Box

189: Selective Deleting

190: Pivot Report/Chart Setting

191: fphover.class not displaying in Explorer 6.0 when XP SP2 is instal

192: Can't make hyperlink function work for hyperlink to website

193: command button a word document in excel

194: Listbox AddItem problem

195: setting a chart size

196: Microsoft Works Spreadsheet Functions??

197: best way to format on cell change

198: insert default value

199: Counter for Rows

200: How do I fix the background shading by position?

201: Using classes to store user credentials

202: Working application - Now generates error

203: Saving a csv file with out dropping 0

204: Trouble with this code

205: FormulaArray..... HELP !!!

206: COUNTIF FUNCTION

207: Formula Problem

208: arrow keys

209: If difference is 0 or below how do show just 0

210: Converstion of Complex Word VBA macro to Excel Macro

211: putting a number equal to writing commands

212: Dropdown box HELP

213: saving new file name

214: File with packed-data

215: Converting Text email addresses to Hyperlinked email addresses

216: Sort Problem

217: Setting password on worksheet in Excel 2000

218: Formatting my column? PLEASE HELP

219: separate modules for each sub routine?

220: refer to specific worksheet

221: comments formatting

222: How do I control Auto Filter in VBA

223: How to Automatically Change Fill Colors

224: How to make numbers (assumptions) show as different color...

225: Extract From Cell

226: No control for option buttons, invisible macro??

227: Pasting an array into a range

228: Text to rows...at wits end

229: override 255 maximum character length?

230: Do Loop doesn't process

231: Dimmed Keyword as Variable

232: Creating Msg. Box

233: Prevent drag copy

234: Hyperlink Problem

235: TEXTBOX DROPDOWN

236: Run a sub or function on program start?

237: Signature Macro

238: Paste Special

239: Internet Connection Issue

240: Help with messy formula

241: Copy Range with no formal updates

242: sorting in order

243: Excel not closing properly

244: Using VBA to Send Keyboard Entry to IE Page

245: sumif function by colors

246: function help!

247: Ensure LOOkUP does not return #N/A

248: How do I set up a spread sheet that will add my hours work in h:mm

249: Printer

250: Problem setting RGB Values with ShapeRange

251: Email one worksheet to email address on worksheet

252: Change date format

253: Assign Unique Number

254: change data source for many queries at once?

255: Adding Column Heading w/o Using a Row Number

256: Help with GetSaveAsFilename

257: Macro security level

258: printing multiple copies of a worksheet

259: Using formulas in VBA

260: How do i create a new worksheet

261: how to know the active cell

262: Constant

263: need help determining a row number

264: Filtering Data With Formula

265: Excel Crashes after Cut and Paste

266: Inserting copied rows

267: deleting error message

268: Autofill a series

269: freeze pane

270: copy formulas to another workbook

271: How to know if a sort is finished sucessfully?

272: Excel 2007 Display value based on values in another column range

273: Compile error in my Application

274: Excel ADO Connectstring parameters

275: Opening files

276: copying formulas

277: dynamic print area based on cell value

278: Is it possible to set up an AutoNumber in Excel?

279: "running" page

280: How do I get right use on New Database Query

281: Turn Filters On and Off

282: Saving 2 windows

283: I can not use the financial formulas.

284: How to Import multiple-line addresses from Word into single cell?

285: Return Side and Header information from table?

286: Returning Macro to Starting Cell

287: CASE

288: excel formula

289: Send email from a VBA macro?

290: Change default font in exising workbooks

291: Connection/Import Error msgs

292: I've stumped College Prof. with this one!! NEED HELP!!

293: Zero starts of a number

294: Private subs

295: Forgot password to protected workbook

296: Workbook Open event

297: Formula to ave. last 3 months

298: VBA - Timing A Block Of Lines

299: How do you add drop down options to cells?

300: =if(vlookup for non-unique values

301: PivotTable Columns

2: Deleting Blank lines with VBA

3: Why I can't autofilter date (01-Jul-06 to 31-Jul-06) in Exel?

4: merging different workbook files

5: Sorting lots of data

6: SUMPRODUCT with AND's and OR's?

7: Extract Name from Range

8: How to copy a file from internet to local drive on VBA

9: Conditional Hyperlink?

10: How do I set up Reminders in an excel spreadsheet?

11: Data Validation Question

12: Selecting cells

13: How do I give permission for certain functions in excel in locked.

14: excel links break when access from network

15: Data sorting over a large number of worksheets

16: point protect

17: Name in cell ref used in a formula

18: numbers to time in same cell

19: Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How?

20: Linking Data for Proposal

21: Select paticular cells

22: Open workbooks - filenames change daily

23: Searching & Extracting Data

24: Problem with Activeworkbook.Close SaveChanges:=False

25: Can a function returning a date return an empty value?

26: Sumproduct (I think?)

27: How can I add scrollbar to a number of cells

28: STATUS BAR

29: ??? Copy conditional formating

30: Sub Error with Sheet Protection Enabled?

31: How to make sure a Cell is within the current visible window's ran

32: Find the average SAT scores of all student who applied to each college

33: Chart via Combo Box

34: Macro causes Excel to crash

35: how to compare time in hh:mm format using IF function?

36: VLOOKUP into another workbook

37: Documentation & testing

38: Multiple queries

39: Clearing the Clipboard task pane in XL ( XP ) !!!

40: Linking question

41: VB Question

42: Help determining a best "lineup"

43: Another question regarding Dates..

44: linest r-squared bug when calculating forced through zero?

45: Identifying Objects

46: How do I get an OLEObjects check box to call a function when click

47: Or statement

48: Resizing user form in excell

49: Type Mismatch Problem

50: how can i change the colum width for cells on the same worksheet

51: Renaming a sheet

52: Sorting a List Box

53: Needed help with if function

54: Can I fill colour in a excel cell from a return from an "IF" test.

55: Round numbers THEN add them

56: Combo Box

57: how to make language independent a chart application

58: How do I create Dynamic Dropdowns

59: Counting Update

60: Automated Popup on Opening of a Spreadsheet

61: Copy rows to new sheet based on variable cell reference

62: Changing color conditionally

63: Formula to Count keywords in cells

64: Excel Pivot Table from SQL Server

65: Excel 2007 filesearch

66: formula question

67: Within Range?

68: macro to create a pivot table

69: web query data

70: Copying forumla into another Cell.

71: calculating b-weekly pay

72: how was this built

73: Array Lookup to Find Closest Date and Next Closest Date

74: Automating conform of cell contents so they MATCH

75: count & If fomula

76: vlookup on changing range

77: Cell Merge, didn't...

78: How do i click on the iSeries book in excel worksheet?

79: Changing formulae for series in line charts

80: I want to create a check list with a count of entries at bottom.

81: Flow of control in VBA Question - Userform Interaction

82: Creating a list of job numbers, missing out irrelevant items

83: How do I create a Graphical Report from Survey responses in Excel

84: Subsequence value

85: Activate Userform (run macro?) from cell value

86: How to Save an Excel file using VBA

87: Converting Excel 97 macros to 2000

88: Excel Cell Formats

89: Matching two excel files

90: Stumped - What am I doing wrong?

91: executing a stored procedure on MS SQL Server 2000 within MS Excel 2000

92: If Statement

93: Calculating cells based on dates

94: Help deleting rows with vba

95: tks for help!!!

96: Not Detecting Open Workbook Status - Odd??

97: Excel spin button

98: Page Numbering

99: Conditional Formatting...

100: Color Text Macro

101: Mail Merge Wuestion

102: GOTO another sheet

103: Excel 2003 list of new functions in this version

104: Converting Text to Numbers

105: Cannot Autorecover. Downloaded Autosafe. What now?

106: Is it possible to split the page in columns like in word???

107: Disk id

108: how can I count duplicate entries in two ranges?

109: I just want to have my columns formatted without actually formatting 6000 rows.

110: Macro Still Won't Run in Excel 2003

111: What's wrong during VBA project compilatrion?

112: Sum data in workbook 1 and write result in workbook 2

113: If the total = between 17-20 give it a score of 5, and so on

114: Delete Row Select Case

115: reduce file size

116: Common Numbers Formula

117: Export SQL Server data to EXCEL cause all column become TEXT

118: Hide zero column in Pivotreport

119: Calender Help

120: Convert Number to look like Date format.

121: Concatenate Macro

122: How to refresh a pivot table that uses changing source data

123: Issue with form field lengths

124: Using Microsoft Query

125: NEED HELP PROGRAMMING EXCEL TO AUTHENTICATE EXCEL USER ID AND LICENSE NUMBER WHEN TEMPLATES ARE USED

126: Trying to add conditional formatting to every other cell...GOING .

127: accessing excel combo box control data from vb .net

128: Warning text triggered by values of a cell range

129: VLOOKUP

130: Secure File Server For Excel Files

131: Combine workbooks

132: lookup with a formula

133: Moving Cell Values Instead of Formulas to Another Sheet

134: ..scan a table in excel

135: Copying across VBE

136: % variance calculation

137: Common Dialog Control not properly licensed

138: Question regarding how to search a column and print a row(s)

139: Hyperlinks

140: comments

141: Calculation of Interest / How to find Monthly Payment w/ Offset First Payment More options

142: Checking and merging content from several worksheets

143: SUMPRODUCT Question....

144: Saving picture in clipboard into file

145: Find exact match.

146: Excel Slow File Open Directory Response

147: Rename active sheet

148: Pasting an unknown range

149: Format Row based on Cell Content

150: vlookup error

151: COPYING A CHART!

152: Inserting lines according to number of days, adjusting date

153: A rather complicated Macro needed.

154: Searching array for date and changing offset colour depeding on combobox content?

155: Detecting changes in results of formula

156: Pivot tables Excel 2007

157: Count or Sum based on more than 1 criteria

158: help file?

159: How to merge all selected areas into one area

160: Buttons they are moving on Me

161: find

162: Delete Sheet without warning message (no VBA)

163: Writing macros to sequentially change the address of a cell in Exc

164: Append the data given in diff sheets of an Excel File to one sheet

165: How to format cells

166: range search

167: MATCH limitations?

168: Lookup Data in two seperate Spreadsheets

169: Aligning comments

170: chart titles

171: Protecting Data Validation List from being modified in the formula

172: Keeping original data format into a Pivot Table

173: Help on sorting function

174: html

175: keeping track of orders

176: Selection Change Code - Value less than another problem

177: How to draw a object and erase it programmatically

178: If Cell Contents Don't Match, Move All Data Down One Row

179: Hmmm

180: VLOOKUP Woes

181: sorting a column

182: Matching Formula ??

183: Using VB to format Excel cells

184: Changing a Parameter Of A Formula

185: Excel 2002: A few more rows of page tab would be very helpful

186: IF - AND Function

187: Difficult (for me) question about conditional SUM

188: Excel List Box

189: Selective Deleting

190: Pivot Report/Chart Setting

191: fphover.class not displaying in Explorer 6.0 when XP SP2 is instal

192: Can't make hyperlink function work for hyperlink to website

193: command button a word document in excel

194: Listbox AddItem problem

195: setting a chart size

196: Microsoft Works Spreadsheet Functions??

197: best way to format on cell change

198: insert default value

199: Counter for Rows

200: How do I fix the background shading by position?

201: Using classes to store user credentials

202: Working application - Now generates error

203: Saving a csv file with out dropping 0

204: Trouble with this code

205: FormulaArray..... HELP !!!

206: COUNTIF FUNCTION

207: Formula Problem

208: arrow keys

209: If difference is 0 or below how do show just 0

210: Converstion of Complex Word VBA macro to Excel Macro

211: putting a number equal to writing commands

212: Dropdown box HELP

213: saving new file name

214: File with packed-data

215: Converting Text email addresses to Hyperlinked email addresses

216: Sort Problem

217: Setting password on worksheet in Excel 2000

218: Formatting my column? PLEASE HELP

219: separate modules for each sub routine?

220: refer to specific worksheet

221: comments formatting

222: How do I control Auto Filter in VBA

223: How to Automatically Change Fill Colors

224: How to make numbers (assumptions) show as different color...

225: Extract From Cell

226: No control for option buttons, invisible macro??

227: Pasting an array into a range

228: Text to rows...at wits end

229: override 255 maximum character length?

230: Do Loop doesn't process

231: Dimmed Keyword as Variable

232: Creating Msg. Box

233: Prevent drag copy

234: Hyperlink Problem

235: TEXTBOX DROPDOWN

236: Run a sub or function on program start?

237: Signature Macro

238: Paste Special

239: Internet Connection Issue

240: Help with messy formula

241: Copy Range with no formal updates

242: sorting in order

243: Excel not closing properly

244: Using VBA to Send Keyboard Entry to IE Page

245: sumif function by colors

246: function help!

247: Ensure LOOkUP does not return #N/A

248: How do I set up a spread sheet that will add my hours work in h:mm

249: Printer

250: Problem setting RGB Values with ShapeRange

251: Email one worksheet to email address on worksheet

252: Change date format

253: Assign Unique Number

254: change data source for many queries at once?

255: Adding Column Heading w/o Using a Row Number

256: Help with GetSaveAsFilename

257: Macro security level

258: printing multiple copies of a worksheet

259: Using formulas in VBA

260: How do i create a new worksheet

261: how to know the active cell

262: Constant

263: need help determining a row number

264: Filtering Data With Formula

265: Excel Crashes after Cut and Paste

266: Inserting copied rows

267: deleting error message

268: Autofill a series

269: freeze pane

270: copy formulas to another workbook

271: How to know if a sort is finished sucessfully?

272: Excel 2007 Display value based on values in another column range

273: Compile error in my Application

274: Excel ADO Connectstring parameters

275: Opening files

276: copying formulas

277: dynamic print area based on cell value

278: Is it possible to set up an AutoNumber in Excel?

279: "running" page

280: How do I get right use on New Database Query

281: Turn Filters On and Off

282: Saving 2 windows

283: I can not use the financial formulas.

284: How to Import multiple-line addresses from Word into single cell?

285: Return Side and Header information from table?

286: Returning Macro to Starting Cell

287: CASE

288: excel formula

289: Send email from a VBA macro?

290: Change default font in exising workbooks

291: Connection/Import Error msgs

292: I've stumped College Prof. with this one!! NEED HELP!!

293: Zero starts of a number

294: Private subs

295: Forgot password to protected workbook

296: Workbook Open event

297: Formula to ave. last 3 months

298: VBA - Timing A Block Of Lines

299: How do you add drop down options to cells?

300: =if(vlookup for non-unique values

301: PivotTable Columns