Page 448

view full version: back to formated view

1: Sort Help for Excel

2: identifying odd/even numbers

3: Converting NOW contents to TIME

4: Using found variant within code

5: Conditional formatting

6: Change Default Add-in Folder

7: My code does not run on another computer

8: Trying to match fields and return a value

9: Compare and Return Value

10: Problem with protecting sheet

11: UserForm-Code Problem

12: Need some help writing code.

13: Functions for manipulating arrays

14: Button won't call macro

15: Create a formula that contains a complex embedded IF statement

16: Selecting Cells

17: Function to detect if Sheet is protected

18: Link Error

19: Pyramid diagrams - like food pyramid - How can it be done?

20: mouse move event

21: Find negative numbers

22: *** Urgent help formula * Need to sum values in a column if all ..

23: Oracle database login

24: Sorting algorithms used in Excel

25: Any wrong with this?

26: insert a table in excel

27: Runtime Error '1004'

28: sending email from excel 97

29: Removal of broken Hyperlinks from data copiedfrom a web page in to an Excel Spreadsheet

30: Increment Alpha Numeric Cell

31: How to pass FieldInfo parameter to Workbooks::OpenText(...) in VC+

32: Logging username, date and time

33: RTD Links, how to start and stop them

34: generating sheet with command button & code

35: Help with SUMIF

36: Excellent website for Microsoft professionals

37: Reference Table

38: Lost the small taskbar that shows Cell functions...

39: Deleting VBA programs

40: not able to create subtotal summary report

41: Store max value of changing cell

42: Cleaning some blob data

43: Problem with MID (any text) Command

44: can VBA be used to sound a *.wav file on condition(s)?

45: FormulaArray alternative for A1 reference style?

46: Using Web Queries -- unusual problem

47: Shared workbook

48: Copying between worksheets using a Lookup?

49: Special Lookup Formula

50: last try - do until range

51: Need Macro To Close Excel Application

52: ms097.dll

53: How can I display a number as a ratio of x:1 in Excel?

54: Conditional Formats to ignore blank cells

55: How to combine a couple cells into a BIGGER cell before saving as a DBF file?

56: toolbuttons and macros in excel 2007

57: window size/scroll

58: html help and custom msgbox

59: Share workbook

60: countif function

61: Matching Values

62: macro pauses

63: How can I set up a shortcut key for Autosum?

64: how to repeat text on sheets in excel

65: Populate A Userform ComboBox

66: Lookup/index/match function

67: Toggle Borders

68: Dates Formats in Pivot Table Help

69: Using Excel with Peachtree Accounting

70: Extract Informations inside a Borderframe

71: Licence help wanted

72: Gathering Comments from Survey Data

73: Find all then paste not working.

74: run time error 1004

75: how do you use vlookup to compare values between two workbooks

76: Difference between sheets and worksheets?

77: Re: Combining multiple Excel files into one html?

78: Run macro when cell contents change

79: Cycle through images on UserForm

80: Watermarks??

81: Error message for Imporint External Data

82: all the messages in the thread

83: Rename Workbook and Macro Dies!! HELP!!

84: Pasting into cell or comment

85: String criteria in DCOUNT function

86: Conditional formula miscalculating blank cells

87: Can Excel 2007 link with Outlook 2007

88: Converting hours, minutes, seconds, to hours

89: Combobox & locked cells

90: grab max date from list

91: new to VBA...Winsock DataArrival event not getting fired.

92: How to use Drop down list to reflect a set of fields to be filled?

93: Names of Columns

94: Numeric to text conversion

95: Hot to calculate montly slope?

96: import data without query

97: Before_Save IS KILLING ME

98: OLE and excel on Windows 2003 server

99: how to run a macro when a calculation equals a certin number

100: Multi line Select Query

101: Shortcut Attributes

102: Switchiing off On-line help

103: Automatic saving

104: Harlan - or anybody good at math

105: Format Cells Dialog Box won't display!

106: Using Find or search for Cells with <3 Characters?

107: Mail Merge - Creating a directory

108: exporting from sql query results to a excel workbook

109: VBA for Consolidated Worsheet

110: Deactive Activate Workbook Events - Add Menu

111: Adding Dashes to a 25 digit alphanumeric cell

112: Cell entry forces form pop-up

113: Open a webpage using Javascript in Excel

114: Worksheet_Change

115: Excel Worksheet not fetching values using vb.net

116: counta in vba

117: How to get file's current directory path to a string in VBA?

118: How to reference a column heading in a cell automatically?

119: Compare Two Lists

