Page 1

view full version: back to formated view

1: IF COUNTIF & COUNTA on Filtered Visible Cells

2: To fix a sheet in MS Office to be opened first always

3: Listboxes on worksheets

4: Activex Text Box Protection

5: Formated Print Area in WEB page.

6: Countind date between two dates - formula results

7: Paste Special Default

8: help please

9: No "Options" option

10: Filters

11: How can I get web-service data into an Excel spreadsheet?

12: counting problem

13: how do I record track meet times

14: Q: DDE Link - Replace Part of the Formula

15: How do I get 6 conditional formats?

16: Textboxes

17: Tools to repair Excel files?

18: Counting textboxes

19: Daily Macro to Download Data, Order and paste in order

20: Moving Data

21: Place Valuse in Cell depanding on another

22: User form - Get record & Edit Data

23: Deafult / Forced view arrangement when opening

24: Print to PDF

25: Decimal point will not hold 2 places in Excel 2003

26: Formula for max number and the data adjacent to the cell

27: Character

28: Textbox highlighting issue

29: Help with vlookup

30: Criteria in sum if ?

31: How do I selectand copy only subtotals in a sheet

32: Unique Proposal Numbers

33: Average

34: unprotect sheet in code and make sheet visible

35: Create Custom Control thru Code?

36: Conditional Formatting of Rows Based On More Than 4 Conditions

37: Excel Headers

38: Calculating

39: Sub will not find Column "A"

40: Countif Multiple Criteria

41: no more new fonts in Linked excel graphs

42: Help! complicated programming visual basic

43: Max function with conditions

44: More efficient macro help

45: How to references objects that exist on local or network drives that aren't open.

46: Pivot Table Calculation

47: template wizard

48: Permanent Custom Header/Footer

49: How can I populate an Excel cell based on the data in another cell

50: sumif + average over12mths, then removing the avearge on 12mth

51: find a value

52: (Max - Min) for a dynamic range within a table

53: Date-dependent calculations

54: How can I maintain the web page formatting when using autorepulish feature

55: OLAP Report viewing fails to Launch using EXCEL XP

56: Averaging Duration of Time: Duration Longer than 24hr

57: Text in Cell as Formula

58: Assign the content of a cell from excel to a variabele

59: please help with get pivotdata formula

60: importing prn file

61: Contents of a TextBox to HTML

62: Prevent control taking focus when accelerator key is used?

63: A better way to do this?

64: Sorting by 3 columns

65: Text box invisible scroll bars

66: Can Excel send alerts when due dates are not met?

67: Obtain row number of active cell

68: Blank cell in formula

69: VLOOKUP Help

70: Excel ignores VBA commands

71: Linking Excell Spreadsheets and Resorting Data

72: Formatting

73: AutoSum and AutoFilter

74: Unwanted character

75: copy cells in two columns if in bold to another sheet and insert rows

76: O.T. Copy Protection

77: Summation Function Sums innacurately

78: Formula checking multiple worksheets

79: Automatically inserting symbols

80: Deleting rows without a fill

81: a little help with an Excel project, pleaze...

82: Comparing data columns

83: Referencing a series of cells

84: Summing times

85: Count date

86: Loop through table of columns and rows

87: copy data from one cell to another

88: Windows Installer

89: How to set up single Header/Footer for all tabs in Excel Workbook.

90: Test if a folder exists

91: Excel files linked

92: lost auto sum button

93: Renamed tab .xls>3 receiving a error but can't fix

94: Shared Workbook

95: Excell and Population demographics

96: SQL Server 2000 - Pivot Table

97: Difference between dates

98: How to read workbook (not worksheet) properties with OLEDB

99: Dropdowns

100: Easy code!!!!

101: excel macros

102: Correct find syntax

103: What is easiest way to move name to another cell?

104: Sort Key Warning

105: ActiveWorkbook.ProtectSharing

106: Make all menus fully open

107: Growth

108: Overwriting Conditional Formatting

109: merging drop-downs

110: Ado / Adox ?

111: Why does SPI_GETWORKAREA come in too large?

112: importing sheets

113: Text to Columns

114: Problem programming the Sort command

115: synchronize 2 worksheets to preserve functions

116: Column with repeated numbers

117: Upper Case and Lower Case

118: HTML to Excel

119: problem in excel sheet

120: Runtime error when trying to save Excel 2000 worksheet from VB app

121: Text (blank) in pivot table cell

122: UDF Name Reverts to Lower Case

