Page 296

view full version: back to formated view

1: ActiveWindow.ScrollColumn Sort

2: Should I use Excel for this software project--or something else?

3: Here is fix for Windows file problems

4: SUMIF with multiple criteria for multiple columns to sum a single

5: default printer

6: Open a mail merge from excel: common problem

7: Link From Excel to Acrobat PDF Bookmark?

8: New guy with a tricky question

9: Excluding only leading or trailing cells from a column

10: Creating my own undo

11: Array error

12: looping at regular interval

13: Copying Excel Cells including Names Into Existing Spreadsheet

14: Placing a 'find'(ctrl+F) button in a UserForm

15: Copy and paste pivot table?

16: Conditional Formatting (Dates)

17: Help With The Upper Function

18: Workbook with big array functions slow to open first time in 2003

19: Email Notification

20: List Filenames from Folder

21: how do i change hours and minutes into a decimal number?

22: HELP! Network Hung

23: Can I code Styles

24: Excel 2002 Template Wizard

25: Calling excel macro from VB 6 app problem

26: Using a series of named ranges in SUMPRODUCT

27: "Basic File Search"

28: how to ignore memory copied ?

29: Change Event

30: Sum a range of cells starting from an offset date list from TODAY()

31: macro to save as

32: issue printing doccuments in excel

33: Finding Current Path

34: Hyperlinks.Add does nothing

35: show all/pivot - 2 questions

36: RE: Postcode validation

37: play girls

38: Cell color pattern styles in Excel 2007

39: ???

40: Data validation & Printing

41: Pasting column after end of spreadsheet.

42: Search & replace in VBE on other workbooks & different directorie

43: Call Search Application

44: Custom Calculated Items in a PivotTable

45: List of items in an array - VBA?

46: Vlookup for two value

47: Sort using 4 keys

48: Blanks non blanks in filter

49: calculate formula of another cell

50: I want to use C# instead of VBA

51: Hyperlink

52: Error in loading DLL - repost

53: closing a file without saving

54: Annoying "virus" alert when using code to send mail

55: Negative numbers to 0

56: finding the cell with min value and returning the contents of neig

57: data entry problem

58: For/Next using Thing

59: Formula help required

60: OnTimer Event

61: Determining if a Add-In has been loaded from XLSTART

62: getting info from multiple workbooks simultaneously

63: Working around a messagebox

64: SEARCH function #VALUE! result

65: Help with a formula

66: Turning off System Messages

67: Delete Asterisk besides Numbers in a Cell

68: UserForm-Insert value from diff worksheet into text box upon initi

69: Pivot Cache

70: Microsoft Excel-locking a column

71: Highest then alphabetical order By Names?

72: (2007) Excel macro blocks Outlook???

73: adding values based on criteria

74: Limiting Number of Times a Workbook can be Opened

75: Not Enough Memory - While Running a Macro

76: nesting with statements

77: VBS script for Pocket PC

78: Excel 2000 Functions

79: =?iso-8859-1?q?SAVE_AS...__WITHOUT_COPYING_THISWORKBOOK_MACRO=B4S?=

80: excel question?

81: Lookuprng error

82: Archivo XLA. no abre

83: please help

84: Font color question

85: Extract list of units based on error criteria to new list

86: Controlling the position of attachments and Body Text in Outlook

87: Auto Upper on certain cells.

88: Can you import data into an Excel Calendar Template?

89: Running a Macro Without Apparent Code

90: Enter a formula that calculates 5 years from a given date

91: A computer with morals?...it doesn't want to "kill"

92: Info Only: Formula Freeze Module

93: Function for Totals

94: Print Acrobat Reader PDF file from VBA

95: OptionBox error checking

96: Function Vs. Sub

97: Create a layout for a warehouse

98: Open Windows Explorer and select item

99: Save workbook as a PDF File

100: Microsoft office 2003 excel features -- no equals sign

101: Changing the Datasource of a Pivot Table

102: copy just subtotals ?

103: Referring to a TextBox

104: Input two cells with one selection

105: Comparing rows on one sheet to list on other

106: How do I put a background in a coloured spreadsheet?

107: VBE References List

108: How do I reference the cell address next to Active cell - Try 2

109: Excel auto updating worksheet

110: Problem with the import of a database table into Excel 2003.

111: Adding and Subtracting a Time with MilliSeconds

112: Crash when inserting a template

113: Autocomplete

114: unprotect query cell

115: Information on Excel capabilities and application interface

116: Slow tabstrip

117: Checking for Changes in File's Cell Layout

118: How to fill an internet field using VBA

119: sumproduct bllank function handling

