Page 477

view full version: back to formated view

1: macro is needed

2: Excel 2003 and Outlook Calendar

3: Clearing the keyboard buffer

4: Making an open workbook active

5: Transpose Reletive Cell References?

6: Conditional Button Enabling based on Checkbox

7: Re: Convert from WrapText

8: How to turn off automatic toolbar appearance

9: FIFO: Share calculation in VBA?

10: Sum if or sum product?

11: HELP...anybody got any ideas why this is running so slowly......

12: Deleting Duplicates in spreadsheet

13: Worksheet formulas stopped working

14: Mixing AND & OR functions

15: return data to specific columns?

16: Named Range

17: Access Query Recordet conversion to an Array

18: SaveAs with a pre-defined filename

19: quattro pro 5 into excell

20: Filling down problem in VB

21: Workbook-specific toolbar possible?

22: e-mailing a single worksheet of a multiple worksheet (4) workbook

23: Need formulas for finding text strings

24: how do I express a number as a ratio (4:1)

25: Formulas to speed up many manual "=()" commands

26: using checkbox to calculate another cell

27: Worksheet change VBA

28: Excel 2000 does not filter well

29: Printing? Worksheets not printing the same on multiple pc's!

30: Macro to Change Sheet

31: Simpel commandbutton question

32: newbie: stop a FOR NEXT loop

33: Showing an angle in cells

34: Showing Pictures

35: Replace a comma with a period in a cell containing a lastname, first

36: Startup Code in a Workbook

37: How to merge 2 ranges from to worksheets?

38: ENTER DATA INTO 2 CELLS AT THE SAME TIME

39: Copy Problem (progression in formulas)

40: Display Last Entry in Excel

41: Do Until Loop

42: EXCEL PMT function

43: Having Excel print a cell location

44: Scheduling Hours

45: Excel Help Required

46: negative log

47: how do i get a cell in a sheet to show the last 1024 characters?

48: Why isn't this macro giving me proper results?

49: Counting States basied on the time and date stamp

50: A Word Problem...

51: Spooling and printing each name

52: Excel Global Variable Setting

53: COUNTIF to count cells that have an attached comment

54: Excel 2003 will not display color fonts or color fill cells

55: How do you change code in the VBE without opening the target workb

56: Comparing Text

57: Cut and paste by reference part 2

58: sumproduct causing memory errors?

59: Formula for getting values in File-Properties-Custom

60: Passing a value across workbooks

61: Code to Insert Formula in Cell

62: IF statement in Array Formula's

63: How do I have a cell highlight when selected?

64: How do I dedupe 2 files in excel

65: Need help setting up a spreadsheet of some sorts.

66: Code to create and name a sheet

67: Kill Function

68: Delete Empty Rows

69: Gathering info from saved files

70: Alternative to Vlookup/Hlookup to return a value.

71: FOrgot Password

72: See these internet pack from Microsoft Corporation

73: copy email addresses from excel to yahoo

74: Split worksheet to individual sheets

75: .find =< function

76: HOW DO I USE THE GETSAVEASFILENAME METHOD?

77: Copy formula to cells on the basis of value in row 1

78: Moving Chart Objects

79: copying an entire worksheet - need absolute values

80: Lookup , match, not sure !?

81: Macro: If

82: delete worksheet

83: Random gen

84: Comand line or Vb

85: add-ins error + setting workbooks

86: Import from TXT file with "No record delimiter"

87: If logical value problems

88: Saving over a range

89: i need to add 01 to the end of 500 rows of numbers

90: Font progressively moves upward out of row when printing

91: New shortcuts in Excel 2007

92: How to represent an empty cell in excel formulae?

93: Moving within the worksheet

94: copy and paste to another sheet based in cell color

95: named range, conditional formatting

96: Combing columns of data

97: Message Box - Click OK to go away

98: Need to convert Outlook Journal Duration to a number

99: if...or....function

100: How do I show excel worksheets on a webpage when viewed by win98 .

101: Check path and files

102: " workbook not saved " Message

103: using Goal Seek inside a recorded macro

104: A letter to generat a number when entered into anywhere on the spr

105: VBA - Move cell contents if bold text

106: replacement for filesearch in excel 2007

107: How do i set up a dropdown listbox of values in a column of cells

108: How to use a UDF (module) across many users (embedd in worsheet)

109: Offset from new name based on what's checked in Userform

110: Separating text in a cell

111: Tab key in Excel

112: How to find duplicate data in two tables,then listing it?(Excel)

113: Possible IF statement?

114: Need help with creating a Range Name syntax