123: why does my sheet not save external link values?

124: Further help on delete criteria found

125: Copy between variable workbook names

126: Syntax to stop code in Watch Window

127: Fill blanks down column with cell above

128: cell values

129: dynamic input from a text file pavement elevations

130: Display format for Total Column of Pivot Table

131: execute macro; save it and close using Application.OnTime

132: Printing Problem In Excel Due to Macro?

133: Macro that runs entered value through "low" and "high" range

134: need help with lookup formula

135: Importing Text Files of 100,000+ lines, many blanks

136: Excel to Access database

137: Man in the middle

138: Finding the latest value in a range by formula

139: Matrix Multiplication Function creation

140: Forms - Checkboxes

141: Data Form

142: Formula for pulling column I ttl in column I for each "e" row that

143: Move ActiveCell down 12 then add up 11 above....

144: reference vsto Excel ListObject in Vb.Net 2005 project/app

145: Selecting an offset of a range of visible cells, but only those <>0?

146: Help with Arguments

147: Defining Categories for Custom Functions

148: Multiple or Variable cell references in Solver (Excel 97)

149: Picture show in image1

150: choosing dates on userform

151: Cell Editing Macro

152: Put an Outlook contact in an Excel cell?

153: AcitveSheet.Paste crashes in XL 2003

154: HTML/XML format for Excel 2000. Multiple sheets in single HTML file

155: VBA - Solver use on arrays

156: Excel 07 Conditional Formatting Help!

157: referencing cells in different workbooks

158: counting days

159: Excel VBA - conditional formatting

160: Cell Calculation taking to long

161: Getting source lists w/o opening target file

162: Calculate Sets and Subsets

163: WithEvents

164: Export names and address into outlook

165: urgent help!Identifying instances

166: Accessing a textbox on a sheet....

167: Getting "compile error" "method or data member not found" on reinstall

168: Multiple Condition Text Return

169: Compare 2 pivot tables and report differences

170: Help! Totally Grey Sheet

171: auto open, auto close

172: I cant find VLOOKUP on my French computer ?

173: How to use Opentext method with xlFixedWidth?

174: Why Can't Unprotect and write value into worksheet before close.

175: Strange Office XP calculations from 2003

176: array use problem

177: Closing the Print Dialogue box

178: Simple Error Checking

179: Class module

180: CSV to TXT: how to

181: For OZDOC 1050 Peter Young - Still trying to delete

182: Import Hyperlink from MSAccess via MSQuery

183: Copy text from word with returns into one cell

184: Sequential page numbers for one page

185: Formatting font in a list box

186: Sorting data automatically

187: How to bypass Update link dialog when open an excel file from vb

188: Macro to Refresh External data

189: Shifting the position of x-axis labels

190: After VLOOKUP!

191: Chart Macro

192: isna function

193: If statement using multiple conditions

194: Changing Cell Color

195: Copy & Paste to Last Empty Row

196: "Unable to set the ..." in Excel 97

197: Currency Rounding to nearest 5 cents

198: assigning points to rankings

199: How do I calculate the number of hours worked, by only entering s.

200: Need help using VBA to compare data in Excel columns, then manipulating data

201: Information Rights management

202: type mismatch, can't open a workbook?

203: Table Layout Question

204: Help w/Insert

205: calculating transactions per second and per hour

206: extract parameter VALUE form a user-defined function..

207: Highlighted Reference Cell for a Working Cell

208: Conditional Formatting x Draw (Circle)

209: Adding Fractions of a Second

210: ThisWorkbook Macros

211: Combobox not writing value if next selection is same

212: Paste link and more

213: Using vbYesNo in conjuction with Userform

214: How to set document printable area?

215: Get Open File Name

216: Using formulas in Excel

217: listbox

218: copy chart area

219: Stop Formatting text as DATES???

220: verify open windows

221: replace names

222: May be Automation AddIn loading problem!!

223: How do I build a excel sheet that counts item in an inventory

224: Please put a remittance advice template online

225: Getting Information from a query in ACCESS

226: refined question

227: Changing mm/dd/yyyy To yyyymmdd

228: VLOOKUP works but gets #REF when macro changes formulas to values

229: Excel macro !!

230: VBA simple one..

231: Problems with R1C1 referencing in buildling indirect references

232: 2 formulas one cell possible?

233: Disable prompt for external query

234: Combo box 2 columns

235: Let me explain my problem... (Roommate Accounting)