120: vlookup combine indirect

121: Sort Method more than 3 cols

122: How to detect if sheet is hidden?

123: assign macro

124: new version# when opening file

125: Conditional data move syntax

126: Formatting cells

127: Sheets("Sheet1").Move After:=Sheets(2)

128: Looking for a Utility with Multi Line REM conversion

129: Is there a similar forum for Word?

130: Choosing Only One Of Three OptionButtons

131: Small help with vlookup and sum

132: how to do a "check for updates" over the internet

133: Gather data from several workbooks.

134: using a countif with multiple columns

135: Locking an Excel Spreadsheets Scrolling ability

136: How to use PivotTable's to work out Variances?

137: selecting and sorting a variable rowlength

138: Value searching in columns - vlookup can not do it?

139: Export a Named range to Tab seperated text file

140: How long until 5:00?

141: Excel Formulas

142: Using excel to insert autocad blocks?

143: Worksheet Selected Names

144: Reference other worksheet

145: Excel 2003 Format

146: formulas - finding what is "x"?

147: URGENT, help needed.

148: I want to do Autosum by pressing "Alt=", instead I get 3/4. Why?

149: Possible to copy and paste to a new outlook msg?

150: Extract Text--Hopefully Easy!

151: workbook as variable

152: Advance By Month With A CommandButton

153: Parseing to produce text only

154: Data Validation List Not Formated

155: Simple Paste Question

156: Can you reference a cell that is sorted in excel 2002?

157: Excel 2002 VBA code to return a page number within a worksheet

158: Highest value in column b returning column a

159: Automatic sorting in Excel

160: transpose data from horizontal to vertical in a specific column

161: Compile error for macros

162: moving rows based on criteria

163: PDF Smart Tags

164: SUMPRODUCT((A2:A210<>"")/COUNTIF(A2:A210,(A2:A210&"")))

165: help me clean up this code

166: Sorting in Excel

167: Help: Custom view will not stick

168: Excel 2002: How is the Excel 2007 file format open in Excel 2002 ?

169: Open / Close of all Groupings...

170: Minimize the VB form

171: Test

172: If Statement

173: Fix InputBox - Returning Empty String

174: More than 256 columns in MS Excel ???

175: Path names to xla file in formula

176: Absolute cell formula

177: Slow recalculation

178: UserForm Button Help

179: Problem with xlCenterAcrossSelection

180: ActiveX button Hyperlink only works in design mode

181: Adding # of days to a date

182: Timecard - Calculating Time Error

183: Filename parameters passed based on cell contents

184: how to generate data from a list on excel from another worksheet?

185: DataGrid Control

186: Transferring Data from a UserForm to a worksheet

187: Macros in a template run from Custom Toolbar attaching to wrong file.

188: Disable cut paste in a workbook

189: Method 'Copy' of object'_Worksheet failed

190: Formulas

191: maintain worksheet reference

192: Workbook

193: How to email A file

194: Excel tabs keep disappearing and my worksheet pages view changes

195: Comparing Workbook contents

196: Gettiiing Started in VBA

197: OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table

198: Creating multiple hyperlinks from a column where the text in the .

199: Can this be done?

200: Sort Macro

201: Why can I not open an Excel Compound file with Office Excel xp?

202: How do I collect excell spreadsheets from 30 people?

203: Uninstall Excel Addin

204: x Axes valus

205: Combining singles data records

206: Missing info in Formula Tab

207: Page Layout like Word?

208: Closing Wookbook with items in clipboard

209: hyper linking

210: Before_Save event

211: how to show the total products sold

212: How can I prevent this from happening?

213: Listbox Select Last Value in range

214: Excel VBA-How to close all open workbooks except one specific?

215: select date range then find average of values in another cell

216: Autofilter and VBA

217: Data Form

218: Pass a filename to a query

219: Numbers won't "SUM" from YAHOO

220: telephone number format change in Excel

221: Help to edit a formula

222: Need help on Select Case

223: color Banding using visual basic

224: Default File path

225: cursor moves view instead of selection

226: Autorun Macro

227: Merging Two Files

228: simple formulas are not calculating

229: Excel 2002

230: Help with filtering...

231: Query between Excel and Access

232: Urgent Funtion problem

233: Help on adding the second trendline in a "lines on 2 axes" Chart by using VBA

234: How to use autofilter to delete duplicate rows (2nd criteria) ?

235: rounding up to the 0.97

236: Convert Ranges to Numbers

237: Unexpected COUNTIF behaviour

238: Referring to a TextBox

239: Getting Data out of a E-Mail

240: Calculating weeks

241: Selecting & Displaying An Array's Contents

