Page 370

view full version: back to formated view

1: number < 0 = 0

2: Convert Column letter to number

3: Automating a printing of pages that are Hyperlinked to external so

4: Using text files

5: Array to Range assignments behave different going horizontally and vertically

6: hidden rows/columns

7: selecting a cell relative to activecell in an excel macro

8: Sort row values descending

9: what is the R1C1-style notation in Macro Language?

10: Need some help in re-organising data from external source

11: WorkSheet reference

12: Basic Question of Excel

13: Filename cannot be accessed

14: Excel Formula Logic Problem,

15: FileDialog Question

16: Conditional macro to hide rows

17: Check Box to call Macro

18: if function

19: SELECT UNIQUE some_column FROM MAILMERGE.DATASOURCE

20: If A3=alpha numeric,"X", if A3=text,"Y", Blank

21: What is an Excel 2.1 Worksheet?

22: Excel VBA Sumproduct

23: Finding number of empty cells

24: Recognize ALT key Pressed

25: Scenario?

26: How to pull numbers from two tables with conditions?

27: Extracting Info From Cells

28: dialogue box problem

29: merging sheets

30: Copy range from closed file

31: 2003 - 2007 custom macro and custom button restore.

32: Sumif???

33: Copy down formula

34: Determining new category number

35: Excel Macro icon

36: SUMPRODUCT - How can I use does not equal in an array?

37: Replacing COUNTIFS with COUNTIF

38: Date values Problem

39: Using Macro to Sort Names, Numbers & addresses

40: Fixed Length Text fields

41: Saving Excel Sql Server Image Field

42: Extracting A Portion Of A String

43: run macro automatically

44: Master spread sheet to manage then show info on seperate tabs

45: Macro Help

46: Requesting file names

47: Find Value in Hidden Cells

48: Date Problem in VBA

49: Referring to other worksheets...

50: onditional Formating - Question

51: our website provid Power-leveling service | http://www.wowmmocom.com

52: If Statement help

53: Using Application.quit is causing my macro to run and print twice...

54: filter by color or highlight

55: lbs ounces grams

56: If, then: to run macro

57: Cell value change to trigger macro (worksheet change event?)

58: Dating Problem

59: formatting question

60: Macro help

61: SUM or COUNT and adding a row

62: finding text in a cell

63: Excel alphanumberic sort

64: store SHAPE-Object on disk

65: Save Method

66: Cannot modify formula

67: Complex conditional formatting

68: many workbooks in one.

69: Can I stop Excel from seeing more than 2 digits after decimal?

70: Row Number

71: number increase by 1

72: not sure what functions/code to use?

73: Automatically e-mailing a sheet

74: Microsoft Query Tool Bar

75: Community versus Newsgroup

76: Right-Click not working in Excel 2007. Works in other Office 07 pr

77: Rounding

78: Delete Temporary Internet Files with VBA

79: Make field Fixed lenght

80: variance array

81: VBA code to locate the command bar number the printer button is on

82: Not able to Paste into other cells

83: =?Utf-8?Q?Conditional_Formatting_=E2=80=93_shade_a?=

84: prevent copied blank cells from replacing existing data

85: listbox please help

86: Well, how empty is it?

87: Spreadsheet Risks Group - call for papers, & conference 15/16 July 2004.

88: CheckBoxes Stack up when Rows are hidden and unhidden

89: Adding all data types from every n'th column

90: Limit on Range Object

91: How to add only certain rows in a spreadsheet

92: Date formatting

93: French Vs English

94: Macro to prevent adding sheet in a workbook.

95: Updating numerous Pivot Tables in a Workbook

96: password problem

97: How to add word to end of multiple words?

98: Enabling outline and level functions on a protected worksheet?

99: Identify last row of populated data

100: Locking certain cells..

101: Error File / Renaming

102: Wierd conditional formatting result (oops pressed send to soon!)

103: Chart Scaling

104: Trouble With MacroOptions

105: How to link a drop down menu to another one?

106: macro+email help

107: Ranking from multiple columns

108: Filtering out dates using autofilter

109: User defined event

110: Combo box control Drop down list moving

111: sorting with a blank column

112: cell fill color not showing

113: Consoldating Data

114: Publishing VBA Functions

115: new filtering problem

116: XL 97 Text Box property - WordWrap

117: Excluding 0s and blanks from a LINEST function

118: before print event not working

119: unprotect control button only in spreadsheet

120: calling an Excel Add-in application

121: maturity schedule fixed inc securities by month, quarter and year