236: Excel macro, editing recorded cell.. not current

237: Selection of data in a sheet

238: calculatnig total time in excel

239: COUNTIF data counting

240: Detect macro's parent workbook or worksheet

241: Pivot table has an item called Formula1

242: sorting with IF formula

243: Shared Workbook grows bigger when saved

244: Subject line in outlook

245: getting vba shell command to execute batch and save output to a file

246: Curser

247: macro for matching contents in external file

248: Worksheet name

249: Sheet names

250: Retrieving list of worksheets programmatically

251: Importing text

252: Excel replaced HTML Project but Images are lost

253: Macro Calls

254: Change Event across every sheet in workbook

255: How to group the chart?

256: Date format

257: Problem with Automatic Nested Subtotals in Excel 2003

258: Navigating in big list

259: Harmonize date format

260: Toggle command buttons

261: Matching

262: Basic hours * rate formula

263: Shortcut to find sheets

264: Cut and Copy

265: Excel 2002

266: How do I tabulate between textbox controls in EXCEL?

267: LINREGR

268: Formula to average the last 4 non-blank numerical cells of a row?

269: macro to import access data into excell

270: Switching dates to end of month

271: error in excell 2007

272: Checkbox to Hide/Unhide Columns Based on Value in Cell

273: macro not running on workbook open

274: sum (column 2 of namedrange)

275: convert a number

276: hiding excel

277: how do i make a paragraph appear in one cell area?

278: vlookup with lookup value of different length

279: Excel Macro Question

280: Excel Macros: Creating, positioning and renaming a sheet

281: Row eight and row width

282: Entering a date in a textbox

283: How do I delete an embedded picture on a worksheet using VBA?

284: Custom # format

285: Select cell with upper case letters

286: Separating Numbers

287: Duplicated occurrences of class variables - VBA in Excel

288: I need your help again

289: Setting custome RGB properties to specific cells

290: Polling directory for changes

291: Workbook is saved on close - why?

292: Obtain imported file modified date

293: Double Subtotal Problem {Excel 2000}

294: Macro help - selecting rows after custom filter

295: printing multiple report

296: Any automation calls gets hung when the Excel workbook has an active cell.

297: Create a summary list without using PivotTables?

298: Table of contents

299: Usernames and Passwords--Thomas Homan

2: To fix a sheet in MS Office to be opened first always

3: Listboxes on worksheets

4: Activex Text Box Protection

5: Formated Print Area in WEB page.

6: Countind date between two dates - formula results

7: Paste Special Default

8: help please

9: No "Options" option

10: Filters

11: How can I get web-service data into an Excel spreadsheet?

12: counting problem

13: how do I record track meet times

14: Q: DDE Link - Replace Part of the Formula

15: How do I get 6 conditional formats?

16: Textboxes

17: Tools to repair Excel files?

18: Counting textboxes

19: Daily Macro to Download Data, Order and paste in order

20: Moving Data

21: Place Valuse in Cell depanding on another

22: User form - Get record & Edit Data

23: Deafult / Forced view arrangement when opening

24: Print to PDF

25: Decimal point will not hold 2 places in Excel 2003

26: Formula for max number and the data adjacent to the cell

27: Character

28: Textbox highlighting issue

29: Help with vlookup

30: Criteria in sum if ?

31: How do I selectand copy only subtotals in a sheet

32: Unique Proposal Numbers

33: Average

34: unprotect sheet in code and make sheet visible

35: Create Custom Control thru Code?

36: Conditional Formatting of Rows Based On More Than 4 Conditions

37: Excel Headers

38: Calculating

39: Sub will not find Column "A"

40: Countif Multiple Criteria

41: no more new fonts in Linked excel graphs

42: Help! complicated programming visual basic

43: Max function with conditions

44: More efficient macro help

45: How to references objects that exist on local or network drives that aren't open.

46: Pivot Table Calculation

47: template wizard

48: Permanent Custom Header/Footer

49: How can I populate an Excel cell based on the data in another cell

50: sumif + average over12mths, then removing the avearge on 12mth

51: find a value

52: (Max - Min) for a dynamic range within a table

53: Date-dependent calculations

54: How can I maintain the web page formatting when using autorepulish feature

55: OLAP Report viewing fails to Launch using EXCEL XP

56: Averaging Duration of Time: Duration Longer than 24hr

57: Text in Cell as Formula

58: Assign the content of a cell from excel to a variabele

59: please help with get pivotdata formula