115: Copy to a database

116: Going to bottom left cell in database

117: embedding links in cells

118: Code to loop through multiple checkboxes

119: Custom Document Properties - Last Calculation Date

120: Format, Column, Auto-fit

121: Sending to yourself using sendmail

122: Need help with formula

123: Can I launch macro by a cell click ?

124: how to prevent user to interrupt macro

125: total columns by colour in excel

126: Bloomberg DDE problem

127: Replacing last digit with Zero

128: Hard line break displaying as rectangle on import from SQL

129: Reference using Excel with VB.NET

130: Comment box

131: Phone bill nightmare

132: Import Data From Landscape Format

133: Streamline copying and pasting code

134: pivottable and OLAP cubes

135: Printing problem

136: returning header row as a result...

137: Referring to Sheet locations in a formula

138: sumproduct function combined with named range?

139: need macro\method that would allow user input to a data filter

140: Case Sensitive LookUps

141: vlookups

142: How do I get Cell Data (once worked)

143: Urgent.. Need help with Excel..

144: VLOOKUP - results do not appear in cell

145: If Len > 5 OR cell is alphanumeric Then Clear contents

146: How do I access worksheet cell data (i.e. cell sheet1!a4) from vi.

147: Combine Excel rows - macro needed.

148: pasting

149: Concatenate: Multi-Line Cell with 2 single line cells

150: Directing data to new worksheets

151: Decimal Place Rounding

152: Aligning login logout times horizontally

153: Workbook Create Date fx

154: CSV Format

155: Using 2 cells in a table to retrieve data from another table

156: Comparing columns in different worksheets

157: requiring parameters to be of a certain type

158: Is there a built-in function to combine 2 ranges?

159: how do i enter a bull call spread into the options spread sheet ?

160: Pivot table problem

161: Change Worksheet Button Caption on Worksheet.Activate

162: help needed

163: cannot open excel file

164: Printing

165: =?Utf-8?Q?Can_this_be_done=C2=AB=3F?=

166: Help with looking up mileage table

167: Does File Exist

168: Better Fix For Endless Do While Statement

169: re-enable macros

170: Exporting Access Queries to sepcific ranges in an Excel workbook

171: Code to delete rows not working

172: Searching within an excel document

173: How do I call this function?

174: pulling information from a closed workbook

175: change print settings across entire document

176: Source data for pivot table to point to cell on worksheet?

177: limited lines in check register

178: Printing one Adobe pdf instead of multiple pdfs

179: a on_doubleclick statement is not working

180: Column/Row Formating

181: adding individual cells in a column

182: Two-Way Calculatoin

183: Worksheet event help

184: can someone explain what the below macro does

185: Delete Empty Series from Chart

186: De-Select an Option button

187: Accessing cells in Excel spreadsheet from Visio

188: How to automatically rearrange data on a worksheet.

189: Is there anybody who can hlp in the function making!!!

190: How to track bottom line results over time for a trend plot?

191: How do I call a method in VB from Excel with JUST code?

192: Auto Run and Installation privileges

193: Use Access Database from Excel

194: Simple Filter Question

195: extrernal data as a column

196: msgBox Text Truncating

197: SetFocus not working

198: case of the data

199: Formatting cell for date

200: Return Blank

201: Problem looping through combobox

202: Configuring a cell to take higher values only

203: highlighting cell

204: return same cell value from numerous sheets

205: Excel 2007 Name Conflict

206: help needed with pivot table

207: Automatic Sheet updating

208: Book Suggestions Sought

209: How To Highlight in Excel

210: Excel worksheet tabs

211: Convert time into integer

212: dele navn

213: How do I transfer formulas but not the information?

214: Excel invoicing

215: Scheduled Task

216: worksheet change problems

217: Insert New Row on Sheet Not in Focus

218: Multiple hyperlinks from drop down box

219: VBA - AfterSave event

220: HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE

221: Excel Date and Time Function

222: Macro selecting wrong cell range

223: #N/A and SUM

224: Displaying the "Calculating Cells n%"

225: Pivot Table, merge columns into one row heading?

226: how do you generate a report every 5 mins automatically and delete

227: Can I make the number in one cell automatically appear elsewhere?

228: Pivot table using Cube object - data overflow error

229: Lookup/Match Problem

230: user defined functions

231: Duplicate fields does not match up! If statement

232: Adding Data from Multiple Spreadsheets

233: access to xls

234: Datagrid to Excel - error - rendercontrol

235: Border help

236: Need a special kind of "sort"...

237: Scrolbars

