Page 343

view full version: back to formated view

1: Date FORMAT problem

2: MIRR Function sensitivity to Finance Rate

3: Comparing multiple columns in two sheets

4: VBA format date in footer

5: Using a Formula to get Range of Data to an Array

6: Is there any way a macro can be created for various print area selections?

7: Help!

8: Check if a folder exist

9: Need Help soon on how to search through a range

10: macro for copying cells above empty ones

11: Link comment boxes based on different cell values

12: Summing a Column of Variable Length

13: Page Setup from VBA prints half wide

14: curious sheet behaviour

15: (Probably) simple question

16: Auto Open

17: subtotal with median

18: text box with standard text

19: Formula percent complete excluding given text string

20: remove hyperlinks in a worksheet all in the same time

21: Effective rate of Interest and Copounding Interest

22: Finding age from year

23: how to applythe page setup setings to allsheets in afile in excel

24: Calcuate age

25: How can I programatically change the caption on a button?

26: formula help please

27: help with distance array

28: Compare two sets of data

29: strange date format problem

30: Variable VBA Worksheet Name

31: Replacing hilite color

32: Keep macro running overnight?

33: Excel unchecks iteration

34: Alter existing code

35: DATA VALIDATION WITH AUTODATE

36: Excel 2007 "document not saved" when on a network share AND file set as an offline file

37: Save column J only using copy/paste & temporary copy

38: Excel -> Word: Problems copying/pasting shapes

39: Marco vs Lotus Note

40: Compare worksheets

41: IF Function (I Think!)

42: Entering Excel information into MS Word

43: Excel Improvement Suggestion

44: Age Formula

45: Protecting Excel Options-Tabs

46: Worksheet_Deactivate() problem with deleting data

47: Index Match not working

48: Excel Link Updates

49: How to set the Column Header value for list box?

50: Prompt for Value

51: Pulling info from a list

52: how do I print seperate excel tab sheets in duplex

53: repeat macro after time interval

54: Dynamic Web Query

55: Help with a Formula Within a Function Please

56: cell is merged and contains "something"

57: view 100%

58: FIND LAST CELL WITH DATA

59: Please Help! - Class Not Registered

60: ! used in formulas

61: Find last populated cell in a row.

62: Dynamic summation of column

63: Left worksheet function

64: How do you create a complex footer (e.g. title block) in Excel?

65: Excel Freezes

66: Counting Cells

67: Nested with loops

68: Fastest way to enter many formulas

69: Button doesn't work

70: Delete Rows

71: Using formula in code...Part 3!

72: Obvious, but couldn't find this either

73: Number formatting - what's going on?

74: Using a disclaimer in excel

75: access cell values

76: autofill @ intervals

77: Error Handling Problem

78: Changing button appearance on custom toolbar.

79: Closing Files and Reopening them in VBA

80: Exciter: Custom Excel Applications

81: How to stop automatic calculation

82: help with loops in code,

83: special case of sumif

84: sumproduct between date range

85: Filling Blank Cells

86: are there any excel exaples on schedulling on the internet?

87: Ranking a number outside of range's values?

88: Pivot table page field doesn't update

89: Lookup values in a two way table

90: sending email with Outlook using Excel

91: Goal Seek - reference a cell for "To value" field?

92: changing property of a box while using if/then statements

93: Starting another program (again) Maybe TOM

94: Cell shows date, want to email from excel to me as a reminder

95: How do I get the date for the 2nd friday of each month?

96: Add Selected Items

97: Is there a better option than Getobject to access a .xls?

98: COUNTIF problem with Circular Reference

99: Formating column cells

100: calculting stats of column array in 3D array

101: Linking excell with access to choose a single record

102: Can't open file in Excel - 70MB - Options?

103: Can wildcards be used in SUMPRODUCT conditions

104: Functions/Formulas to count multiple variables

105: Converting Numbers To Dates

106: Copying Charts: CODE NOT ROBUST

107: Trigger on leaving cell (of entire column)

108: copying worksheets

109: Can the "Find and Replace" feature be used in Formulas somehow?

110: Excel Cursor

111: how to calcurate work hours? Please?

112: Print a WordArt in a Frontpage

113: NetDDE in Excel 2003

114: calling a batch file

115: Accessing events of com objects

116: Can you create a "flyover"?

117: seperate print and printview

118: Multiple IF factors

119: Programmatically switch off "Variable declaration reqiured" in VBE?

120: Merging workbooks that weren't "shared workbooks"