120: Deleting a row of data based upon the value in column D

121: visual basic

122: disappearing tab

123: Copying and Pasting Formula

124: Help with tabs

125: time elapsed formula

126: Creating a Custom commandbar button

127: Another protect proble.

128: How to convert numbers to words?

129: data across two different spreadsheets

130: opening files with vba

131: IF Function

132: Search macro adjustment

133: CodePane

134: Msgbox not ok

135: Font Size Problems with ComboBox

136: Excel 2003: Match one list against another and highlight differenc

137: RTD Throttleinterval. How do you change it?

138: Excel formulas and the relevance of this >>> {

139: Sum if or some sort of match formula

140: using odbc in excel

141: referencing worksheet names in a cell

142: Digital Certificate

143: Auto_open from Worksheet Object Code

144: how do i freeze a vertical column & horizontal row in excel?

145: unwanted spaces in mail merge docs

146: Creating table from cell contents

147: SUMPRODUCT

148: How do I copy every 8th cell in a column

149: SolverSolve userFinish:=True still displays the dialogue

150: Auto Updating List

151: centering cells

152: Day of the Week from Date

153: open Goldmine email msg from Excel VBA

154: IF and HLOOKUP Formula

155: Maximum number of sheet for one spreadsheet

156: Can I rounddown a cell result from millions to thousands

157: Getting data from a closed workbook to a master record

158: Creating Formula with Embedded Variable ID

159: return text

160: NEED MACRO OR FORMULA

161: spell check in excel 2007

162: Format a rangeafter usining a userform

163: Autocopy between 2 workbooks

164: How to change #lines in Immediate Window

165: Extracting information from table

166: Stutter in AdvancedFilter Unique Results?

167: Limited amount of cells in a formula

168: Using Rank in an Array Formula

169: have Excel retrieve conditional operator ( < > = ) from a cell

170: Need help with VBA

171: Using variable addresses in vba

172: Userform Control Error

173: how can I hide macro list from user?

174: Clickable Cell Area

175: keeping track of stock moving from one location to another

176: formula forming Q for Formula One :-D

177: find the matching and allocate the required quantity

178: Why does my shared spreadsheet have formula errors?

179: VBA Validation - textbox must not be blank

180: Table sorting questions

181: VBA macro to delete rows that contain text

182: Combining Msg Box and Data

183: Count the number of worksheets in a workbook

184: How to select the bottom right cel in a 'CurrentRegion.selecion'

185: copy one sheet to other excel workbook

186: VBA code does not work in Excel 2003

187: Comma's btw numbers

188: Background color for 50,000 odd-numbered rows

189: Code Execution Has Been Interruptred?

190: Pop up message

191: Problem with Analysis ToolPak Add-in

192: Working with =IF(ISNA,(myformula),0,(myformula)

193: Nested IF and Countif ?

194: I'm just starting to play around with VB and would like some help.

195: An Address Mess!

196: conditional query

197: formula bar

198: Sum range of cells with VBA

199: need some help with: formatting of x2 dates in 1 cell

200: Paste a sub-table from a larger table

201: VBA - change textformat after a linefeed

202: Accessing the values of form controls on worksheets in Excel 2000

203: Search actual Formula for cell ref?

204: Formatting copied cells

205: Make multiple new sheets at the same time?

206: <IF> Calculated Field in Pivot

207: Adding values in columns with a specific indicator

208: Hyperlink or shortcut?

209: Change the 'Read-Only' Access for Non-Shared Files

210: Adding columns past the 256 limit

211: I need to change this code to copy All files the "customdoc" folde

212: Macro code

213: re : Save As

214: help with arrays

215: SUMIF function question

216: Printing a range that is determined at run time

217: Screen flicker when changing Image.Picture source on UserForm

218: program a cell in excell to reference a cell below a referenced ce

219: Excel 2003 default file location

220: Coments

221: Replace (') to space

222: Creating hangman(word game) on MS Excel

223: Constant growth

224: Macro Help

225: Building an application on top of Excel

226: Max size of variable?

227: HELP!!! How to Nest AND OR functions

228: Opening a Single Excel File in Different Custom Views Via Hyperlinks

229: Formules doorkopiëren

230: How do I output a formula into a cell and then autofill using vb?

231: How to check Excel file already Open

232: How come my macro works if I pause and play again?

233: can I replace all with a macro?

234: export a form

235: actual month

236: Help about If

237: Extracting File Names and Properties

238: Counting Strings in an Array

239: I am stupid and don't know what the heck I am doing wrong on this pivot table!!!

240: AddinInstall + Delete custom CommandBar Menu

241: Printing to PDF format using CutePDF Writer in VBA

242: creating a search model

243: Migrating from Excel 2000 to Excel 2003

244: Problem with Formatting Textboxes

245: Excel---Copying text from one cell a a sheet to another cell on a

246: Weekly reg/ot formula help please!

247: Populate an order form with Data

248: How to change negative to positive

249: Excel VBA- Error Accessing the system registry

250: Creating a Survey in Excel/Word

251: how to save fixed format text file

252: SIMPLE ?

253: Array error in subtotal method

254: How To: create a form for a user to enter data

255: adding shortcut menu items

256: Excel 07 filter

257: comparing columns from different sheets

258: Conditional Formatting-No Formulas

259: I have 1 master excel file & want to rec. data from 7 other files

260: help with ranges

261: Photos in cells?

262: modify how files are displyed in the "file open" window

263: Database summary

264: Excel; vba; listbox how to reorganize list in alfabetical order

265: Customized Changes to Toolbars

266: Paste special

267: How do I write a VBA for 3 consecutive dates?

268: Count Instances of value in two columns

269: Unifying different date formats in a spreadsheet

270: How to get a conditional argument to check all cells in a array?

271: Number of years, months, days between two dates.

272: Connect columns, with restrictions

273: Working with huge cells

274: copy data if data exists

275: matching/comparing lists

276: Formula for calculating 12 month rolling period

277: Code fails if ran more than once

278: hide PERSONAL.XLS

279: was working, now :(

280: How do import banking statements into excel?

281: Count Unique Numbers

282: Add hours to date

283: Formula Help required

284: Web Queries

285: dates and times, tracking using

286: Textbox edit

287: Excel data merged to PDF form

288: Thanks !!!

289: Text on shapes

290: 4 different if statements, not working

291: General ?? regarding Macro or Module size in a spreadsheet

292: sumproduct with dates

293: if isna and vlookup together

294: Coding in VLOOKUP function

295: Help with lookup or if functions

296: File protection / Sharing / Conflicts

297: Does Excel have a linear interpolation function?

298: webquery with login first

299: plotting chart with user selected range from current workbook

300: Prevent Excel from going online when opening html file

301: Inserting something at the begining of evrey cell

2: identifying odd/even numbers

3: Converting NOW contents to TIME

4: Using found variant within code

5: Conditional formatting

6: Change Default Add-in Folder

7: My code does not run on another computer

8: Trying to match fields and return a value

9: Compare and Return Value

10: Problem with protecting sheet

11: UserForm-Code Problem

12: Need some help writing code.

13: Functions for manipulating arrays

14: Button won't call macro

15: Create a formula that contains a complex embedded IF statement

16: Selecting Cells

17: Function to detect if Sheet is protected

18: Link Error

19: Pyramid diagrams - like food pyramid - How can it be done?

20: mouse move event

21: Find negative numbers

22: *** Urgent help formula * Need to sum values in a column if all ..

23: Oracle database login

24: Sorting algorithms used in Excel

25: Any wrong with this?

26: insert a table in excel

27: Runtime Error '1004'

28: sending email from excel 97

29: Removal of broken Hyperlinks from data copiedfrom a web page in to an Excel Spreadsheet

30: Increment Alpha Numeric Cell

31: How to pass FieldInfo parameter to Workbooks::OpenText(...) in VC+

32: Logging username, date and time

33: RTD Links, how to start and stop them

34: generating sheet with command button & code

35: Help with SUMIF

36: Excellent website for Microsoft professionals

37: Reference Table

38: Lost the small taskbar that shows Cell functions...

39: Deleting VBA programs

40: not able to create subtotal summary report

41: Store max value of changing cell

42: Cleaning some blob data

43: Problem with MID (any text) Command

44: can VBA be used to sound a *.wav file on condition(s)?

45: FormulaArray alternative for A1 reference style?

46: Using Web Queries -- unusual problem

47: Shared workbook

48: Copying between worksheets using a Lookup?

49: Special Lookup Formula

50: last try - do until range

51: Need Macro To Close Excel Application

52: ms097.dll

53: How can I display a number as a ratio of x:1 in Excel?

54: Conditional Formats to ignore blank cells

55: How to combine a couple cells into a BIGGER cell before saving as a DBF file?

56: toolbuttons and macros in excel 2007

57: window size/scroll

58: html help and custom msgbox

59: Share workbook

60: countif function

61: Matching Values

62: macro pauses

63: How can I set up a shortcut key for Autosum?

64: how to repeat text on sheets in excel

65: Populate A Userform ComboBox

66: Lookup/index/match function

67: Toggle Borders

68: Dates Formats in Pivot Table Help

69: Using Excel with Peachtree Accounting

70: Extract Informations inside a Borderframe

71: Licence help wanted

72: Gathering Comments from Survey Data

73: Find all then paste not working.

74: run time error 1004

75: how do you use vlookup to compare values between two workbooks

76: Difference between sheets and worksheets?

77: Re: Combining multiple Excel files into one html?

78: Run macro when cell contents change

79: Cycle through images on UserForm

80: Watermarks??

81: Error message for Imporint External Data

82: all the messages in the thread

83: Rename Workbook and Macro Dies!! HELP!!

84: Pasting into cell or comment

85: String criteria in DCOUNT function

86: Conditional formula miscalculating blank cells

87: Can Excel 2007 link with Outlook 2007

88: Converting hours, minutes, seconds, to hours

89: Combobox & locked cells

90: grab max date from list

91: new to VBA...Winsock DataArrival event not getting fired.

92: How to use Drop down list to reflect a set of fields to be filled?

93: Names of Columns

94: Numeric to text conversion

95: Hot to calculate montly slope?

96: import data without query

97: Before_Save IS KILLING ME

98: OLE and excel on Windows 2003 server

99: how to run a macro when a calculation equals a certin number

100: Multi line Select Query

101: Shortcut Attributes

102: Switchiing off On-line help

103: Automatic saving

104: Harlan - or anybody good at math

105: Format Cells Dialog Box won't display!

106: Using Find or search for Cells with <3 Characters?

107: Mail Merge - Creating a directory

108: exporting from sql query results to a excel workbook

109: VBA for Consolidated Worsheet

110: Deactive Activate Workbook Events - Add Menu

111: Adding Dashes to a 25 digit alphanumeric cell

112: Cell entry forces form pop-up

113: Open a webpage using Javascript in Excel

114: Worksheet_Change

115: Excel Worksheet not fetching values using vb.net

116: counta in vba

117: How to get file's current directory path to a string in VBA?

118: How to reference a column heading in a cell automatically?

119: Compare Two Lists

120: Deleting a row of data based upon the value in column D

121: visual basic

122: disappearing tab

123: Copying and Pasting Formula

124: Help with tabs

125: time elapsed formula

126: Creating a Custom commandbar button

127: Another protect proble.

128: How to convert numbers to words?

129: data across two different spreadsheets

130: opening files with vba

131: IF Function

132: Search macro adjustment

133: CodePane

134: Msgbox not ok

135: Font Size Problems with ComboBox

136: Excel 2003: Match one list against another and highlight differenc

137: RTD Throttleinterval. How do you change it?

138: Excel formulas and the relevance of this >>> {

139: Sum if or some sort of match formula

140: using odbc in excel

141: referencing worksheet names in a cell

142: Digital Certificate

143: Auto_open from Worksheet Object Code

144: how do i freeze a vertical column & horizontal row in excel?

145: unwanted spaces in mail merge docs

146: Creating table from cell contents

147: SUMPRODUCT

148: How do I copy every 8th cell in a column

149: SolverSolve userFinish:=True still displays the dialogue

150: Auto Updating List

151: centering cells

152: Day of the Week from Date

153: open Goldmine email msg from Excel VBA

154: IF and HLOOKUP Formula

155: Maximum number of sheet for one spreadsheet

156: Can I rounddown a cell result from millions to thousands

157: Getting data from a closed workbook to a master record

158: Creating Formula with Embedded Variable ID

159: return text

160: NEED MACRO OR FORMULA

161: spell check in excel 2007

162: Format a rangeafter usining a userform

163: Autocopy between 2 workbooks

164: How to change #lines in Immediate Window

165: Extracting information from table

166: Stutter in AdvancedFilter Unique Results?

167: Limited amount of cells in a formula

168: Using Rank in an Array Formula

169: have Excel retrieve conditional operator ( < > = ) from a cell

170: Need help with VBA

171: Using variable addresses in vba

172: Userform Control Error

173: how can I hide macro list from user?

174: Clickable Cell Area

175: keeping track of stock moving from one location to another

176: formula forming Q for Formula One :-D

177: find the matching and allocate the required quantity

178: Why does my shared spreadsheet have formula errors?

179: VBA Validation - textbox must not be blank

180: Table sorting questions

181: VBA macro to delete rows that contain text

182: Combining Msg Box and Data

183: Count the number of worksheets in a workbook

184: How to select the bottom right cel in a 'CurrentRegion.selecion'

185: copy one sheet to other excel workbook

186: VBA code does not work in Excel 2003

187: Comma's btw numbers

188: Background color for 50,000 odd-numbered rows

189: Code Execution Has Been Interruptred?

190: Pop up message

191: Problem with Analysis ToolPak Add-in

192: Working with =IF(ISNA,(myformula),0,(myformula)

193: Nested IF and Countif ?

194: I'm just starting to play around with VB and would like some help.

195: An Address Mess!

196: conditional query

197: formula bar

198: Sum range of cells with VBA

199: need some help with: formatting of x2 dates in 1 cell

200: Paste a sub-table from a larger table

201: VBA - change textformat after a linefeed

202: Accessing the values of form controls on worksheets in Excel 2000

203: Search actual Formula for cell ref?

204: Formatting copied cells

205: Make multiple new sheets at the same time?

206: <IF> Calculated Field in Pivot

207: Adding values in columns with a specific indicator

208: Hyperlink or shortcut?

209: Change the 'Read-Only' Access for Non-Shared Files

210: Adding columns past the 256 limit

211: I need to change this code to copy All files the "customdoc" folde

212: Macro code

213: re : Save As

214: help with arrays

215: SUMIF function question

216: Printing a range that is determined at run time

217: Screen flicker when changing Image.Picture source on UserForm

218: program a cell in excell to reference a cell below a referenced ce

219: Excel 2003 default file location

220: Coments

221: Replace (') to space

222: Creating hangman(word game) on MS Excel

223: Constant growth

224: Macro Help

225: Building an application on top of Excel

226: Max size of variable?

227: HELP!!! How to Nest AND OR functions

228: Opening a Single Excel File in Different Custom Views Via Hyperlinks

229: Formules doorkopiëren

230: How do I output a formula into a cell and then autofill using vb?

231: How to check Excel file already Open

232: How come my macro works if I pause and play again?

233: can I replace all with a macro?

234: export a form

235: actual month

236: Help about If

237: Extracting File Names and Properties

238: Counting Strings in an Array

239: I am stupid and don't know what the heck I am doing wrong on this pivot table!!!

240: AddinInstall + Delete custom CommandBar Menu

241: Printing to PDF format using CutePDF Writer in VBA

242: creating a search model

243: Migrating from Excel 2000 to Excel 2003

244: Problem with Formatting Textboxes

245: Excel---Copying text from one cell a a sheet to another cell on a

246: Weekly reg/ot formula help please!

247: Populate an order form with Data

248: How to change negative to positive

249: Excel VBA- Error Accessing the system registry

250: Creating a Survey in Excel/Word

251: how to save fixed format text file

252: SIMPLE ?

253: Array error in subtotal method

254: How To: create a form for a user to enter data

255: adding shortcut menu items

256: Excel 07 filter

257: comparing columns from different sheets

258: Conditional Formatting-No Formulas

259: I have 1 master excel file & want to rec. data from 7 other files

260: help with ranges

261: Photos in cells?

262: modify how files are displyed in the "file open" window

263: Database summary

264: Excel; vba; listbox how to reorganize list in alfabetical order

265: Customized Changes to Toolbars

266: Paste special

267: How do I write a VBA for 3 consecutive dates?

268: Count Instances of value in two columns

269: Unifying different date formats in a spreadsheet

270: How to get a conditional argument to check all cells in a array?

271: Number of years, months, days between two dates.

272: Connect columns, with restrictions

273: Working with huge cells

274: copy data if data exists

275: matching/comparing lists

276: Formula for calculating 12 month rolling period

277: Code fails if ran more than once

278: hide PERSONAL.XLS

279: was working, now :(

280: How do import banking statements into excel?

281: Count Unique Numbers

282: Add hours to date

283: Formula Help required

284: Web Queries

285: dates and times, tracking using

286: Textbox edit

287: Excel data merged to PDF form

288: Thanks !!!

289: Text on shapes

290: 4 different if statements, not working

291: General ?? regarding Macro or Module size in a spreadsheet

292: sumproduct with dates

293: if isna and vlookup together

294: Coding in VLOOKUP function

295: Help with lookup or if functions

296: File protection / Sharing / Conflicts

297: Does Excel have a linear interpolation function?

298: webquery with login first

299: plotting chart with user selected range from current workbook

300: Prevent Excel from going online when opening html file

301: Inserting something at the begining of evrey cell