Page 67

view full version: back to formated view

1: How do I limit Input cells in MS Excel

2: Returning a list names from a schedule

3: Enter value in cell by selecting cell.

4: Help using value in a Form TextBox

5: Auto showing a text

6: Change color for each serie?

7: Vlookup with tilde

8: Series - weeks

9: Cant view excel worksheet in web browser

10: calculate material usage

11: double lines

12: How do I ref OutlookCOM in my Excel2003 PC and run it on Excel2000

13: Conditional execution

14: I want a formula to find age of person

15: Copy range to range

16: Userform

17: Adding Times

18: how do I maintain my conditional formatting when filtering cells?

19: Opening Excel file from Windows Explorer

20: MSForms cancel

21: Conditional Formatting in Pivot Table

22: Error Trap Not Working

23: Copy and move info between files

24: Opening multiple Excel files that contain varied selected sheets

25: Grouping and Listing Projected Projects By Inclusive Dates

26: Excel 2000/XP/2003 cell limitations

27: Increaseing the number of aurguments in a function

28: Textbox.Value as a new text file

29: Is there a way to........

30: Data Validation type query

31: Open file

32: How to print odd pages only from an Excel spreadsheet?

33: Difference between NEW and CREATEOBJECT?

34: vba to loop until process finished

35: date calculation

36: data sent automatically

37: Excel doesn't calculate totals correctly

38: VBA Query that references a reserved word in one of the field names.

39: SUMIF

40: Macro-hide sub sheets?

41: How can I make my data show as flashing in Excel?

42: Lookup Value (and Total) Based on Two Criteria

43: Inverse sin

44: Print/Not print depending on dropdown list value

45: deleting blank rows with formulas

46: Class Modules vs Modules

47: default workbook

48: Running SAME Excel macro with VBScript

49: sub-range

50: EXCEL VERSION & VBE FUNCTIONALITY

51: how to create ado recordsets from rows of data?

52: Import files on a mac

53: Validation of cells containing percent

54: Disable the opening of another workbook

55: How can I handle duplicates in an Index function?

56: Append DateTime to Fiename, saveCopy

57: AutoFilter

58: how do I link Textboxes in a userform to a Cell in a Worksheet?

59: fill in hour in excel sheet

60: difficulty opening userform

61: insert data ODBC

62: Changing font color of textbox text.....

63: SUMIF Alternative?

64: Automatically Printing Autofilters

65: Need formulas

66: Refrence to Listbox in form

67: Hiding Tabs

68: Function Not Recognising Values in Populated Ranges

69: worksheet function?

70: Headers and Footers

71: Quattro to Excel File Conversion

72: Function with results in offset cell

73: HELP--- adding duration of times

74: Problems Using For Each Loop with Worksheet Array Macro

75: Copy actual URL from hyperlink cell

76: Find then If then Replace

77: Update sheet after changed Interior.ColorIndex

78: Sum Product

79: cell list from access table

80: Finding a value based on contents of two cells

81: how return to last used sheet?

82: Excel 2007 - WordArt Help Needed

83: Reduce Flashing

84: Select anything from IE and store in Excel

85: Shortcut key - merge cells

86: excel error when closing workbook

87: How do I create a Pert Chart

88: Variable text

89: Macro to merge cells

90: make combobox uneditable

91: Cannot move/copy Excel 97 worksheet

92: Clipboard question

93: Need To Add VBA Tools Like A Date Picker

94: Help with drop down menu

95: Help make a date = Day 1 of the next month ie. 20060501, 20060601

96: Inserting Rows

97: Error 438

98: Count by Color on different worksheet

99: Excel Error Message when loading

100: seperate city, state & zip from one cell

101: Error 1004 in printing .ps (postscript) file from .xls file

102: Excel/VBA possibilities

103: How to copy part of a cell into a new cell?

104: what is a cell called that is used in calculation?? HELP

105: Macro Forces a Check of Data Validation Before Saving or E-mailing

106: Easy Formula?

107: Getting file names in a directory

108: specifying ranges using cells

109: Multiple Results for Vlookup in one column

110: Within 6 months, Within 1 year and so on...

111: Identifying the user that has a workbook open?

112: ..:: Please solve this ::..

113: How to trim a character from a cell ?

114: logical function

115: lookup information in a row like a record

116: Linking worksheet functions and arrays - Doozie

117: Worksheet menu bar using code????

118: locking textbox?!

119: Grouping Rows

120: Emailing Worksheet with VBA Code

121: XL2003: "Auto row height" with Wrap Text driving me nuts

122: installing an addin