122: Paste problems!!!!!!

123: Activate Menu Items

124: Enter a constant into Ten Workbooks

125: copy sheets to workbook and save as sheet name

126: Formulas Are Displayed and are not calculating

127: Hyperlinks unable to open

128: Microsoft Excel cannot find data you are searching for

129: Pivot Tables

130: Re: Excel2003 use fnct/conditnl fmt, copy color&Val from ref cell

131: easy to crack vba password

132: how do i paste a range?

133: statistic using excel data pls help!!!!!

134: MI5 Persecution: Do they fear truth? 3/10/95 (4011)

135: How to put values instead of formulas into matrix?

136: Rows adjusting to fit amount of data?

137: Next number function

138: date formula

139: Cell Word Alphabetization

140: INNER JOIN problem

141: average and stdev

142: Macro works in one workbook but not in another

143: Tournament Schedulizer?

144: copy-->paste-->special "formula" for a whole column

145: Having a macro interact with a dialog box.

146: Conditional Formatting Formula Help Part 2

147: Adding current date and contents of a cell in the footer

148: how to calculate mileledge

149: Controlling Access from Excel

150: Trouble opening second notebook

151: sorting

152: Sorting rows programmatically

153: dms converter

154: Ignoring Message

155: Using autofilter and excel form format

156: How do I Freeze information to keep from updating

157: Cannot set ColumnWidth past column 148

158: SUM PRODUCT Function

159: send msg same as netsend

160: "Magic" Formula

161: filtering 2 Excel sheets

162: Opening all linked workbooks

163: Chart titles

164: Vlookup With A Twist

165: Print selected sheets in Excel

166: Character codes

167: Merging different quantites of labels based on Excel data

168: Form Question

169: how do I log events

170: Collaborating in real time

171: Running Excel 2000 VBA Application on Excel 2003

172: how do I write a formula that will figure weekly overtime?

173: Can't Freeze Pane in Excel, it's grayed out.

174: Runtime Error 6 Overflow

175: Code question for clearing a command checkbox.

176: class modules and array

177: Comments get out of alinement

178: Pasting cells to Second Sheet

179: Force macro security warning to be displayed

180: VBA Query again Informix database

181: Print / Write to text file and usage of buttons

182: Running a Macro automatically

183: How can I make an excel cell equal to the value of a frame object text box

184: Need macros in file to be available, but don't want file to open

185: Specifying adjacent formulae for a QueryTable AutoRefresh's FillAdjacentFormulas

186: Finding a formula

187: Data Validation

188: Please Help me

189: No refresh in copied cell

190: Problem when input Chinese in Excel 2003

191: Hyperlink to Word Doc

192: Pivot Table Problem

193: MVP help please - dynamic pathname in ODBC arrays

194: how to delete the 4 rightmost digits from a cell

195: Auto Filter problem

196: How do I get the coordinates of the active cell in Excel?

197: Minimum Value

198: Excel, error:" too many cells format"

199: pivottables

200: How do I GetCurrentDirectory in Excel?

201: Automatically changing stock tick quotes to decimal-price format.

202: MIME multiple Excel spreadsheets

203: VBA Match Equivalent

204: Drop-down list box arrow

205: Can I drag a validated cell down the column w/a different input/ro

206: Ignore Blanks

207: How do I insert page numbers in many work sheets in excel?

208: cell values

209: search for matching numbers in 2 columns

210: Trouble with Excel Charts

211: Auto insert Unit of Measure

212: Pivot Output formatting.

213: coded concatenating is not working

214: Analyze total

215: Random generator question

216: Problem executin macro from a different workbook where it is

217: Converting Standard Time into Military Time

218: I'm trying to import fields from one Excel file to another

219: autosend for excel worksheets for distribution list option

220: Help with Birth Dates

221: Compiling vba code as stand alone exe

222: FINANCIAL FUNCTIONS

223: Help with CreateObject

224: Excel 2003; Open & Disable macros

225: Exclude Hidden Rows When Copying

226: Userform + listbox question

227: variables in footers

228: Yes/no check box field in a spreadsheet?

229: Dynamic macro parameters

230: Fresh pair of Eyes required

231: Determining End User Actions

232: How do I keep a formula from changing if a row is added or delete.

233: hyperlinks-changing the filename only!

234: Why is this happening?

235: Is this possible?

236: Macro Formula

237: NEED HELP! - Excel Object Model & .Net Compact Framework

238: Caculating A.P.R.

239: Letters = Numbers

240: Adding workdays

