Page 254

view full version: back to formated view

1: finding only numeric values in a worksheet using vb.net?

2: Solver

3: Return a value by referencing row and column labels?

4: Copy Function into other cells

5: Lookup/Date Question

6: Help with named constants in Define Name dialog box!!!!

7: change worksheets through code

8: Please Help!!

9: paste link 0

10: Saving linked workbooks to another directory

11: New Collection add trim

12: Application-defined or object-defined error on closing

13: Email Workbook

14: Can I copy the odc files and will they still work?

15: Excel 11.0 Object Library

16: Excel. My Cell Must Contain An '@'

17: Hardcode

18: code to do a sql-equivalent to JOIN() (as implemented in digDB)

19: If / or/ then

20: Changing password protection on sheets

21: Access connection works in Macro, not in user-defined Function

22: Sizing a Chart Sheet to a Word Table Cell

23: Average Non-consecutive Cells

24: Data, Validation, List always starts at the bottom?

25: Publish an Excel 2003 Chart to HTML file

26: Copying a cell contents down to the next non-blank cell

27: Cell help!

28: How to select a range and save it as a picture (.gif, jpg, bmp, ..

29: Excel 2003 - VBA - Importing .txt files and unwanted Names

30: Please Help - Vlookup in a macro.

31: Need Urgent Help!

32: Generating multiple sheets within a workbook all titled with a ca.

33: Excel vb help: How to grab the right Data

34: FileSearch Problem

35: Setting true/false questions in excel

36: Count data in one column if certain criteria exists in another.

37: Macros with variable data

38: Probem - In opening Excel file through Short cut

39: Is there a way to reference 2 separate worksheets with validation

40: MS Query over a network

41: on closing excel enter password problem

42: Disable dragging Data-field in Pivot Table

43: Macros - stepping left in a macro

44: custom toolbar looses buttons when closed

45: Due Date

46: Range in macro

47: "This workbook has lost its VBA Project"

48: Parameter format for the Slope( ) function from .NET

49: Summing instances that are in different rows and columns

50: Programming for a save button

51: Excel code conversion

52: Excel still running after "quit" command

53: Number of characters in a cell

54: Why doesn't "Sendkeys" work reliably for me?

55: Alarm Timer

56: concatenate problem

57: Links between Workbooks

58: Select Cells with VBA

59: How to Improve my "Vlookup" on Steroids function.....

60: Automatically transpose when pasting data in excel

61: how we can use spellnumber() function in a new worksheet / file?

62: Using Find with dates

63: test for "A" or "D"

64: Error Handling

65: Getting cell address from input box

66: How get data into IE6 as "Favorites"?

67: Subtracting Times

68: How do you enter a ratio e.g. 100:1 into a cell?

69: Changing cell color based on its value

70: Why unable to set cell's ColorIndex property?

71: AutoFormat - help!!!

72: Prompt user to create routing slip

73: I need a help

74: vlookup lookup different column

75: wildcards with substitute of replace

76: How do I program telnet using exel through dos?

77: How do I freeze the widths of columns?

78: Dialogue Boxes

79: Cross-Referencing numbers. Need help please

80: How can I improve the find method?

81: open workbook using wildcard

82: Naming multiple sheets in a workbook using cells within the workbo

83: Draw line between two points using data on the spreedsheet

84: Calendar in worksheet

85: Today()

86: Copy & Paste Hyperlink address into cell

87: scorecard/leaderboard

88: Test

89: complicated IF THEN formulas

90: copying and pasting range problem

91: Date Format

92: update data from website txt file

93: How do I stop Excel from Automatically WRAPPING?

94: Creating a TEXT formula to link a word in one cell with a number v

95: Named Ranges Not Working in Data Validation

96: Hidden macro

97: VBA Code req to close all workbooks

98: Comparitor

99: Finish Formula

100: Custom toolbars

101: Unable To Record Macro

102: Bulletproofing a worksheet

103: Macro for command button

104: How to sort data w/ formulas?

105: Match cells with cells on another workbook

106: SHORT CUT KEY(S) TO SHOW OR HIDE SEETS IN EXCEL

107: Licensing policy for Office Web components

108: Lotus Notes Q: Copy'n paste from Excel AND place Excel attachment

109: Excel VBA - Check for Duplicate Records

110: Reading Wordpad - Rich Text Format

111: Printing specific excel worksheets in VB.NET

112: XML Writer/Excel question

113: Is there a function/formula to retrieve the weeknumber?

114: Format Lines

115: Can't call up floating macro toolbar-stop recording/relative ref.

116: Counting colored cells?

117: Is there such a think as "dual link"?

118: What happened to "Tab Color" for worksheets?

119: Hyperlink two sheets in a Excel Workbook

120: using array, Match, trying to eliminate duplicates -> how to return or translate result to a boolean?

121: msflexgrid doesn't exist on vista

122: protect unprotect sheet vba

123: Replace Function

124: Out of memory

125: tried to change my code but cant get it to work.

126: Calculate the total amount by date

127: Print Preview

128: intercept graph vs. function

129: Launch VBS from VBA

130: Load VBA on Activated Sheet

131: Getting error "Too many cell formats!", how do I correct?

132: Text=Number

133: How do I save printing option for all in a shared Excel workbook?

134: Macro for Excel / Outlook

135: Can an Excel formula be created to paste a picture in a cell?

136: Excel problem

137: Compare and Filter Out Large Database

138: Permissions

139: credit card formatting

140: Flash display of chart

141: Email Syntax error

142: Macro to find odd due dates and move them

143: Open Dialogue Box to a certain folder?????

144: deleting unused space at the end of a worksheet

145: Inserting Hyperlinks in a Protected Sheet

146: Tom Ogilvy - 'Snap to'

147: Can Step through but when run defines variable wrong

148: paste table from pdf to excel

149: Command Bars - working with the built in buttons

150: ex03 file saved at 9000Kb. close immediately & size goes 16000kb

151: Merged cells and filter/jump to

152: Import Access Database info to Excel???

153: calculating return in a range

154: Getting the Date Format Being Used By The Operating System And Exc

155: For Each Ctl In Me.Controls

156: How to get print area borders - UsedRange not correct.

157: Thankyou

158: Having problem adding up column wondering if HLOOKUP is the cause

159: do not average cells that have "0" value

160: : in cell references in formula (Excel 2003)

161: Countif Between

162: Time function problem

163: VBA Help

164: Numbers to Text

165: XML Refresh Code

166: template

167: How do I get Excel to access an externall dll ?

168: blank cells

169: Copying problem

170: Parameterized Query

171: Function to use...

172: cannot shift objects off sheet

173: VBA control vscroll and hscroll in a frame

174: Cell referencing SC

175: In Excel, option to enter text in cells the same as text boxes

176: ranges in combobox

177: Workbooks Sharing Information

178: time and curency

179: How to use a Access Query that as a parameter into Excel database query

180: copy from a textbox

181: Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials???

182: formulas

183: short cut stroke to move between work sheets in Excel

184: Lock cells in shared workbook

185: Removing Duplicates

186: How to do multiple IF checks with dates AND text

187: Sizing row height automatically

188: Mailmerge from excel button

189: Macro to Count how many times a number occurs on a day

190: If Function Help, Please!

191: setting default cell virticle alignment

192: creating a 'routine'

193: Copy & Paste

194: missing data on Pivot table

195: application.filesearch error in excel 2007

196: Macro to activate a Batch file !

197: HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL

198: Help with Conditional Sum

199: Option button help

200: Strange "button" - please help.

201: Modifying code to save data

202: How do I set up a detailed graph in Excel?

203: Excel4 Macros. Dangers?

204: When does TRUE evaluate to minus 1?

205: How do i set up my workbooks in different desktops?

206: Another way to lookup data

207: Date minus date=No. of days?

208: Document not saved

209: uppercase to lowercase

210: Scrollbar macros

211: shapes caption on chart

212: How do i copy section headings automatically in excel

213: Pasting an Excel array

214: Import file to Word document

215: Archive Macro

216: Array Formula Question

217: please help save me some time!

218: Can not copy the file from server to my local C:\

219: Offset delivers value error with Named range

220: HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS

221: loading another application from excel vba

222: On activate event

223: Fixed length file import??

224: chech if a cell contains a substring

225: Automating printing to PDF

226: Conditional format entire row (not cell) by date

227: Newbie on Macros

228: #NUM!

229: Data entry

230: Multiple criteria for lookup table

231: Formula

232: How does MATCH handle a Non-Match?

233: not sure if this can be done rolling averages

234: Problem with Frames in userform

235: Assign button to run macro

236: Can you make a number in an excel cell blink?

237: Using VLOOKUP without a sorted list

238: Web service response not shown in VBA

239: DATA VALIDATION IN REVERSE #2 (FOR JULIE D.)

240: Date functions

241: Cell Auto Format

242: Macro to add rows between cells - new at VBA

243: Geodetic functions with English documentation

244: count how many groups have been completed.

245: Separate Concatenated First/Last Name

246: How would you manage these dates?

247: Excel 2007 menus - is this right?

248: sumproduct with 3 variables

249: Extract data from one Worksheet to another

250: How to get the address of the cell found our by vlookup

251: Lookup two different columns

252: Create an attractive "link" button

253: How to write a macro to fix another macro

254: DAO recordset Call to SQL Stored Proc

255: How do I move the file menu back to it's original place?

256: help with templete

257: How do I put items from a list or column into other boxes in Excel

258: Stumped 2

259: repeating data

260: format cell to view value not formula

261: DISPLAY RANGE AT MSGBOX

262: How can I program a message box to open when a user opens and exc.

263: move data between sheets & keep running total

264: how to add a "+" to a number in a cell

265: Pasting Banking Info to Excel - Debits and Credits

266: API Timer Problem

267: Selection Change Event...

268: How to use different type Query for Excel PivotTable? (ODBC)

269: Is a folder list extraction possible?

270: VLOOKUP from another sheet, VBA

271: Default Response to a MsgBox

272: Passing Variable to LINEST

273: Macro to Split Window in Same Place Even If Columns Added or Hidde

274: Formula to calculate affiliate commission

275: Hiding selected Row

276: Time to save a workbook

277: Everything You Need To Know About Printed Lanyards

278: Validation from List

279: Subtotals in Pivot Tables

280: Help Required to Import directories in excel

281: Update created sheet?

282: Fill in Combo Box with range values????

283: Help with database formula.

284: Print Rows

285: Assistance with error message on CELLS

286: Help please - "General" format for cells.

287: macro problems with Workbooks.Add Template

288: Excel Time Help

289: Saving Selected Worksheets

290: What is a difference between sheet and worksheet?

291: Stop Capture Event

292: no of pages in excel worksheet (not workbook)

293: RATE - what is the internal function?

294: Comparing Dates - Generic Function?

295: Protection options through VBA

296: Delete an entire folders contents (or just Excel files)

297: Recalulate on Format change...

298: Run Macro in one worksheet from a button on another worksheet

299: SUM

300: Dividing zero by zero

2: Solver

3: Return a value by referencing row and column labels?

4: Copy Function into other cells

5: Lookup/Date Question

6: Help with named constants in Define Name dialog box!!!!

7: change worksheets through code

8: Please Help!!

9: paste link 0

10: Saving linked workbooks to another directory

11: New Collection add trim

12: Application-defined or object-defined error on closing

13: Email Workbook

14: Can I copy the odc files and will they still work?

15: Excel 11.0 Object Library

16: Excel. My Cell Must Contain An '@'

17: Hardcode

18: code to do a sql-equivalent to JOIN() (as implemented in digDB)

19: If / or/ then

20: Changing password protection on sheets

21: Access connection works in Macro, not in user-defined Function

22: Sizing a Chart Sheet to a Word Table Cell

23: Average Non-consecutive Cells

24: Data, Validation, List always starts at the bottom?

25: Publish an Excel 2003 Chart to HTML file

26: Copying a cell contents down to the next non-blank cell

27: Cell help!

28: How to select a range and save it as a picture (.gif, jpg, bmp, ..

29: Excel 2003 - VBA - Importing .txt files and unwanted Names

30: Please Help - Vlookup in a macro.

31: Need Urgent Help!

32: Generating multiple sheets within a workbook all titled with a ca.

33: Excel vb help: How to grab the right Data

34: FileSearch Problem

35: Setting true/false questions in excel

36: Count data in one column if certain criteria exists in another.

37: Macros with variable data

38: Probem - In opening Excel file through Short cut

39: Is there a way to reference 2 separate worksheets with validation

40: MS Query over a network

41: on closing excel enter password problem

42: Disable dragging Data-field in Pivot Table

43: Macros - stepping left in a macro

44: custom toolbar looses buttons when closed

45: Due Date

46: Range in macro

47: "This workbook has lost its VBA Project"

48: Parameter format for the Slope( ) function from .NET

49: Summing instances that are in different rows and columns

50: Programming for a save button

51: Excel code conversion

52: Excel still running after "quit" command

53: Number of characters in a cell

54: Why doesn't "Sendkeys" work reliably for me?

55: Alarm Timer

56: concatenate problem

57: Links between Workbooks

58: Select Cells with VBA

59: How to Improve my "Vlookup" on Steroids function.....

60: Automatically transpose when pasting data in excel

61: how we can use spellnumber() function in a new worksheet / file?

62: Using Find with dates

63: test for "A" or "D"

64: Error Handling

65: Getting cell address from input box

66: How get data into IE6 as "Favorites"?

67: Subtracting Times

68: How do you enter a ratio e.g. 100:1 into a cell?

69: Changing cell color based on its value

70: Why unable to set cell's ColorIndex property?

71: AutoFormat - help!!!

72: Prompt user to create routing slip

73: I need a help

74: vlookup lookup different column

75: wildcards with substitute of replace

76: How do I program telnet using exel through dos?

77: How do I freeze the widths of columns?

78: Dialogue Boxes

79: Cross-Referencing numbers. Need help please

80: How can I improve the find method?

81: open workbook using wildcard

82: Naming multiple sheets in a workbook using cells within the workbo

83: Draw line between two points using data on the spreedsheet

84: Calendar in worksheet

85: Today()

86: Copy & Paste Hyperlink address into cell

87: scorecard/leaderboard

88: Test

89: complicated IF THEN formulas

90: copying and pasting range problem

91: Date Format

92: update data from website txt file

93: How do I stop Excel from Automatically WRAPPING?

94: Creating a TEXT formula to link a word in one cell with a number v

95: Named Ranges Not Working in Data Validation

96: Hidden macro

97: VBA Code req to close all workbooks

98: Comparitor

99: Finish Formula

100: Custom toolbars

101: Unable To Record Macro

102: Bulletproofing a worksheet

103: Macro for command button

104: How to sort data w/ formulas?

105: Match cells with cells on another workbook

106: SHORT CUT KEY(S) TO SHOW OR HIDE SEETS IN EXCEL

107: Licensing policy for Office Web components

108: Lotus Notes Q: Copy'n paste from Excel AND place Excel attachment

109: Excel VBA - Check for Duplicate Records

110: Reading Wordpad - Rich Text Format

111: Printing specific excel worksheets in VB.NET

112: XML Writer/Excel question

113: Is there a function/formula to retrieve the weeknumber?

114: Format Lines

115: Can't call up floating macro toolbar-stop recording/relative ref.

116: Counting colored cells?

117: Is there such a think as "dual link"?

118: What happened to "Tab Color" for worksheets?

119: Hyperlink two sheets in a Excel Workbook

120: using array, Match, trying to eliminate duplicates -> how to return or translate result to a boolean?

121: msflexgrid doesn't exist on vista

122: protect unprotect sheet vba

123: Replace Function

124: Out of memory

125: tried to change my code but cant get it to work.

126: Calculate the total amount by date

127: Print Preview

128: intercept graph vs. function

129: Launch VBS from VBA

130: Load VBA on Activated Sheet

131: Getting error "Too many cell formats!", how do I correct?

132: Text=Number

133: How do I save printing option for all in a shared Excel workbook?

134: Macro for Excel / Outlook

135: Can an Excel formula be created to paste a picture in a cell?

136: Excel problem

137: Compare and Filter Out Large Database

138: Permissions

139: credit card formatting

140: Flash display of chart

141: Email Syntax error

142: Macro to find odd due dates and move them

143: Open Dialogue Box to a certain folder?????

144: deleting unused space at the end of a worksheet

145: Inserting Hyperlinks in a Protected Sheet

146: Tom Ogilvy - 'Snap to'

147: Can Step through but when run defines variable wrong

148: paste table from pdf to excel

149: Command Bars - working with the built in buttons

150: ex03 file saved at 9000Kb. close immediately & size goes 16000kb

151: Merged cells and filter/jump to

152: Import Access Database info to Excel???

153: calculating return in a range

154: Getting the Date Format Being Used By The Operating System And Exc

155: For Each Ctl In Me.Controls

156: How to get print area borders - UsedRange not correct.

157: Thankyou

158: Having problem adding up column wondering if HLOOKUP is the cause

159: do not average cells that have "0" value

160: : in cell references in formula (Excel 2003)

161: Countif Between

162: Time function problem

163: VBA Help

164: Numbers to Text

165: XML Refresh Code

166: template

167: How do I get Excel to access an externall dll ?

168: blank cells

169: Copying problem

170: Parameterized Query

171: Function to use...

172: cannot shift objects off sheet

173: VBA control vscroll and hscroll in a frame

174: Cell referencing SC

175: In Excel, option to enter text in cells the same as text boxes

176: ranges in combobox

177: Workbooks Sharing Information

178: time and curency

179: How to use a Access Query that as a parameter into Excel database query

180: copy from a textbox

181: Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials???

182: formulas

183: short cut stroke to move between work sheets in Excel

184: Lock cells in shared workbook

185: Removing Duplicates

186: How to do multiple IF checks with dates AND text

187: Sizing row height automatically

188: Mailmerge from excel button

189: Macro to Count how many times a number occurs on a day

190: If Function Help, Please!

191: setting default cell virticle alignment

192: creating a 'routine'

193: Copy & Paste

194: missing data on Pivot table

195: application.filesearch error in excel 2007

196: Macro to activate a Batch file !

197: HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL

198: Help with Conditional Sum

199: Option button help

200: Strange "button" - please help.

201: Modifying code to save data

202: How do I set up a detailed graph in Excel?

203: Excel4 Macros. Dangers?

204: When does TRUE evaluate to minus 1?

205: How do i set up my workbooks in different desktops?

206: Another way to lookup data

207: Date minus date=No. of days?

208: Document not saved

209: uppercase to lowercase

210: Scrollbar macros

211: shapes caption on chart

212: How do i copy section headings automatically in excel

213: Pasting an Excel array

214: Import file to Word document

215: Archive Macro

216: Array Formula Question

217: please help save me some time!

218: Can not copy the file from server to my local C:\

219: Offset delivers value error with Named range

220: HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS

221: loading another application from excel vba

222: On activate event

223: Fixed length file import??

224: chech if a cell contains a substring

225: Automating printing to PDF

226: Conditional format entire row (not cell) by date

227: Newbie on Macros

228: #NUM!

229: Data entry

230: Multiple criteria for lookup table

231: Formula

232: How does MATCH handle a Non-Match?

233: not sure if this can be done rolling averages

234: Problem with Frames in userform

235: Assign button to run macro

236: Can you make a number in an excel cell blink?

237: Using VLOOKUP without a sorted list

238: Web service response not shown in VBA

239: DATA VALIDATION IN REVERSE #2 (FOR JULIE D.)

240: Date functions

241: Cell Auto Format

242: Macro to add rows between cells - new at VBA

243: Geodetic functions with English documentation

244: count how many groups have been completed.

245: Separate Concatenated First/Last Name

246: How would you manage these dates?

247: Excel 2007 menus - is this right?

248: sumproduct with 3 variables

249: Extract data from one Worksheet to another

250: How to get the address of the cell found our by vlookup

251: Lookup two different columns

252: Create an attractive "link" button

253: How to write a macro to fix another macro

254: DAO recordset Call to SQL Stored Proc

255: How do I move the file menu back to it's original place?

256: help with templete

257: How do I put items from a list or column into other boxes in Excel

258: Stumped 2

259: repeating data

260: format cell to view value not formula

261: DISPLAY RANGE AT MSGBOX

262: How can I program a message box to open when a user opens and exc.

263: move data between sheets & keep running total

264: how to add a "+" to a number in a cell

265: Pasting Banking Info to Excel - Debits and Credits

266: API Timer Problem

267: Selection Change Event...

268: How to use different type Query for Excel PivotTable? (ODBC)

269: Is a folder list extraction possible?

270: VLOOKUP from another sheet, VBA

271: Default Response to a MsgBox

272: Passing Variable to LINEST

273: Macro to Split Window in Same Place Even If Columns Added or Hidde

274: Formula to calculate affiliate commission

275: Hiding selected Row

276: Time to save a workbook

277: Everything You Need To Know About Printed Lanyards

278: Validation from List

279: Subtotals in Pivot Tables

280: Help Required to Import directories in excel

281: Update created sheet?

282: Fill in Combo Box with range values????

283: Help with database formula.

284: Print Rows

285: Assistance with error message on CELLS

286: Help please - "General" format for cells.

287: macro problems with Workbooks.Add Template

288: Excel Time Help

289: Saving Selected Worksheets

290: What is a difference between sheet and worksheet?

291: Stop Capture Event

292: no of pages in excel worksheet (not workbook)

293: RATE - what is the internal function?

294: Comparing Dates - Generic Function?

295: Protection options through VBA

296: Delete an entire folders contents (or just Excel files)

297: Recalulate on Format change...

298: Run Macro in one worksheet from a button on another worksheet

299: SUM

300: Dividing zero by zero