60: importing prn file

61: Contents of a TextBox to HTML

62: Prevent control taking focus when accelerator key is used?

63: A better way to do this?

64: Sorting by 3 columns

65: Text box invisible scroll bars

66: Can Excel send alerts when due dates are not met?

67: Obtain row number of active cell

68: Blank cell in formula

69: VLOOKUP Help

70: Excel ignores VBA commands

71: Linking Excell Spreadsheets and Resorting Data

72: Formatting

73: AutoSum and AutoFilter

74: Unwanted character

75: copy cells in two columns if in bold to another sheet and insert rows

76: O.T. Copy Protection

77: Summation Function Sums innacurately

78: Formula checking multiple worksheets

79: Automatically inserting symbols

80: Deleting rows without a fill

81: a little help with an Excel project, pleaze...

82: Comparing data columns

83: Referencing a series of cells

84: Summing times

85: Count date

86: Loop through table of columns and rows

87: copy data from one cell to another

88: Windows Installer

89: How to set up single Header/Footer for all tabs in Excel Workbook.

90: Test if a folder exists

91: Excel files linked

92: lost auto sum button

93: Renamed tab .xls>3 receiving a error but can't fix

94: Shared Workbook

95: Excell and Population demographics

96: SQL Server 2000 - Pivot Table

97: Difference between dates

98: How to read workbook (not worksheet) properties with OLEDB

99: Dropdowns

100: Easy code!!!!

101: excel macros

102: Correct find syntax

103: What is easiest way to move name to another cell?

104: Sort Key Warning

105: ActiveWorkbook.ProtectSharing

106: Make all menus fully open

107: Growth

108: Overwriting Conditional Formatting

109: merging drop-downs

110: Ado / Adox ?

111: Why does SPI_GETWORKAREA come in too large?

112: importing sheets

113: Text to Columns

114: Problem programming the Sort command

115: synchronize 2 worksheets to preserve functions

116: Column with repeated numbers

117: Upper Case and Lower Case

118: HTML to Excel

119: problem in excel sheet

120: Runtime error when trying to save Excel 2000 worksheet from VB app

121: Text (blank) in pivot table cell

122: UDF Name Reverts to Lower Case

123: why does my sheet not save external link values?

124: Further help on delete criteria found

125: Copy between variable workbook names

126: Syntax to stop code in Watch Window

127: Fill blanks down column with cell above

128: cell values

129: dynamic input from a text file pavement elevations

130: Display format for Total Column of Pivot Table

131: execute macro; save it and close using Application.OnTime

132: Printing Problem In Excel Due to Macro?

133: Macro that runs entered value through "low" and "high" range

134: need help with lookup formula

135: Importing Text Files of 100,000+ lines, many blanks

136: Excel to Access database

137: Man in the middle

138: Finding the latest value in a range by formula

139: Matrix Multiplication Function creation

140: Forms - Checkboxes

141: Data Form

142: Formula for pulling column I ttl in column I for each "e" row that

143: Move ActiveCell down 12 then add up 11 above....

144: reference vsto Excel ListObject in Vb.Net 2005 project/app

145: Selecting an offset of a range of visible cells, but only those <>0?

146: Help with Arguments

147: Defining Categories for Custom Functions

148: Multiple or Variable cell references in Solver (Excel 97)

149: Picture show in image1

150: choosing dates on userform

151: Cell Editing Macro

152: Put an Outlook contact in an Excel cell?

153: AcitveSheet.Paste crashes in XL 2003

154: HTML/XML format for Excel 2000. Multiple sheets in single HTML file

155: VBA - Solver use on arrays

156: Excel 07 Conditional Formatting Help!

157: referencing cells in different workbooks

158: counting days

159: Excel VBA - conditional formatting

160: Cell Calculation taking to long

161: Getting source lists w/o opening target file

162: Calculate Sets and Subsets

163: WithEvents

164: Export names and address into outlook

165: urgent help!Identifying instances

166: Accessing a textbox on a sheet....

167: Getting "compile error" "method or data member not found" on reinstall

168: Multiple Condition Text Return

169: Compare 2 pivot tables and report differences

170: Help! Totally Grey Sheet

171: auto open, auto close

172: I cant find VLOOKUP on my French computer ?

173: How to use Opentext method with xlFixedWidth?

174: Why Can't Unprotect and write value into worksheet before close.

175: Strange Office XP calculations from 2003

176: array use problem

177: Closing the Print Dialogue box