241: Control or VBA programming a button

242: Highlight duplicate data

243: how to get vba to display excel 2002+ "Find & Replace" dialog

244: Excel and Pivot Tables

245: Requesting virus scan

246: Won't accept password to unprotect

247: Active X frame on worksheet

248: User Defined Function

249: Problems with setting values in a listbox

250: Macro Time stamp Help

251: Unique adding of cell from .csv to .xsl????anyone?

252: LOOKUP function

253: How to find specific subfolders

254: Automatically update links in Excel 2003 after inserting rows in .

255: execute a .exe file and type a text string by vba on it

256: How to hide a column once any cell of that col. is not active any

257: Excel Worksheet Printing

258: Textbox questions

259: Comparing two spreadsheets

260: Load Windows Explorer

261: Not Sure on Function

262: =?Utf-8?Q?H=C3=A4mta_uppgifter_fr=C3=A5n_flera_dokum?=

263: This is not working because I didn't write it correctly

264: finding what numbers are in a string

265: Auto Open won't die or go away

266: auto execute

267: Draw Buttons

268: Free books on Charting, Basics, Data Management, Functions; Free Add-In "Excel Usability Enhancer"

269: Convert Lbs to Stones and Lbs

270: Wait opening file

271: Excel/Access ODBC

272: Vlookup returns line number

273: many-to-one relationship

274: Saving an excel worksheet without closing all worksheets

275: Adding time

276: Using formulas to determine date in one cell based on date in anot

277: payroll calculation

278: protect/unprotect a VBA Project

279: Printing to 2 "columns area"

280: tote programme

281: Can somebody tell me what cause the mistake?

282: Automatic date entry upon cell completion

283: Select cells after Autofilter

284: data manipulation question

285: Getting a type-mismatch no matter what I do.

286: Follow up on this

287: auto enter date in cell on data entry in row

288: Help

289: Encryption via WinZip

290: Error handler that does not end macro

291: input

292: VBA code question?

293: Custom formatting for text cells

294: Copy paste

295: #NAME? Error on Entire Worksheet

296: why stepping thru works differently module vs. worksheet

297: Inserting rows from a command button

298: How do I add a variable to watch in hex?

299: how do I programatically edit formulae in MS Excel?

300: Count Part Numbers

301: Exchange rate calculation

2: Convert Column letter to number

3: Automating a printing of pages that are Hyperlinked to external so

4: Using text files

5: Array to Range assignments behave different going horizontally and vertically

6: hidden rows/columns

7: selecting a cell relative to activecell in an excel macro

8: Sort row values descending

9: what is the R1C1-style notation in Macro Language?

10: Need some help in re-organising data from external source

11: WorkSheet reference

12: Basic Question of Excel

13: Filename cannot be accessed

14: Excel Formula Logic Problem,

15: FileDialog Question

16: Conditional macro to hide rows

17: Check Box to call Macro

18: if function

19: SELECT UNIQUE some_column FROM MAILMERGE.DATASOURCE

20: If A3=alpha numeric,"X", if A3=text,"Y", Blank

21: What is an Excel 2.1 Worksheet?

22: Excel VBA Sumproduct

23: Finding number of empty cells

24: Recognize ALT key Pressed

25: Scenario?

26: How to pull numbers from two tables with conditions?

27: Extracting Info From Cells

28: dialogue box problem

29: merging sheets

30: Copy range from closed file

31: 2003 - 2007 custom macro and custom button restore.

32: Sumif???

33: Copy down formula

34: Determining new category number

35: Excel Macro icon

36: SUMPRODUCT - How can I use does not equal in an array?

37: Replacing COUNTIFS with COUNTIF

38: Date values Problem

39: Using Macro to Sort Names, Numbers & addresses

40: Fixed Length Text fields

41: Saving Excel Sql Server Image Field

42: Extracting A Portion Of A String

43: run macro automatically

44: Master spread sheet to manage then show info on seperate tabs

45: Macro Help

46: Requesting file names

47: Find Value in Hidden Cells

48: Date Problem in VBA

49: Referring to other worksheets...

50: onditional Formating - Question

51: our website provid Power-leveling service | http://www.wowmmocom.com

52: If Statement help

53: Using Application.quit is causing my macro to run and print twice...

54: filter by color or highlight

55: lbs ounces grams

56: If, then: to run macro

57: Cell value change to trigger macro (worksheet change event?)

58: Dating Problem

59: formatting question

60: Macro help

61: SUM or COUNT and adding a row

62: finding text in a cell