123: VBA

124: Mode-1

125: SUMPRODUCT Help Please.....

126: Cummulative total in Userform

127: Counting rows in a range

128: Rounding Up

129: Using Excel as my database

130: Help with a formula please

131: Unknown crashing in Excel 2000 - doesn't crash in Excel XP. Please help!

132: Excel goes real slow

133: barcodes in cells

134: Removing dashes in entire column using VBA

135: Textbox does not print properly

136: Auto-numbering in exel (like word)

137: Excel Developer Needed - Dallas, TX

138: Overlapping DataLabels

139: There must be a way...

140: Need help on Logic test!!!

141: EXCEL VB Macro Run Time Error 1004 - Setting ColorIndex

142: Upload to bank account

143: copy/paste not working

144: How do I Replace - with + and vice versa

145: How to make a button VBA code reference other VBA code subroutines???

146: Columns in Excel

147: runtime error 13 - unlucky for some!

148: A formula that is: if the sum is this, then muliply by this?

149: How do I reference the last row and selected cell/s?

150: #value! error trying to create a simple dynamic named range

151: run time error 9, subscript out of range

152: matching Check # for Bank Reconciliation through Excel

153: Formula

154: How do I format dates accessed by a formula

155: Passing frame object in code

156: outlook import dl

157: Next Row

158: Help with getting first letter of a string

159: Basic Question

160: Array max formula?

161: Handling 2 workbooks

162: Find the top Scores per School

163: sorting text in a string

164: swap

165: Need help with SUMPRODUCT

166: Comment Bug? Excel 2002

167: macro to scroll the worksheet and continue to run macro in backgro

168: Trouble with Sheet Deactivate macro

169: always save back up, save as, tools, properties

170: Install these security update

171: Functions

172: MACRO OR FORMULA NEEDED FOR CALCULATION

173: Error code=2

174: Selecting Variable Data Ranges

175: =?Utf-8?Q?para_ter_excel_no_meu_computador?=

176: How to print the circles in formatting audit circle invalid data

177: Code help: Combing data from worksheets in a directory.

178: VLOOKUP: type or paste values

179: FORMULA HELP PLEASE!

180: Sort with a List

181: How can I edit cell notes while track changes is turned on?

182: How do I add a hyperlink to a particular cell to a textbox using vba?

183: Arranging data from different Column

184: school grades in a spreadsheet.

185: Close a userform

186: using the if statement with data validation

187: Run-time error '1004' on Range.Activate

188: Replace empty cell with cell on right

189: Maintain Relative Reference After Inserting a Column

190: How to change this into array ?

191: Setting up Worksheet_Change event

192: I need a Lookup of some sort cont.

193: Undesired change of active workbook

194: Allow Sheets to be Connected by Rows or by Columns

195: Count Unique Text Values

196: Filesearch problem

197: Cell Location of LARGE response

198: Counting the number of Error Types

199: Office XP Subscription

200: Sum Question

201: to close a workbook via VBA

202: select last cell in used range

203: Import Large Text into Excel Worksheet

204: IF, OR, AND function

205: Compare and match names and extract a cell content

206: Copying a range

207: Excel file on web

208: Skip to Next "x" inside of a For Next Loop

209: Macro to select and print sheets

210: column limitation

211: Formula HELP !!

212: Edit Sheets in Excel Addin

213: Linking worksheet data

214: Cancel Print?

215: "document not saved"

216: must read

217: freeze more than one row within a spreadhsheet

218: excel has encountered an error and must close

219: HOW DO I SHOW A ZERO VALUE FOR A FORMULA THAT RETURN A " FALSE" ?

220: How do I get more color options for fill in for cells, excel 2003?

221: Macro that runs automatically?

222: Adding Sheet Invalidates Digital Signature

223: Pivot SubTotals - Request help

224: Simple addition problem

225: Is a simple macro possible for this useful idea (Excel 2000)?

226: footer across bottom of the page

227: Not understanding If Not..Then nothing

228: Offset Count if, between two words!

229: engineering notation in excell

230: file manipulation

231: Is Lotus 1-2-3 conversion possible?

232: % in Pivot Reports

233: IF then problem for beginner

234: advanced lookup?

235: Bringing up Old Files in Excel 2003

236: Disable automatic GETPIVOT

237: Pivot tables Excel vs Access

238: Unique draws "Football"

239: Removing VB Code!!!

240: count values in one column based on their realtionship with anoth.

241: Calling a Macro from module

242: Macro Security

243: Copy range Cell text and font properties to a Textbox

244: how do I convert euro values to GBP in excel