242: Associate a cell with a number ??

243: I need to compare 3 numbers and find the one in the middle

244: validate work sheets

245: Macro that controlls duplicate values

246: Few column

247: worksheetname

248: macro reading excel file

249: Slow data input post formatting

250: filtering between spreadsheets

251: Too narrow columns

252: How do I import a list of names into a separate form that prints .

253: =SUM(I47:I115) What does the "I" mean and how is it used?

254: Some questions about Borders in Excel 2007

255: EXCEL 2000 AVERAGE function

256: Macro Doesn't Run With Command Button, But Does Run With F8 Key

257: VAT calculations

258: Finding the earliest "Last Saved Date" of Excel workbooks

259: Can XLS automatically insert file properties fields into a header

260: wild card *

261: incrementing a cell value

262: How can I apply a function (PROPER) to multiple cells at once?

263: Can the X to Close button on a workbook be disabled?

264: relative date appearance

265: Formula for counting more than one criteria

266: A Crosshair to Highlight the Entire Row/Column Prior to active cel

267: Date Formats in Charts with Web Preview

268: Sorting full name into 2 columns by first name and last name

269: Transfer Cell Value

270: Excel Publishing option

271: how do I make excell show time values greater than 24 hrs?

272: How do I perform summation over variable areas?

273: mid/find functions

274: Vertical lookup help needed

275: #value

276: how do i look up the closest number valuein a lookup?

277: Mixed number & text string

278: Comparing Columns of Text

279: Cell Referencing Problem

280: Paste a large text into a cell

281: Calculating days between dates and leap years

282: Show Top 10 with array formula

283: Resolving percent and date formats as such in concatenate function and emails

284: copy and paste in different columns with conditions

285: entering numbers with 0 in front of them

286: Automating Excel Cell Drag and Drop

287: Tracking changes when option changes after save

288: Lookup last value

289: Financial Statements.xls

290: Subtotal function

291: Columns to rows

292: Replace() to "Find whole words only" ...

293: Disable control down (cntl D) on a worksheet

294: Pulldown for format cells not working

295: Find/Replace functions VERY slow when visibility = false

296: Complicated Cell Formula

297: Open Workbook, Go To Worksheet ABC, Find XYZ In Column B

298: Deploy Excel 2002 add-in

299: Word Document to Excel

300: Split one cell in the middle and fill each with one color

2: Should I use Excel for this software project--or something else?

3: Here is fix for Windows file problems

4: SUMIF with multiple criteria for multiple columns to sum a single

5: default printer

6: Open a mail merge from excel: common problem

7: Link From Excel to Acrobat PDF Bookmark?

8: New guy with a tricky question

9: Excluding only leading or trailing cells from a column

10: Creating my own undo

11: Array error

12: looping at regular interval

13: Copying Excel Cells including Names Into Existing Spreadsheet

14: Placing a 'find'(ctrl+F) button in a UserForm

15: Copy and paste pivot table?

16: Conditional Formatting (Dates)

17: Help With The Upper Function

18: Workbook with big array functions slow to open first time in 2003

19: Email Notification

20: List Filenames from Folder

21: how do i change hours and minutes into a decimal number?

22: HELP! Network Hung

23: Can I code Styles

24: Excel 2002 Template Wizard

25: Calling excel macro from VB 6 app problem

26: Using a series of named ranges in SUMPRODUCT

27: "Basic File Search"

28: how to ignore memory copied ?

29: Change Event

30: Sum a range of cells starting from an offset date list from TODAY()

31: macro to save as

32: issue printing doccuments in excel

33: Finding Current Path

34: Hyperlinks.Add does nothing

35: show all/pivot - 2 questions

36: RE: Postcode validation

37: play girls

38: Cell color pattern styles in Excel 2007

39: ???

40: Data validation & Printing

41: Pasting column after end of spreadsheet.

42: Search & replace in VBE on other workbooks & different directorie

43: Call Search Application

44: Custom Calculated Items in a PivotTable

45: List of items in an array - VBA?

46: Vlookup for two value

47: Sort using 4 keys

48: Blanks non blanks in filter

49: calculate formula of another cell

50: I want to use C# instead of VBA

51: Hyperlink

52: Error in loading DLL - repost

53: closing a file without saving

54: Annoying "virus" alert when using code to send mail

55: Negative numbers to 0

56: finding the cell with min value and returning the contents of neig

57: data entry problem

58: For/Next using Thing

59: Formula help required

60: OnTimer Event

61: Determining if a Add-In has been loaded from XLSTART

62: getting info from multiple workbooks simultaneously

63: Working around a messagebox