121: Anybody see anything wrong with this

122: Conditional formatting again

123: Is it possible to protect multiple worksheets at the same time

124: updating data in a pivot tables

125: MS Excel 2003

126: Compare 2 sheets and copy matching data

127: Running a macro from a command line

128: URGENT - Need date format for SaveAs code

129: Hide a series

130: How do I stop the autopaste function in Excel?

131: Many Thanks

132: Need a Formula based on multiple cirteria

133: Lookup by Last Column

134: Page set up across multiple files ? x

135: Many columns

136: searching excel with a form and returning the results

137: Consolidating Sheets into 1 new one.

138: Save exact copy of workbook

139: problem to create a line graph

140: printing without zeros showing in a cell with formulas

141: Search formula

142: Split or copy records n-times as excel scans the value of a colum

143: SQL in VBA to Access a Database and create Report

144: Turning on/off the Hourglass pointer in Excel

145: copy if

146: All Excel files opening in same window

147: combing two if then statements - appreciate any help.

148: Masking numbers

149: Conditional Formatting (Formula)

150: programming excel 97 from .net 2003

151: Excel VBA putting text from textbox into SQL statement

152: Web services??

153: range names

154: PROBLEM

155: Get NT Username

156: Multiple Formulas

157: Creating separate sheets from a list

158: How to create an automatic counter

159: VB to Excel

160: Min but not quite...

161: VBA EXCEL IFSTRING HELP

162: Programming for a Dynamic 'Where' clause

163: how to put quotation mark in each cell of the column

164: Formula for Solver

165: date reminder

166: Creating a new worksheet from another

167: Command Button does not re-set once clicked

168: Combination of left and right justification in a cell?

169: SS#'s lose lose formatting in .csv

170: Array or VB script?

171: Get the row number that matches my value

172: Excel thru Terminal Server

173: How do I undo all Page breaks in Excel

174: Error Message in VB

175: Call a add_in function in excel vba?

176: add end rows after suppressing prior rows

177: Permission to fill in cell when another cell has a value

178: selecting cells

179: Userform Textbox Currency Format Problems

180: Macro in toolbar - how to use forever

181: return a result from multiple conditions.

182: Using INDIRECT to refer to different workbooks

183: Saving a file with VBA that references current file name

184: I sort a column, how can I have all the data skip every other row

185: COUNT

186: Copied Worksheet does not maintain it 's properties

187: Detect Hidden Columns by Formula

188: Adding text in a single column

189: how to make dropdown arrow disappear in vba

190: How to fill cells from User Defined Function?

191: Macro to force Excel to close after a given timeframe of inactivit

192: IF Formula

193: Color in Cells without Showing Up in Print

194: How to stop UDF firing when sheets(n).calculate

195: filter combo box based on another

196: veryhidden sheet make restrictions ?!

197: Changing Worksheet State completely

198: HELP PLEASE

199: Help with this formula please!

200: Returning an array from a function

201: Faceid 2003.

202: Copying cells with the mouse

203: How to do TI83 2-SampTTest (hypothesis testing)?

204: syntax error

205: How find out what object is selected?

206: how to get each smarttag in smarttags in c++ com

207: currency # to full text equivilant

208: find a specific cell from the entire worksheet

209: restricted values that can be entered

210: COUNIFS

211: convert Excell 2007 file back to 2003

212: solver

213: open pdf files with a certain bookmark or page number

214: Is it possible to use some pictures in an IF function?

215: Getting coordinates of an Hyperlink using range get_Top(), get_Lef

216: Hyperlink behaviour when emailing sheet

217: Parameters for Query

218: Proper Syntax for Date Modified?

219: Run all web quiries in a worksheet

220: Can I use a variable to call up another sheet in Excel?

221: Date range selection? Anniversary dates

222: Converting Numbers to Time

223: Trans Excel data in VC

224: problem userform disappears

225: SUMIF and LEFT and Named Ranges

226: ActiveControl

227: Pivot Table Ignore Blanks

228: IS functions

229: Tracer Arrows and Objects Not Showing On Screen, But Do Print

230: add text box values

231: Question on Application/Workbook

232: protection and macros

233: intermittent error - ActiveX component can't create object

234: refer to a cell using a formula?

235: Insert/delete rows

236: Obtaining Multiple Results Using Index/Match Functions

237: help to in setting up a proper Vlookup table and formula

238: Extract Data from Multiple worksheets

239: Max worksheet exent width

240: Data Validation and Name Range

241: run time error #9, subscript out of range