63: Excel alphanumberic sort

64: store SHAPE-Object on disk

65: Save Method

66: Cannot modify formula

67: Complex conditional formatting

68: many workbooks in one.

69: Can I stop Excel from seeing more than 2 digits after decimal?

70: Row Number

71: number increase by 1

72: not sure what functions/code to use?

73: Automatically e-mailing a sheet

74: Microsoft Query Tool Bar

75: Community versus Newsgroup

76: Right-Click not working in Excel 2007. Works in other Office 07 pr

77: Rounding

78: Delete Temporary Internet Files with VBA

79: Make field Fixed lenght

80: variance array

81: VBA code to locate the command bar number the printer button is on

82: Not able to Paste into other cells

83: =?Utf-8?Q?Conditional_Formatting_=E2=80=93_shade_a?=

84: prevent copied blank cells from replacing existing data

85: listbox please help

86: Well, how empty is it?

87: Spreadsheet Risks Group - call for papers, & conference 15/16 July 2004.

88: CheckBoxes Stack up when Rows are hidden and unhidden

89: Adding all data types from every n'th column

90: Limit on Range Object

91: How to add only certain rows in a spreadsheet

92: Date formatting

93: French Vs English

94: Macro to prevent adding sheet in a workbook.

95: Updating numerous Pivot Tables in a Workbook

96: password problem

97: How to add word to end of multiple words?

98: Enabling outline and level functions on a protected worksheet?

99: Identify last row of populated data

100: Locking certain cells..

101: Error File / Renaming

102: Wierd conditional formatting result (oops pressed send to soon!)

103: Chart Scaling

104: Trouble With MacroOptions

105: How to link a drop down menu to another one?

106: macro+email help

107: Ranking from multiple columns

108: Filtering out dates using autofilter

109: User defined event

110: Combo box control Drop down list moving

111: sorting with a blank column

112: cell fill color not showing

113: Consoldating Data

114: Publishing VBA Functions

115: new filtering problem

116: XL 97 Text Box property - WordWrap

117: Excluding 0s and blanks from a LINEST function

118: before print event not working

119: unprotect control button only in spreadsheet

120: calling an Excel Add-in application

121: maturity schedule fixed inc securities by month, quarter and year

122: Paste problems!!!!!!

123: Activate Menu Items

124: Enter a constant into Ten Workbooks

125: copy sheets to workbook and save as sheet name

126: Formulas Are Displayed and are not calculating

127: Hyperlinks unable to open

128: Microsoft Excel cannot find data you are searching for

129: Pivot Tables

130: Re: Excel2003 use fnct/conditnl fmt, copy color&Val from ref cell

131: easy to crack vba password

132: how do i paste a range?

133: statistic using excel data pls help!!!!!

134: MI5 Persecution: Do they fear truth? 3/10/95 (4011)

135: How to put values instead of formulas into matrix?

136: Rows adjusting to fit amount of data?

137: Next number function

138: date formula

139: Cell Word Alphabetization

140: INNER JOIN problem

141: average and stdev

142: Macro works in one workbook but not in another

143: Tournament Schedulizer?

144: copy-->paste-->special "formula" for a whole column

145: Having a macro interact with a dialog box.

146: Conditional Formatting Formula Help Part 2

147: Adding current date and contents of a cell in the footer

148: how to calculate mileledge

149: Controlling Access from Excel

150: Trouble opening second notebook

151: sorting

152: Sorting rows programmatically

153: dms converter

154: Ignoring Message

155: Using autofilter and excel form format

156: How do I Freeze information to keep from updating

157: Cannot set ColumnWidth past column 148

158: SUM PRODUCT Function

159: send msg same as netsend

160: "Magic" Formula

161: filtering 2 Excel sheets

162: Opening all linked workbooks

163: Chart titles

164: Vlookup With A Twist

165: Print selected sheets in Excel

166: Character codes

167: Merging different quantites of labels based on Excel data

168: Form Question

169: how do I log events

170: Collaborating in real time

171: Running Excel 2000 VBA Application on Excel 2003

172: how do I write a formula that will figure weekly overtime?

173: Can't Freeze Pane in Excel, it's grayed out.

174: Runtime Error 6 Overflow

175: Code question for clearing a command checkbox.

176: class modules and array

177: Comments get out of alinement

178: Pasting cells to Second Sheet

179: Force macro security warning to be displayed

180: VBA Query again Informix database

181: Print / Write to text file and usage of buttons

182: Running a Macro automatically