245: Macro - Loop or Next

246: Formula Rounding

247: Access to the value of a merged cell in a formula

248: Limited byrows propagate a value via macro to all cells in column

249: Loading Excel Data into PeopleSoft

250: Excel 2002

251: EOMONTH problem File error: data may have been lost

252: Matching 2 sheets with data then display a result

253: best way of distributing toolbars

254: show header

255: Which sheet is active

256: How do I filter data from a master worksheet to other worksheets

257: Subtotal of Subtotal displays Grand Total in wrong row

258: Setting intercept to zero with SLOPE/STEYX/etc

259: Counting

260: exclude hidden rows from sum

261: Find Percent something in particular in a column.

262: Need formula or code

263: CountIf cell value greater than 14

264: Cleaning Messy Data

265: NEW free code: digital signatures, embed binary data..

266: Excel 2007 - Unreadable Content 2007

267: inserting cells to multiple sheets

268: Using a certain cell based on the value of another cell

269: Email in VBA - getting a warning before sending

270: Duplicate Macro for Closed Workbooks

271: Hyperlink Delete problem

272: Sampling data every 15 seconds with macros

273: Macro Created but Not Running in Workbook

274: Help! I want to fill cells as a result of selecting a value from a list in another cell.

275: Cell reference math

276: Problem on the ASP using the Excel.Application Object

277: making sure empty cellsa are empty?

278: Visual Basic

279: i'd like to create a formula

280: Write-back formulas in comment boxes into underlying cells

281: Userform Search

282: time error

283: conditional formatting with four conditions

284: Summing values from an undetermined number of sheet

285: Sum + Indirect

286: Simple INT error?

287: Conditional Formatting

288: Workesheet Calculate - strange behaviour and theoretical question...

289: Loop through specific worksheets

290: Posting excel spreadshet on Company Intranet

291: Excel95 Floppy Save problem

292: Removing menu bar customization from old XL95 files

293: Can I "Save As..." an Excel Sheet to an Access Table?

294: how to COUNTIF with more than one

295: HELP!!!! on formula PLEASE!!!!!!!!!!!!

296: last duplicate value

297: How to transpose an excel worksheet having more than 10000 rows into a text file, may by tab delimit

298: The Most Simple Question Ever

299: retrieve & count text

300: Insert a blank row after change in data

301: Lookup with offset

2: Returning a list names from a schedule

3: Enter value in cell by selecting cell.

4: Help using value in a Form TextBox

5: Auto showing a text

6: Change color for each serie?

7: Vlookup with tilde

8: Series - weeks

9: Cant view excel worksheet in web browser

10: calculate material usage

11: double lines

12: How do I ref OutlookCOM in my Excel2003 PC and run it on Excel2000

13: Conditional execution

14: I want a formula to find age of person

15: Copy range to range

16: Userform

17: Adding Times

18: how do I maintain my conditional formatting when filtering cells?

19: Opening Excel file from Windows Explorer

20: MSForms cancel

21: Conditional Formatting in Pivot Table

22: Error Trap Not Working

23: Copy and move info between files

24: Opening multiple Excel files that contain varied selected sheets

25: Grouping and Listing Projected Projects By Inclusive Dates

26: Excel 2000/XP/2003 cell limitations

27: Increaseing the number of aurguments in a function

28: Textbox.Value as a new text file

29: Is there a way to........

30: Data Validation type query

31: Open file

32: How to print odd pages only from an Excel spreadsheet?

33: Difference between NEW and CREATEOBJECT?

34: vba to loop until process finished

35: date calculation

36: data sent automatically

37: Excel doesn't calculate totals correctly

38: VBA Query that references a reserved word in one of the field names.

39: SUMIF

40: Macro-hide sub sheets?

41: How can I make my data show as flashing in Excel?

42: Lookup Value (and Total) Based on Two Criteria

43: Inverse sin

44: Print/Not print depending on dropdown list value

45: deleting blank rows with formulas

46: Class Modules vs Modules

47: default workbook

48: Running SAME Excel macro with VBScript

49: sub-range

50: EXCEL VERSION & VBE FUNCTIONALITY

51: how to create ado recordsets from rows of data?

52: Import files on a mac

53: Validation of cells containing percent

54: Disable the opening of another workbook

55: How can I handle duplicates in an Index function?

56: Append DateTime to Fiename, saveCopy

57: AutoFilter

58: how do I link Textboxes in a userform to a Cell in a Worksheet?

59: fill in hour in excel sheet

60: difficulty opening userform

61: insert data ODBC

62: Changing font color of textbox text.....