238: M,I.5'Persecu tion how and w hy di d it sta rt?

239: Center on colon

240: Format Cells with date format

241: How to change row color when select a cell in this row?

242: Report on Number of Employees Clocked in

243: HELP! Sh as Worksheet

244: -- operator

245: User Form and Database Queries

246: Increment down 1 row at a time, copy cell contents to another workbook

247: Calculate average and not include zero values

248: export excell data as xml

249: print area problem

250: Cell only shows formula entered

251: Open spreadsheet

252: Change Default Zoom

253: macro to compare info in another file

254: CountIF-dual conditions

255: Speed-up a macro!

256: Printing issues (VBA)

257: write email subject

258: What's wrong with this formula - NESTED IF STATEMENTS

259: Calculating Dates

260: Current time for data entered in column

261: I need a macro to grab specific data and transfer it to a now worksheet

262: ODBC connection for insert into SQL Server

263: defaulting to the desktop

264: DataLabel Manipulation

265: 2 dimensional MATCH

266: Page Numbering problems

267: How can I have information from a form I created to automatically.

268: pagenumber etc.

269: Get Name of Macro Initiator

270: How keep user form constant

271: formulat to convert base 32 to decimal?

272: How do I use functions and calculations?

273: HasFormula

274: automatic printing

275: my excel formulas are too long to execute find and replace

276: Looping through text boxes

277: Select/highlight alternate cells

278: Changing macro source

279: Scroll Area Problem

280: year end sales report with old and new customers

281: how can i call macro in powerpoint file from excel file

282: problem breaking macro into 2 subroutines

283: Saving the clipboard

284: Query replace by VBA

285: STRING functions

286: blank cells

287: Major Sorting Problems!!!

288: Excel User Conference - Atlantic City, New Jersey - April 19-21, 2006

289: Run add-in code when Excel starts

290: Listboxes 2

291: Count from left to right

292: Excel formula divide list of #s by N to get a number above 40

293: countif refering to 2 cells at the same time

294: Poor performance in Excel 2007

295: Emailing files using a do until

296: File conversion query

297: calculating product of 2 cells where 1 cell is in percentage

298: Software language version discrepancies

299: Retaining history data in cells when using a form text box

300: please help, ned urgent

301: Run a Query on External data(ODBC) criteria based on input of a ce

2: Excel 2003 and Outlook Calendar

3: Clearing the keyboard buffer

4: Making an open workbook active

5: Transpose Reletive Cell References?

6: Conditional Button Enabling based on Checkbox

7: Re: Convert from WrapText

8: How to turn off automatic toolbar appearance

9: FIFO: Share calculation in VBA?

10: Sum if or sum product?

11: HELP...anybody got any ideas why this is running so slowly......

12: Deleting Duplicates in spreadsheet

13: Worksheet formulas stopped working

14: Mixing AND & OR functions

15: return data to specific columns?

16: Named Range

17: Access Query Recordet conversion to an Array

18: SaveAs with a pre-defined filename

19: quattro pro 5 into excell

20: Filling down problem in VB

21: Workbook-specific toolbar possible?

22: e-mailing a single worksheet of a multiple worksheet (4) workbook

23: Need formulas for finding text strings

24: how do I express a number as a ratio (4:1)

25: Formulas to speed up many manual "=()" commands

26: using checkbox to calculate another cell

27: Worksheet change VBA

28: Excel 2000 does not filter well

29: Printing? Worksheets not printing the same on multiple pc's!

30: Macro to Change Sheet

31: Simpel commandbutton question

32: newbie: stop a FOR NEXT loop

33: Showing an angle in cells

34: Showing Pictures

35: Replace a comma with a period in a cell containing a lastname, first

36: Startup Code in a Workbook

37: How to merge 2 ranges from to worksheets?

38: ENTER DATA INTO 2 CELLS AT THE SAME TIME

39: Copy Problem (progression in formulas)

40: Display Last Entry in Excel

41: Do Until Loop

42: EXCEL PMT function

43: Having Excel print a cell location

44: Scheduling Hours

45: Excel Help Required

46: negative log

47: how do i get a cell in a sheet to show the last 1024 characters?

48: Why isn't this macro giving me proper results?

49: Counting States basied on the time and date stamp

50: A Word Problem...

51: Spooling and printing each name

52: Excel Global Variable Setting

53: COUNTIF to count cells that have an attached comment

54: Excel 2003 will not display color fonts or color fill cells

55: How do you change code in the VBE without opening the target workb

56: Comparing Text

57: Cut and paste by reference part 2