64: SEARCH function #VALUE! result

65: Help with a formula

66: Turning off System Messages

67: Delete Asterisk besides Numbers in a Cell

68: UserForm-Insert value from diff worksheet into text box upon initi

69: Pivot Cache

70: Microsoft Excel-locking a column

71: Highest then alphabetical order By Names?

72: (2007) Excel macro blocks Outlook???

73: adding values based on criteria

74: Limiting Number of Times a Workbook can be Opened

75: Not Enough Memory - While Running a Macro

76: nesting with statements

77: VBS script for Pocket PC

78: Excel 2000 Functions

79: =?iso-8859-1?q?SAVE_AS...__WITHOUT_COPYING_THISWORKBOOK_MACRO=B4S?=

80: excel question?

81: Lookuprng error

82: Archivo XLA. no abre

83: please help

84: Font color question

85: Extract list of units based on error criteria to new list

86: Controlling the position of attachments and Body Text in Outlook

87: Auto Upper on certain cells.

88: Can you import data into an Excel Calendar Template?

89: Running a Macro Without Apparent Code

90: Enter a formula that calculates 5 years from a given date

91: A computer with morals?...it doesn't want to "kill"

92: Info Only: Formula Freeze Module

93: Function for Totals

94: Print Acrobat Reader PDF file from VBA

95: OptionBox error checking

96: Function Vs. Sub

97: Create a layout for a warehouse

98: Open Windows Explorer and select item

99: Save workbook as a PDF File

100: Microsoft office 2003 excel features -- no equals sign

101: Changing the Datasource of a Pivot Table

102: copy just subtotals ?

103: Referring to a TextBox

104: Input two cells with one selection

105: Comparing rows on one sheet to list on other

106: How do I put a background in a coloured spreadsheet?

107: VBE References List

108: How do I reference the cell address next to Active cell - Try 2

109: Excel auto updating worksheet

110: Problem with the import of a database table into Excel 2003.

111: Adding and Subtracting a Time with MilliSeconds

112: Crash when inserting a template

113: Autocomplete

114: unprotect query cell

115: Information on Excel capabilities and application interface

116: Slow tabstrip

117: Checking for Changes in File's Cell Layout

118: How to fill an internet field using VBA

119: sumproduct bllank function handling

120: vlookup combine indirect

121: Sort Method more than 3 cols

122: How to detect if sheet is hidden?

123: assign macro

124: new version# when opening file

125: Conditional data move syntax

126: Formatting cells

127: Sheets("Sheet1").Move After:=Sheets(2)

128: Looking for a Utility with Multi Line REM conversion

129: Is there a similar forum for Word?

130: Choosing Only One Of Three OptionButtons

131: Small help with vlookup and sum

132: how to do a "check for updates" over the internet

133: Gather data from several workbooks.

134: using a countif with multiple columns

135: Locking an Excel Spreadsheets Scrolling ability

136: How to use PivotTable's to work out Variances?

137: selecting and sorting a variable rowlength

138: Value searching in columns - vlookup can not do it?

139: Export a Named range to Tab seperated text file

140: How long until 5:00?

141: Excel Formulas

142: Using excel to insert autocad blocks?

143: Worksheet Selected Names

144: Reference other worksheet

145: Excel 2003 Format

146: formulas - finding what is "x"?

147: URGENT, help needed.

148: I want to do Autosum by pressing "Alt=", instead I get 3/4. Why?

149: Possible to copy and paste to a new outlook msg?

150: Extract Text--Hopefully Easy!

151: workbook as variable

152: Advance By Month With A CommandButton

153: Parseing to produce text only

154: Data Validation List Not Formated

155: Simple Paste Question

156: Can you reference a cell that is sorted in excel 2002?

157: Excel 2002 VBA code to return a page number within a worksheet

158: Highest value in column b returning column a

159: Automatic sorting in Excel

160: transpose data from horizontal to vertical in a specific column

161: Compile error for macros

162: moving rows based on criteria

163: PDF Smart Tags

164: SUMPRODUCT((A2:A210<>"")/COUNTIF(A2:A210,(A2:A210&"")))

165: help me clean up this code

166: Sorting in Excel

167: Help: Custom view will not stick

168: Excel 2002: How is the Excel 2007 file format open in Excel 2002 ?

169: Open / Close of all Groupings...

170: Minimize the VB form

171: Test

172: If Statement

173: Fix InputBox - Returning Empty String

174: More than 256 columns in MS Excel ???

175: Path names to xla file in formula

176: Absolute cell formula

177: Slow recalculation

178: UserForm Button Help

179: Problem with xlCenterAcrossSelection