63: SUMIF Alternative?

64: Automatically Printing Autofilters

65: Need formulas

66: Refrence to Listbox in form

67: Hiding Tabs

68: Function Not Recognising Values in Populated Ranges

69: worksheet function?

70: Headers and Footers

71: Quattro to Excel File Conversion

72: Function with results in offset cell

73: HELP--- adding duration of times

74: Problems Using For Each Loop with Worksheet Array Macro

75: Copy actual URL from hyperlink cell

76: Find then If then Replace

77: Update sheet after changed Interior.ColorIndex

78: Sum Product

79: cell list from access table

80: Finding a value based on contents of two cells

81: how return to last used sheet?

82: Excel 2007 - WordArt Help Needed

83: Reduce Flashing

84: Select anything from IE and store in Excel

85: Shortcut key - merge cells

86: excel error when closing workbook

87: How do I create a Pert Chart

88: Variable text

89: Macro to merge cells

90: make combobox uneditable

91: Cannot move/copy Excel 97 worksheet

92: Clipboard question

93: Need To Add VBA Tools Like A Date Picker

94: Help with drop down menu

95: Help make a date = Day 1 of the next month ie. 20060501, 20060601

96: Inserting Rows

97: Error 438

98: Count by Color on different worksheet

99: Excel Error Message when loading

100: seperate city, state & zip from one cell

101: Error 1004 in printing .ps (postscript) file from .xls file

102: Excel/VBA possibilities

103: How to copy part of a cell into a new cell?

104: what is a cell called that is used in calculation?? HELP

105: Macro Forces a Check of Data Validation Before Saving or E-mailing

106: Easy Formula?

107: Getting file names in a directory

108: specifying ranges using cells

109: Multiple Results for Vlookup in one column

110: Within 6 months, Within 1 year and so on...

111: Identifying the user that has a workbook open?

112: ..:: Please solve this ::..

113: How to trim a character from a cell ?

114: logical function

115: lookup information in a row like a record

116: Linking worksheet functions and arrays - Doozie

117: Worksheet menu bar using code????

118: locking textbox?!

119: Grouping Rows

120: Emailing Worksheet with VBA Code

121: XL2003: "Auto row height" with Wrap Text driving me nuts

122: installing an addin

123: VBA

124: Mode-1

125: SUMPRODUCT Help Please.....

126: Cummulative total in Userform

127: Counting rows in a range

128: Rounding Up

129: Using Excel as my database

130: Help with a formula please

131: Unknown crashing in Excel 2000 - doesn't crash in Excel XP. Please help!

132: Excel goes real slow

133: barcodes in cells

134: Removing dashes in entire column using VBA

135: Textbox does not print properly

136: Auto-numbering in exel (like word)

137: Excel Developer Needed - Dallas, TX

138: Overlapping DataLabels

139: There must be a way...

140: Need help on Logic test!!!

141: EXCEL VB Macro Run Time Error 1004 - Setting ColorIndex

142: Upload to bank account

143: copy/paste not working

144: How do I Replace - with + and vice versa

145: How to make a button VBA code reference other VBA code subroutines???

146: Columns in Excel

147: runtime error 13 - unlucky for some!

148: A formula that is: if the sum is this, then muliply by this?

149: How do I reference the last row and selected cell/s?

150: #value! error trying to create a simple dynamic named range

151: run time error 9, subscript out of range

152: matching Check # for Bank Reconciliation through Excel

153: Formula

154: How do I format dates accessed by a formula

155: Passing frame object in code

156: outlook import dl

157: Next Row

158: Help with getting first letter of a string

159: Basic Question

160: Array max formula?

161: Handling 2 workbooks

162: Find the top Scores per School

163: sorting text in a string

164: swap

165: Need help with SUMPRODUCT

166: Comment Bug? Excel 2002

167: macro to scroll the worksheet and continue to run macro in backgro

168: Trouble with Sheet Deactivate macro

169: always save back up, save as, tools, properties

170: Install these security update

171: Functions

172: MACRO OR FORMULA NEEDED FOR CALCULATION

173: Error code=2

174: Selecting Variable Data Ranges

175: =?Utf-8?Q?para_ter_excel_no_meu_computador?=

176: How to print the circles in formatting audit circle invalid data

177: Code help: Combing data from worksheets in a directory.

178: VLOOKUP: type or paste values

179: FORMULA HELP PLEASE!

180: Sort with a List

181: How can I edit cell notes while track changes is turned on?

182: How do I add a hyperlink to a particular cell to a textbox using vba?

183: Arranging data from different Column