58: sumproduct causing memory errors?

59: Formula for getting values in File-Properties-Custom

60: Passing a value across workbooks

61: Code to Insert Formula in Cell

62: IF statement in Array Formula's

63: How do I have a cell highlight when selected?

64: How do I dedupe 2 files in excel

65: Need help setting up a spreadsheet of some sorts.

66: Code to create and name a sheet

67: Kill Function

68: Delete Empty Rows

69: Gathering info from saved files

70: Alternative to Vlookup/Hlookup to return a value.

71: FOrgot Password

72: See these internet pack from Microsoft Corporation

73: copy email addresses from excel to yahoo

74: Split worksheet to individual sheets

75: .find =< function

76: HOW DO I USE THE GETSAVEASFILENAME METHOD?

77: Copy formula to cells on the basis of value in row 1

78: Moving Chart Objects

79: copying an entire worksheet - need absolute values

80: Lookup , match, not sure !?

81: Macro: If

82: delete worksheet

83: Random gen

84: Comand line or Vb

85: add-ins error + setting workbooks

86: Import from TXT file with "No record delimiter"

87: If logical value problems

88: Saving over a range

89: i need to add 01 to the end of 500 rows of numbers

90: Font progressively moves upward out of row when printing

91: New shortcuts in Excel 2007

92: How to represent an empty cell in excel formulae?

93: Moving within the worksheet

94: copy and paste to another sheet based in cell color

95: named range, conditional formatting

96: Combing columns of data

97: Message Box - Click OK to go away

98: Need to convert Outlook Journal Duration to a number

99: if...or....function

100: How do I show excel worksheets on a webpage when viewed by win98 .

101: Check path and files

102: " workbook not saved " Message

103: using Goal Seek inside a recorded macro

104: A letter to generat a number when entered into anywhere on the spr

105: VBA - Move cell contents if bold text

106: replacement for filesearch in excel 2007

107: How do i set up a dropdown listbox of values in a column of cells

108: How to use a UDF (module) across many users (embedd in worsheet)

109: Offset from new name based on what's checked in Userform

110: Separating text in a cell

111: Tab key in Excel

112: How to find duplicate data in two tables,then listing it?(Excel)

113: Possible IF statement?

114: Need help with creating a Range Name syntax

115: Copy to a database

116: Going to bottom left cell in database

117: embedding links in cells

118: Code to loop through multiple checkboxes

119: Custom Document Properties - Last Calculation Date

120: Format, Column, Auto-fit

121: Sending to yourself using sendmail

122: Need help with formula

123: Can I launch macro by a cell click ?

124: how to prevent user to interrupt macro

125: total columns by colour in excel

126: Bloomberg DDE problem

127: Replacing last digit with Zero

128: Hard line break displaying as rectangle on import from SQL

129: Reference using Excel with VB.NET

130: Comment box

131: Phone bill nightmare

132: Import Data From Landscape Format

133: Streamline copying and pasting code

134: pivottable and OLAP cubes

135: Printing problem

136: returning header row as a result...

137: Referring to Sheet locations in a formula

138: sumproduct function combined with named range?

139: need macro\method that would allow user input to a data filter

140: Case Sensitive LookUps

141: vlookups

142: How do I get Cell Data (once worked)

143: Urgent.. Need help with Excel..

144: VLOOKUP - results do not appear in cell

145: If Len > 5 OR cell is alphanumeric Then Clear contents

146: How do I access worksheet cell data (i.e. cell sheet1!a4) from vi.

147: Combine Excel rows - macro needed.

148: pasting

149: Concatenate: Multi-Line Cell with 2 single line cells

150: Directing data to new worksheets

151: Decimal Place Rounding

152: Aligning login logout times horizontally

153: Workbook Create Date fx

154: CSV Format

155: Using 2 cells in a table to retrieve data from another table

156: Comparing columns in different worksheets

157: requiring parameters to be of a certain type

158: Is there a built-in function to combine 2 ranges?

159: how do i enter a bull call spread into the options spread sheet ?

160: Pivot table problem

161: Change Worksheet Button Caption on Worksheet.Activate

162: help needed

163: cannot open excel file

164: Printing

165: =?Utf-8?Q?Can_this_be_done=C2=AB=3F?=

166: Help with looking up mileage table

167: Does File Exist

168: Better Fix For Endless Do While Statement

169: re-enable macros

170: Exporting Access Queries to sepcific ranges in an Excel workbook

171: Code to delete rows not working

172: Searching within an excel document

173: How do I call this function?

174: pulling information from a closed workbook