178: Simple Error Checking

179: Class module

180: CSV to TXT: how to

181: For OZDOC 1050 Peter Young - Still trying to delete

182: Import Hyperlink from MSAccess via MSQuery

183: Copy text from word with returns into one cell

184: Sequential page numbers for one page

185: Formatting font in a list box

186: Sorting data automatically

187: How to bypass Update link dialog when open an excel file from vb

188: Macro to Refresh External data

189: Shifting the position of x-axis labels

190: After VLOOKUP!

191: Chart Macro

192: isna function

193: If statement using multiple conditions

194: Changing Cell Color

195: Copy & Paste to Last Empty Row

196: "Unable to set the ..." in Excel 97

197: Currency Rounding to nearest 5 cents

198: assigning points to rankings

199: How do I calculate the number of hours worked, by only entering s.

200: Need help using VBA to compare data in Excel columns, then manipulating data

201: Information Rights management

202: type mismatch, can't open a workbook?

203: Table Layout Question

204: Help w/Insert

205: calculating transactions per second and per hour

206: extract parameter VALUE form a user-defined function..

207: Highlighted Reference Cell for a Working Cell

208: Conditional Formatting x Draw (Circle)

209: Adding Fractions of a Second

210: ThisWorkbook Macros

211: Combobox not writing value if next selection is same

212: Paste link and more

213: Using vbYesNo in conjuction with Userform

214: How to set document printable area?

215: Get Open File Name

216: Using formulas in Excel

217: listbox

218: copy chart area

219: Stop Formatting text as DATES???

220: verify open windows

221: replace names

222: May be Automation AddIn loading problem!!

223: How do I build a excel sheet that counts item in an inventory

224: Please put a remittance advice template online

225: Getting Information from a query in ACCESS

226: refined question

227: Changing mm/dd/yyyy To yyyymmdd

228: VLOOKUP works but gets #REF when macro changes formulas to values

229: Excel macro !!

230: VBA simple one..

231: Problems with R1C1 referencing in buildling indirect references

232: 2 formulas one cell possible?

233: Disable prompt for external query

234: Combo box 2 columns

235: Let me explain my problem... (Roommate Accounting)

236: Excel macro, editing recorded cell.. not current

237: Selection of data in a sheet

238: calculatnig total time in excel

239: COUNTIF data counting

240: Detect macro's parent workbook or worksheet

241: Pivot table has an item called Formula1

242: sorting with IF formula

243: Shared Workbook grows bigger when saved

244: Subject line in outlook

245: getting vba shell command to execute batch and save output to a file

246: Curser

247: macro for matching contents in external file

248: Worksheet name

249: Sheet names

250: Retrieving list of worksheets programmatically

251: Importing text

252: Excel replaced HTML Project but Images are lost

253: Macro Calls

254: Change Event across every sheet in workbook

255: How to group the chart?

256: Date format

257: Problem with Automatic Nested Subtotals in Excel 2003

258: Navigating in big list

259: Harmonize date format

260: Toggle command buttons

261: Matching

262: Basic hours * rate formula

263: Shortcut to find sheets

264: Cut and Copy

265: Excel 2002

266: How do I tabulate between textbox controls in EXCEL?

267: LINREGR

268: Formula to average the last 4 non-blank numerical cells of a row?

269: macro to import access data into excell

270: Switching dates to end of month

271: error in excell 2007

272: Checkbox to Hide/Unhide Columns Based on Value in Cell

273: macro not running on workbook open

274: sum (column 2 of namedrange)

275: convert a number

276: hiding excel

277: how do i make a paragraph appear in one cell area?

278: vlookup with lookup value of different length

279: Excel Macro Question

280: Excel Macros: Creating, positioning and renaming a sheet

281: Row eight and row width

282: Entering a date in a textbox

283: How do I delete an embedded picture on a worksheet using VBA?

284: Custom # format

285: Select cell with upper case letters

286: Separating Numbers

287: Duplicated occurrences of class variables - VBA in Excel

288: I need your help again

289: Setting custome RGB properties to specific cells

290: Polling directory for changes

291: Workbook is saved on close - why?

292: Obtain imported file modified date

293: Double Subtotal Problem {Excel 2000}

294: Macro help - selecting rows after custom filter

295: printing multiple report

296: Any automation calls gets hung when the Excel workbook has an active cell.

297: Create a summary list without using PivotTables?

298: Table of contents

299: Usernames and Passwords--Thomas Homan