242: finding values from duplicates

243: first derivative?

244: VLOOKUP WITH MACRO

245: update cell only if now() falls in a given date range

246: Calling a button event from a .NEt application

247: A number of auto filters in one sheet? Is it possible?

248: user defined function receiving a range as parameter

249: auto fill text

250: cell pattern depening on cell content

251: Shear and Bending moment diagram using excel.

252: changing colours on stacked bar chart

253: Data Consolidation from many Workbooks to One Workbook

254: Insert Subtotal button

255: Plotting Dates

256: URGENT MACRO REQUIREMENT!

257: delete toolbar on workbook close

258: Adding tool tip to worksheet button

259: How will I do Excel user-defined function to extract letters from string

260: Importing more than 65359 rows of data

261: how do I convert text cells to value

262: Resume on Error?

263: Lookup - Formatting of numbers

264: Linking Worksheets to a Summary Worksheet

265: Formats-Paste special

266: Custom Cell Format

267: How to enter a value in a cell

268: Pivot Table comments

269: Delete an autostart Sub with code

270: Create a macro that finds values then sorts

271: what approach/technology?

272: Programmatically Open Locked VBAProject

273: using a worksheet range to populate a combo box in excel

274: How to find if a string starts with a digit

275: Excel automation from C++ and big numbers

276: Hyperlinks from one excel sheet to another in VBA

277: CommandBars vs CommandBars(1).Controls

278: Show Top 3 Values

279: Looking for a better way - Serial to local machine number

280: Calculation

281: Format is lost when number changed to text

282: running code when vba project is opened

283: hyperlink

284: Double and Multiple Lookup Using the MATCH Function

285: automatically pasting cell into different sheets?

286: Question on LABEL Range

287: Macro Won't Copy/Paste

288: Find first non-empty cell ranght from column A