184: school grades in a spreadsheet.

185: Close a userform

186: using the if statement with data validation

187: Run-time error '1004' on Range.Activate

188: Replace empty cell with cell on right

189: Maintain Relative Reference After Inserting a Column

190: How to change this into array ?

191: Setting up Worksheet_Change event

192: I need a Lookup of some sort cont.

193: Undesired change of active workbook

194: Allow Sheets to be Connected by Rows or by Columns

195: Count Unique Text Values

196: Filesearch problem

197: Cell Location of LARGE response

198: Counting the number of Error Types

199: Office XP Subscription

200: Sum Question

201: to close a workbook via VBA

202: select last cell in used range

203: Import Large Text into Excel Worksheet

204: IF, OR, AND function

205: Compare and match names and extract a cell content

206: Copying a range

207: Excel file on web

208: Skip to Next "x" inside of a For Next Loop

209: Macro to select and print sheets

210: column limitation

211: Formula HELP !!

212: Edit Sheets in Excel Addin

213: Linking worksheet data

214: Cancel Print?

215: "document not saved"

216: must read

217: freeze more than one row within a spreadhsheet

218: excel has encountered an error and must close

219: HOW DO I SHOW A ZERO VALUE FOR A FORMULA THAT RETURN A " FALSE" ?

220: How do I get more color options for fill in for cells, excel 2003?

221: Macro that runs automatically?

222: Adding Sheet Invalidates Digital Signature

223: Pivot SubTotals - Request help

224: Simple addition problem

225: Is a simple macro possible for this useful idea (Excel 2000)?

226: footer across bottom of the page

227: Not understanding If Not..Then nothing

228: Offset Count if, between two words!

229: engineering notation in excell

230: file manipulation

231: Is Lotus 1-2-3 conversion possible?

232: % in Pivot Reports

233: IF then problem for beginner

234: advanced lookup?

235: Bringing up Old Files in Excel 2003

236: Disable automatic GETPIVOT

237: Pivot tables Excel vs Access

238: Unique draws "Football"

239: Removing VB Code!!!

240: count values in one column based on their realtionship with anoth.

241: Calling a Macro from module

242: Macro Security

243: Copy range Cell text and font properties to a Textbox

244: how do I convert euro values to GBP in excel

245: Macro - Loop or Next

246: Formula Rounding

247: Access to the value of a merged cell in a formula

248: Limited byrows propagate a value via macro to all cells in column

249: Loading Excel Data into PeopleSoft

250: Excel 2002

251: EOMONTH problem File error: data may have been lost

252: Matching 2 sheets with data then display a result

253: best way of distributing toolbars

254: show header

255: Which sheet is active

256: How do I filter data from a master worksheet to other worksheets

257: Subtotal of Subtotal displays Grand Total in wrong row

258: Setting intercept to zero with SLOPE/STEYX/etc

259: Counting

260: exclude hidden rows from sum

261: Find Percent something in particular in a column.

262: Need formula or code

263: CountIf cell value greater than 14

264: Cleaning Messy Data

265: NEW free code: digital signatures, embed binary data..

266: Excel 2007 - Unreadable Content 2007

267: inserting cells to multiple sheets

268: Using a certain cell based on the value of another cell

269: Email in VBA - getting a warning before sending

270: Duplicate Macro for Closed Workbooks

271: Hyperlink Delete problem

272: Sampling data every 15 seconds with macros

273: Macro Created but Not Running in Workbook

274: Help! I want to fill cells as a result of selecting a value from a list in another cell.

275: Cell reference math

276: Problem on the ASP using the Excel.Application Object

277: making sure empty cellsa are empty?

278: Visual Basic

279: i'd like to create a formula

280: Write-back formulas in comment boxes into underlying cells

281: Userform Search

282: time error

283: conditional formatting with four conditions

284: Summing values from an undetermined number of sheet

285: Sum + Indirect

286: Simple INT error?

287: Conditional Formatting

288: Workesheet Calculate - strange behaviour and theoretical question...

289: Loop through specific worksheets

290: Posting excel spreadshet on Company Intranet

291: Excel95 Floppy Save problem

292: Removing menu bar customization from old XL95 files

293: Can I "Save As..." an Excel Sheet to an Access Table?

294: how to COUNTIF with more than one

295: HELP!!!! on formula PLEASE!!!!!!!!!!!!

296: last duplicate value

297: How to transpose an excel worksheet having more than 10000 rows into a text file, may by tab delimit

298: The Most Simple Question Ever

299: retrieve & count text

300: Insert a blank row after change in data

301: Lookup with offset