180: ActiveX button Hyperlink only works in design mode

181: Adding # of days to a date

182: Timecard - Calculating Time Error

183: Filename parameters passed based on cell contents

184: how to generate data from a list on excel from another worksheet?

185: DataGrid Control

186: Transferring Data from a UserForm to a worksheet

187: Macros in a template run from Custom Toolbar attaching to wrong file.

188: Disable cut paste in a workbook

189: Method 'Copy' of object'_Worksheet failed

190: Formulas

191: maintain worksheet reference

192: Workbook

193: How to email A file

194: Excel tabs keep disappearing and my worksheet pages view changes

195: Comparing Workbook contents

196: Gettiiing Started in VBA

197: OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table

198: Creating multiple hyperlinks from a column where the text in the .

199: Can this be done?

200: Sort Macro

201: Why can I not open an Excel Compound file with Office Excel xp?

202: How do I collect excell spreadsheets from 30 people?

203: Uninstall Excel Addin

204: x Axes valus

205: Combining singles data records

206: Missing info in Formula Tab

207: Page Layout like Word?

208: Closing Wookbook with items in clipboard

209: hyper linking

210: Before_Save event

211: how to show the total products sold

212: How can I prevent this from happening?

213: Listbox Select Last Value in range

214: Excel VBA-How to close all open workbooks except one specific?

215: select date range then find average of values in another cell

216: Autofilter and VBA

217: Data Form

218: Pass a filename to a query

219: Numbers won't "SUM" from YAHOO

220: telephone number format change in Excel

221: Help to edit a formula

222: Need help on Select Case

223: color Banding using visual basic

224: Default File path

225: cursor moves view instead of selection

226: Autorun Macro

227: Merging Two Files

228: simple formulas are not calculating

229: Excel 2002

230: Help with filtering...

231: Query between Excel and Access

232: Urgent Funtion problem

233: Help on adding the second trendline in a "lines on 2 axes" Chart by using VBA

234: How to use autofilter to delete duplicate rows (2nd criteria) ?

235: rounding up to the 0.97

236: Convert Ranges to Numbers

237: Unexpected COUNTIF behaviour

238: Referring to a TextBox

239: Getting Data out of a E-Mail

240: Calculating weeks

241: Selecting & Displaying An Array's Contents

242: Associate a cell with a number ??

243: I need to compare 3 numbers and find the one in the middle

244: validate work sheets

245: Macro that controlls duplicate values

246: Few column

247: worksheetname

248: macro reading excel file

249: Slow data input post formatting

250: filtering between spreadsheets

251: Too narrow columns

252: How do I import a list of names into a separate form that prints .

253: =SUM(I47:I115) What does the "I" mean and how is it used?

254: Some questions about Borders in Excel 2007

255: EXCEL 2000 AVERAGE function

256: Macro Doesn't Run With Command Button, But Does Run With F8 Key

257: VAT calculations

258: Finding the earliest "Last Saved Date" of Excel workbooks

259: Can XLS automatically insert file properties fields into a header

260: wild card *

261: incrementing a cell value

262: How can I apply a function (PROPER) to multiple cells at once?

263: Can the X to Close button on a workbook be disabled?

264: relative date appearance

265: Formula for counting more than one criteria

266: A Crosshair to Highlight the Entire Row/Column Prior to active cel

267: Date Formats in Charts with Web Preview

268: Sorting full name into 2 columns by first name and last name

269: Transfer Cell Value

270: Excel Publishing option

271: how do I make excell show time values greater than 24 hrs?

272: How do I perform summation over variable areas?

273: mid/find functions

274: Vertical lookup help needed

275: #value

276: how do i look up the closest number valuein a lookup?

277: Mixed number & text string

278: Comparing Columns of Text

279: Cell Referencing Problem

280: Paste a large text into a cell

281: Calculating days between dates and leap years

282: Show Top 10 with array formula

283: Resolving percent and date formats as such in concatenate function and emails

284: copy and paste in different columns with conditions

285: entering numbers with 0 in front of them

286: Automating Excel Cell Drag and Drop

287: Tracking changes when option changes after save

288: Lookup last value

289: Financial Statements.xls

290: Subtotal function

291: Columns to rows

292: Replace() to "Find whole words only" ...

293: Disable control down (cntl D) on a worksheet

294: Pulldown for format cells not working

295: Find/Replace functions VERY slow when visibility = false

296: Complicated Cell Formula

297: Open Workbook, Go To Worksheet ABC, Find XYZ In Column B

298: Deploy Excel 2002 add-in

299: Word Document to Excel

300: Split one cell in the middle and fill each with one color