289: =IF(Values_Entered???

290: application message

291: Put an autoshape in a cell based on another cells content

292: Copy named range from file list to summary workbook

293: Formuals not working in existing workbooks

294: Need formula for calculating even lots of material based on square feet

295: Help needed for combo box

296: Import data and macro

297: ActiveCell.Formula and IF statement

298: get part of a file name from a cell value for use in a macro

299: Show timesheet time in and out in regular time versus military tim

300: Subtracting one column from another

301: Question

2: MIRR Function sensitivity to Finance Rate

3: Comparing multiple columns in two sheets

4: VBA format date in footer

5: Using a Formula to get Range of Data to an Array

6: Is there any way a macro can be created for various print area selections?

7: Help!

8: Check if a folder exist

9: Need Help soon on how to search through a range

10: macro for copying cells above empty ones

11: Link comment boxes based on different cell values

12: Summing a Column of Variable Length

13: Page Setup from VBA prints half wide

14: curious sheet behaviour

15: (Probably) simple question

16: Auto Open

17: subtotal with median

18: text box with standard text

19: Formula percent complete excluding given text string

20: remove hyperlinks in a worksheet all in the same time

21: Effective rate of Interest and Copounding Interest

22: Finding age from year

23: how to applythe page setup setings to allsheets in afile in excel

24: Calcuate age

25: How can I programatically change the caption on a button?

26: formula help please

27: help with distance array

28: Compare two sets of data

29: strange date format problem

30: Variable VBA Worksheet Name

31: Replacing hilite color

32: Keep macro running overnight?

33: Excel unchecks iteration

34: Alter existing code

35: DATA VALIDATION WITH AUTODATE

36: Excel 2007 "document not saved" when on a network share AND file set as an offline file

37: Save column J only using copy/paste & temporary copy

38: Excel -> Word: Problems copying/pasting shapes

39: Marco vs Lotus Note

40: Compare worksheets

41: IF Function (I Think!)

42: Entering Excel information into MS Word

43: Excel Improvement Suggestion

44: Age Formula

45: Protecting Excel Options-Tabs

46: Worksheet_Deactivate() problem with deleting data

47: Index Match not working

48: Excel Link Updates

49: How to set the Column Header value for list box?

50: Prompt for Value

51: Pulling info from a list

52: how do I print seperate excel tab sheets in duplex

53: repeat macro after time interval

54: Dynamic Web Query

55: Help with a Formula Within a Function Please

56: cell is merged and contains "something"

57: view 100%

58: FIND LAST CELL WITH DATA

59: Please Help! - Class Not Registered

60: ! used in formulas

61: Find last populated cell in a row.

62: Dynamic summation of column

63: Left worksheet function

64: How do you create a complex footer (e.g. title block) in Excel?

65: Excel Freezes

66: Counting Cells

67: Nested with loops

68: Fastest way to enter many formulas

69: Button doesn't work

70: Delete Rows

71: Using formula in code...Part 3!

72: Obvious, but couldn't find this either

73: Number formatting - what's going on?

74: Using a disclaimer in excel

75: access cell values

76: autofill @ intervals

77: Error Handling Problem

78: Changing button appearance on custom toolbar.

79: Closing Files and Reopening them in VBA

80: Exciter: Custom Excel Applications

81: How to stop automatic calculation

82: help with loops in code,

83: special case of sumif

84: sumproduct between date range

85: Filling Blank Cells

86: are there any excel exaples on schedulling on the internet?

87: Ranking a number outside of range's values?

88: Pivot table page field doesn't update

89: Lookup values in a two way table

90: sending email with Outlook using Excel

91: Goal Seek - reference a cell for "To value" field?

92: changing property of a box while using if/then statements

93: Starting another program (again) Maybe TOM

94: Cell shows date, want to email from excel to me as a reminder

95: How do I get the date for the 2nd friday of each month?

96: Add Selected Items

97: Is there a better option than Getobject to access a .xls?

98: COUNTIF problem with Circular Reference

99: Formating column cells

100: calculting stats of column array in 3D array

101: Linking excell with access to choose a single record

102: Can't open file in Excel - 70MB - Options?

103: Can wildcards be used in SUMPRODUCT conditions

104: Functions/Formulas to count multiple variables

105: Converting Numbers To Dates

106: Copying Charts: CODE NOT ROBUST

107: Trigger on leaving cell (of entire column)

108: copying worksheets

109: Can the "Find and Replace" feature be used in Formulas somehow?

110: Excel Cursor

111: how to calcurate work hours? Please?

112: Print a WordArt in a Frontpage

113: NetDDE in Excel 2003

114: calling a batch file

115: Accessing events of com objects

116: Can you create a "flyover"?

117: seperate print and printview

118: Multiple IF factors

119: Programmatically switch off "Variable declaration reqiured" in VBE?

120: Merging workbooks that weren't "shared workbooks"

121: Anybody see anything wrong with this

122: Conditional formatting again

123: Is it possible to protect multiple worksheets at the same time

124: updating data in a pivot tables

125: MS Excel 2003

126: Compare 2 sheets and copy matching data

127: Running a macro from a command line

128: URGENT - Need date format for SaveAs code

129: Hide a series

130: How do I stop the autopaste function in Excel?

131: Many Thanks

132: Need a Formula based on multiple cirteria

133: Lookup by Last Column

134: Page set up across multiple files ? x

135: Many columns

136: searching excel with a form and returning the results

137: Consolidating Sheets into 1 new one.

138: Save exact copy of workbook

139: problem to create a line graph

140: printing without zeros showing in a cell with formulas

141: Search formula

142: Split or copy records n-times as excel scans the value of a colum

143: SQL in VBA to Access a Database and create Report

144: Turning on/off the Hourglass pointer in Excel

145: copy if

146: All Excel files opening in same window

147: combing two if then statements - appreciate any help.

148: Masking numbers

149: Conditional Formatting (Formula)

150: programming excel 97 from .net 2003

151: Excel VBA putting text from textbox into SQL statement

152: Web services??

153: range names

154: PROBLEM

155: Get NT Username

156: Multiple Formulas

157: Creating separate sheets from a list

158: How to create an automatic counter

159: VB to Excel

160: Min but not quite...

161: VBA EXCEL IFSTRING HELP

162: Programming for a Dynamic 'Where' clause

163: how to put quotation mark in each cell of the column

164: Formula for Solver

165: date reminder

166: Creating a new worksheet from another

167: Command Button does not re-set once clicked

168: Combination of left and right justification in a cell?

169: SS#'s lose lose formatting in .csv

170: Array or VB script?

171: Get the row number that matches my value

172: Excel thru Terminal Server

173: How do I undo all Page breaks in Excel

174: Error Message in VB

175: Call a add_in function in excel vba?

176: add end rows after suppressing prior rows

177: Permission to fill in cell when another cell has a value

178: selecting cells

179: Userform Textbox Currency Format Problems

180: Macro in toolbar - how to use forever

181: return a result from multiple conditions.

182: Using INDIRECT to refer to different workbooks

183: Saving a file with VBA that references current file name

184: I sort a column, how can I have all the data skip every other row

185: COUNT

186: Copied Worksheet does not maintain it 's properties

187: Detect Hidden Columns by Formula

188: Adding text in a single column

189: how to make dropdown arrow disappear in vba

190: How to fill cells from User Defined Function?

191: Macro to force Excel to close after a given timeframe of inactivit

192: IF Formula

193: Color in Cells without Showing Up in Print

194: How to stop UDF firing when sheets(n).calculate

195: filter combo box based on another

196: veryhidden sheet make restrictions ?!

197: Changing Worksheet State completely

198: HELP PLEASE

199: Help with this formula please!

200: Returning an array from a function

201: Faceid 2003.

202: Copying cells with the mouse

203: How to do TI83 2-SampTTest (hypothesis testing)?

204: syntax error

205: How find out what object is selected?

206: how to get each smarttag in smarttags in c++ com

207: currency # to full text equivilant

208: find a specific cell from the entire worksheet

209: restricted values that can be entered

210: COUNIFS

211: convert Excell 2007 file back to 2003

212: solver

213: open pdf files with a certain bookmark or page number

214: Is it possible to use some pictures in an IF function?

215: Getting coordinates of an Hyperlink using range get_Top(), get_Lef

216: Hyperlink behaviour when emailing sheet

217: Parameters for Query

218: Proper Syntax for Date Modified?

219: Run all web quiries in a worksheet

220: Can I use a variable to call up another sheet in Excel?

221: Date range selection? Anniversary dates

222: Converting Numbers to Time

223: Trans Excel data in VC

224: problem userform disappears

225: SUMIF and LEFT and Named Ranges

226: ActiveControl

227: Pivot Table Ignore Blanks

228: IS functions

229: Tracer Arrows and Objects Not Showing On Screen, But Do Print

230: add text box values

231: Question on Application/Workbook

232: protection and macros

233: intermittent error - ActiveX component can't create object

234: refer to a cell using a formula?

235: Insert/delete rows

236: Obtaining Multiple Results Using Index/Match Functions

237: help to in setting up a proper Vlookup table and formula

238: Extract Data from Multiple worksheets

239: Max worksheet exent width

240: Data Validation and Name Range

241: run time error #9, subscript out of range

242: finding values from duplicates

243: first derivative?

244: VLOOKUP WITH MACRO

245: update cell only if now() falls in a given date range

246: Calling a button event from a .NEt application

247: A number of auto filters in one sheet? Is it possible?

248: user defined function receiving a range as parameter

249: auto fill text

250: cell pattern depening on cell content

251: Shear and Bending moment diagram using excel.

252: changing colours on stacked bar chart

253: Data Consolidation from many Workbooks to One Workbook

254: Insert Subtotal button

255: Plotting Dates

256: URGENT MACRO REQUIREMENT!

257: delete toolbar on workbook close

258: Adding tool tip to worksheet button

259: How will I do Excel user-defined function to extract letters from string

260: Importing more than 65359 rows of data

261: how do I convert text cells to value

262: Resume on Error?

263: Lookup - Formatting of numbers

264: Linking Worksheets to a Summary Worksheet

265: Formats-Paste special

266: Custom Cell Format

267: How to enter a value in a cell

268: Pivot Table comments

269: Delete an autostart Sub with code

270: Create a macro that finds values then sorts

271: what approach/technology?

272: Programmatically Open Locked VBAProject

273: using a worksheet range to populate a combo box in excel

274: How to find if a string starts with a digit

275: Excel automation from C++ and big numbers

276: Hyperlinks from one excel sheet to another in VBA

277: CommandBars vs CommandBars(1).Controls

278: Show Top 3 Values

279: Looking for a better way - Serial to local machine number

280: Calculation

281: Format is lost when number changed to text

282: running code when vba project is opened

283: hyperlink

284: Double and Multiple Lookup Using the MATCH Function

285: automatically pasting cell into different sheets?

286: Question on LABEL Range

287: Macro Won't Copy/Paste

288: Find first non-empty cell ranght from column A

289: =IF(Values_Entered???

290: application message

291: Put an autoshape in a cell based on another cells content

292: Copy named range from file list to summary workbook

293: Formuals not working in existing workbooks

294: Need formula for calculating even lots of material based on square feet

295: Help needed for combo box

296: Import data and macro

297: ActiveCell.Formula and IF statement

298: get part of a file name from a cell value for use in a macro

299: Show timesheet time in and out in regular time versus military tim

300: Subtracting one column from another

301: Question