183: How can I make an excel cell equal to the value of a frame object text box

184: Need macros in file to be available, but don't want file to open

185: Specifying adjacent formulae for a QueryTable AutoRefresh's FillAdjacentFormulas

186: Finding a formula

187: Data Validation

188: Please Help me

189: No refresh in copied cell

190: Problem when input Chinese in Excel 2003

191: Hyperlink to Word Doc

192: Pivot Table Problem

193: MVP help please - dynamic pathname in ODBC arrays

194: how to delete the 4 rightmost digits from a cell

195: Auto Filter problem

196: How do I get the coordinates of the active cell in Excel?

197: Minimum Value

198: Excel, error:" too many cells format"

199: pivottables

200: How do I GetCurrentDirectory in Excel?

201: Automatically changing stock tick quotes to decimal-price format.

202: MIME multiple Excel spreadsheets

203: VBA Match Equivalent

204: Drop-down list box arrow

205: Can I drag a validated cell down the column w/a different input/ro

206: Ignore Blanks

207: How do I insert page numbers in many work sheets in excel?

208: cell values

209: search for matching numbers in 2 columns

210: Trouble with Excel Charts

211: Auto insert Unit of Measure

212: Pivot Output formatting.

213: coded concatenating is not working

214: Analyze total

215: Random generator question

216: Problem executin macro from a different workbook where it is

217: Converting Standard Time into Military Time

218: I'm trying to import fields from one Excel file to another

219: autosend for excel worksheets for distribution list option

220: Help with Birth Dates

221: Compiling vba code as stand alone exe

222: FINANCIAL FUNCTIONS

223: Help with CreateObject

224: Excel 2003; Open & Disable macros

225: Exclude Hidden Rows When Copying

226: Userform + listbox question

227: variables in footers

228: Yes/no check box field in a spreadsheet?

229: Dynamic macro parameters

230: Fresh pair of Eyes required

231: Determining End User Actions

232: How do I keep a formula from changing if a row is added or delete.

233: hyperlinks-changing the filename only!

234: Why is this happening?

235: Is this possible?

236: Macro Formula

237: NEED HELP! - Excel Object Model & .Net Compact Framework

238: Caculating A.P.R.

239: Letters = Numbers

240: Adding workdays

241: Control or VBA programming a button

242: Highlight duplicate data

243: how to get vba to display excel 2002+ "Find & Replace" dialog

244: Excel and Pivot Tables

245: Requesting virus scan

246: Won't accept password to unprotect

247: Active X frame on worksheet

248: User Defined Function

249: Problems with setting values in a listbox

250: Macro Time stamp Help

251: Unique adding of cell from .csv to .xsl????anyone?

252: LOOKUP function

253: How to find specific subfolders

254: Automatically update links in Excel 2003 after inserting rows in .

255: execute a .exe file and type a text string by vba on it

256: How to hide a column once any cell of that col. is not active any

257: Excel Worksheet Printing

258: Textbox questions

259: Comparing two spreadsheets

260: Load Windows Explorer

261: Not Sure on Function

262: =?Utf-8?Q?H=C3=A4mta_uppgifter_fr=C3=A5n_flera_dokum?=

263: This is not working because I didn't write it correctly

264: finding what numbers are in a string

265: Auto Open won't die or go away

266: auto execute

267: Draw Buttons

268: Free books on Charting, Basics, Data Management, Functions; Free Add-In "Excel Usability Enhancer"

269: Convert Lbs to Stones and Lbs

270: Wait opening file

271: Excel/Access ODBC

272: Vlookup returns line number

273: many-to-one relationship

274: Saving an excel worksheet without closing all worksheets

275: Adding time

276: Using formulas to determine date in one cell based on date in anot

277: payroll calculation

278: protect/unprotect a VBA Project

279: Printing to 2 "columns area"

280: tote programme

281: Can somebody tell me what cause the mistake?

282: Automatic date entry upon cell completion

283: Select cells after Autofilter

284: data manipulation question

285: Getting a type-mismatch no matter what I do.

286: Follow up on this

287: auto enter date in cell on data entry in row

288: Help

289: Encryption via WinZip

290: Error handler that does not end macro

291: input

292: VBA code question?

293: Custom formatting for text cells

294: Copy paste

295: #NAME? Error on Entire Worksheet

296: why stepping thru works differently module vs. worksheet

297: Inserting rows from a command button

298: How do I add a variable to watch in hex?

299: how do I programatically edit formulae in MS Excel?

300: Count Part Numbers

301: Exchange rate calculation