175: change print settings across entire document

176: Source data for pivot table to point to cell on worksheet?

177: limited lines in check register

178: Printing one Adobe pdf instead of multiple pdfs

179: a on_doubleclick statement is not working

180: Column/Row Formating

181: adding individual cells in a column

182: Two-Way Calculatoin

183: Worksheet event help

184: can someone explain what the below macro does

185: Delete Empty Series from Chart

186: De-Select an Option button

187: Accessing cells in Excel spreadsheet from Visio

188: How to automatically rearrange data on a worksheet.

189: Is there anybody who can hlp in the function making!!!

190: How to track bottom line results over time for a trend plot?

191: How do I call a method in VB from Excel with JUST code?

192: Auto Run and Installation privileges

193: Use Access Database from Excel

194: Simple Filter Question

195: extrernal data as a column

196: msgBox Text Truncating

197: SetFocus not working

198: case of the data

199: Formatting cell for date

200: Return Blank

201: Problem looping through combobox

202: Configuring a cell to take higher values only

203: highlighting cell

204: return same cell value from numerous sheets

205: Excel 2007 Name Conflict

206: help needed with pivot table

207: Automatic Sheet updating

208: Book Suggestions Sought

209: How To Highlight in Excel

210: Excel worksheet tabs

211: Convert time into integer

212: dele navn

213: How do I transfer formulas but not the information?

214: Excel invoicing

215: Scheduled Task

216: worksheet change problems

217: Insert New Row on Sheet Not in Focus

218: Multiple hyperlinks from drop down box

219: VBA - AfterSave event

220: HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE

221: Excel Date and Time Function

222: Macro selecting wrong cell range

223: #N/A and SUM

224: Displaying the "Calculating Cells n%"

225: Pivot Table, merge columns into one row heading?

226: how do you generate a report every 5 mins automatically and delete

227: Can I make the number in one cell automatically appear elsewhere?

228: Pivot table using Cube object - data overflow error

229: Lookup/Match Problem

230: user defined functions

231: Duplicate fields does not match up! If statement

232: Adding Data from Multiple Spreadsheets

233: access to xls

234: Datagrid to Excel - error - rendercontrol

235: Border help

236: Need a special kind of "sort"...

237: Scrolbars

238: M,I.5'Persecu tion how and w hy di d it sta rt?

239: Center on colon

240: Format Cells with date format

241: How to change row color when select a cell in this row?

242: Report on Number of Employees Clocked in

243: HELP! Sh as Worksheet

244: -- operator

245: User Form and Database Queries

246: Increment down 1 row at a time, copy cell contents to another workbook

247: Calculate average and not include zero values

248: export excell data as xml

249: print area problem

250: Cell only shows formula entered

251: Open spreadsheet

252: Change Default Zoom

253: macro to compare info in another file

254: CountIF-dual conditions

255: Speed-up a macro!

256: Printing issues (VBA)

257: write email subject

258: What's wrong with this formula - NESTED IF STATEMENTS

259: Calculating Dates

260: Current time for data entered in column

261: I need a macro to grab specific data and transfer it to a now worksheet

262: ODBC connection for insert into SQL Server

263: defaulting to the desktop

264: DataLabel Manipulation

265: 2 dimensional MATCH

266: Page Numbering problems

267: How can I have information from a form I created to automatically.

268: pagenumber etc.

269: Get Name of Macro Initiator

270: How keep user form constant

271: formulat to convert base 32 to decimal?

272: How do I use functions and calculations?

273: HasFormula

274: automatic printing

275: my excel formulas are too long to execute find and replace

276: Looping through text boxes

277: Select/highlight alternate cells

278: Changing macro source

279: Scroll Area Problem

280: year end sales report with old and new customers

281: how can i call macro in powerpoint file from excel file

282: problem breaking macro into 2 subroutines

283: Saving the clipboard

284: Query replace by VBA

285: STRING functions

286: blank cells

287: Major Sorting Problems!!!

288: Excel User Conference - Atlantic City, New Jersey - April 19-21, 2006

289: Run add-in code when Excel starts

290: Listboxes 2

291: Count from left to right

292: Excel formula divide list of #s by N to get a number above 40

293: countif refering to 2 cells at the same time

294: Poor performance in Excel 2007

295: Emailing files using a do until

296: File conversion query

297: calculating product of 2 cells where 1 cell is in percentage

298: Software language version discrepancies

299: Retaining history data in cells when using a form text box

300: please help, ned urgent

301: Run a Query on External data(ODBC) criteria based on input of a ce