Page 229

view full version: back to formated view

1: Paste Special from Outlook

2: Excel base 10 log for Optical Density vs %T

3: Referencing Shapes

4: Another way with cell comments.

5: How to create compounded int table?

6: Define a Name

7: How to get Countif to work this out?

8: Populating a Combo Box

9: Getting Run-time error although code looks correct

10: ADO SQL statment

11: sum cells based on criteria in first set of cells

12: Email attachment when someone else has it open

13: how to dynamically import a text file

14: Data Form confusion

15: Sorting ListBox results or transposing ListBox values to other cells for sorting

16: One Record Only

17: How to get different text formats in a concatenate function

18: appending two excel sheets into a third excel sheet.

19: Problem in SQL Query

20: VBA for each sheet in book

21: Sum function for non-continuous range

22: Excel 2000 Code works except in debug mode

23: Create Outlook Task from Data in Excel Row

24: Condition Formating

25: Searching for Duplicate Text in a column

26: VBA: how to... cell properties has to change based on a condition

27: Zoloft 2006

28: Copy from one workbook to another

29: macro to add additional lines

30: Vlookup with wildcard

31: How do I select every nth row?

32: auto fill from moving data?

33: linking pivot tables by page fields

34: How to auto run a macro in actived sheet?

35: Excel 2000 and filter feature in a protected workbook

36: Programming Help - evaluate, select and Past into new workbook

37: Excel UDF Description, Help Keyword, Help File

38: Listbox Question

39: Using variable sized range in CountIf()

40: Syntax error.

41: Excel Terminology

42: Formula error in merged cells

43: Deleting certain string within the string

44: I cant get Excel to work for me..

45: Pass control to a function/subroutine

46: Negative Number put in a certain column in a different sheet.

47: Trying to find Matches and Give a Result

48: case

49: Get List of Keyboard Shortcut Bindings

50: Excel Form and Data Retrieval

51: Over my head on this one...

52: If text exists

53: Sum Column on Array of sheets

54: "read only" statement incorrect

55: How to RANDOMLY split a whole dataset into two sub-dataset?

56: CLick on Box to enter time of day

57: Removing spaces from columns

58: "Difference from" pivot table custom calculation

59: Excel Frozen Sheets

60: How to name a chart for referencing in VBA? And move it.

61: code needed

62: VB Save

63: Help Crafting an Inventory Spreadsheet

64: fill series that runs along opposite axis?

65: Path Name

66: How to split filename from filepath?

67: Charting question

68: commandbutton?

69: Vlookup in large named range

70: Conditional Deleting of Subtotals

71: how do the details in an excel spreadsheet move to a summary page

72: any formula

73: How to change positive numbers to negative numbers without re-ente

74: How do I add a reference to an object library using VBA?

75: Problem with Dialogs(xlDialogWorkbookNew)

76: Macro to open multiple macros

77: Create a single sheet from many sheets

78: Programme Printing of Several Sheets

79: Maybe Mission Impossible...

80: Delete break line between column A & B

81: Added page won't incorporate into original spreadsheet Excel 2003

82: Tough Sumproduct Question

83: ActiveSheet is blank

84: Date and Time

85: using VLOOKUP to condense data on separate spreadsheet

86: Double lookup

87: Assign data to chart series, using array

88: Help me understand Transpose

89: cell auto format

90: CountIf / SumIf or other..

91: How to create a comboboxhandler

92: store the drop down box results in seperate excel sheet

93: Sumproduct not returning expected results

94: Mod function

95: Percentrank function display

96: VB for Apps Confusion

97: Tabels and calculation methods

98: Using Command Button to Hide Columns in another worksheet

99: Digitally signing VBA Project

100: Compiler says "Invalid qualifier" when using Application object

101: Index and match among sheets

102: Dynamically generating a spreadsheet with custom pivot table including data

103: Double sided printing with entire workbook with multiple pages

104: SaveAs Issues

105: Do loop error while using FindNext command

106: Pivot Tables-Calculations?

107: Macro Protection

108: Right text function

109: Open workbook in existing Excel session

110: How to count unique values?

111: Create new commandbar with call procedure

112: Populating Values In One Table With Values From Another Using VBA

113: Getting data from a workbook without opening it

114: Automating a date field to change on certain action

115: Require Minimum Amount When Entering Data

116: How do I make sure all empty columns are present in a .csv file?

117: macro to filter out data

118: Place The Contents Of A Cell From The Active Worksheet Into A Cell On An Inavtive Worksheet

119: Not enough system resources to display completely

120: Excel template issues

121: Sumproduct returns value error when ref is formula

122: convert date to day of week in excel 2003

123: calculate weighted average of stock cost

124: Limiting cell size to 25 characters

125: Excel macro/vba loops

126: Question about references

127: Lotus domino form to excel

128: Listview and colored line

129: SUMPRODUCT question

130: Intelimouse scroll wheel

131: Adding a Name range with vba

132: Deleting Custom Views when Deleting Sheets

133: formula for inserting rows

134: Type of macro (Excel Version 4) that cannot be disabled?

135: Original cell formatting clears when I move contents

136: repetitive items in For each loop

137: In between

138: toggling between open work books

139: filtering/autofill problem

140: Please HELP

141: Automatic Summations

142: How change unprotected cell formats on protected worksheets?

143: Producing a list of all possible combinations

144: Sorting/Adding certian cells

145: About function BAHTTEX

146: How do I set all caps as the default?

147: color of comment lines in vba

148: help with a macro

149: Entering a formula via VBscript

150: Clickable button on worksheet & hiding question

151: Button on Userform calling GetOpenFilename

152: Numbering

153: divide multiline text cell across several rows

154: copy multiple rows from a database

155: Countif or another Solution Needed

156: Need help implementing EPA rounding method

157: Excel Calculation Result Display Failure

158: Extension to Excel INDEX function

159: Running mixed Office components

160: List boxes, Arrays and Sorting

161: Lock cell formats (conditional format)

162: Bookmarks help

163: Excel PageBreaks and the Rows to Count thereof

164: Workbook/sheet protection doesn't seem to work

165: Macro to sort numeric rows left to right

166: Pivot Table Is Not in Order

167: disable F1 after F2

168: formulae to look at 52 sheets &count if 2 cells have data entered

169: userforms / worksheets

170: About workbook_Open madro

171: Moving Average Question? Help

172: rep files in excel

173: Complex Data Validations

174: COUNTIF In The Row Below

175: Re: How to highlight active row and column?

176: How do I link a cell outside a pivot table to one inside the table

177: Passing reports to PowerPoint?

178: Linking worksheets in Excel

179: ListBox Click...

180: VB Editor

181: Reading dates from text file

182: Re-initialising Excel calculation settings

183: How to execute an SQL insert/update from Excel for Mac

184: relative Named Ranges based on worksheet

185: Payback analysis using array SHIFT-CNTRL-ENTER

186: Variant array is empty problem

187: Determine delimiter in csv or txt file

188: Problem with range

189: Close WorkBook with CommandButton

190: Creating xls file via xml getting Run-time error '1004'

191: Executing sub procedure when Excel starts

192: More counting!

193: Vlookup

194: Sorting Grouped Data?

195: DropDown

196: toolbars: form vs control

197: multiple conditions with IF function.

198: random number without repeating?

199: Programming Organisation Charts

200: Excel does not print

201: can I sort names in a column by the last name if it is typed last

202: Please help with auto Date and Time with VBA

203: Question about Sample Size and Margin of Error

204: Auto-Layout Shapes in Excel

205: If Function - Date Problem

206: Breaking a link.

207: Creating fixture lists

208: Run function

209: retaining superscript after a cell merge using =text

210: Value of a data point in a graph

211: Chart Title Reverts Back To Previous Value

212: Excel case

213: Conditional

214: multiple workbooks with common structure

215: Open a new instance with a shortcut

216: Sheet Event

217: Inputbox accepting desired response

218: find method?

219: Color formatting

220: Haw can I to create the numeric counter?

221: subtracting ranges?

222: Cell address

223: Deploying and don't have CD

224: Data searching between sheets

225: Identifying the first date(s) from a list

226: Document formatting problem

227: How to turn off clipboard in Excel 2003

228: Search for Excel worksheet in Windows Explorer using dollar value

229: How can you copy selected cells when one cell contains a specified string?

230: Formula Help

231: SUMPRODUCT

232: Excel 2007 & XP/Vista

233: How to make an image into a command button?

234: Pictures don't move when I sort list

235: Problem using Autofilter

236: Adding A Set Number Once a Week?

237: subroutine variable decleration issue

238: Changing the row reference in a link

239: extracting a remark

240: Subtract working days

241: wrap on

242: Creating Combinations

243: Place The Contents Of A Cell From The Active Worksheet Into A Cell On An Inavtive Worksheet

244: Offset Function

245: External data - change cell color

246: action upon selection

247: Creating new Excel Application problem

248: Problem renaming worksheet

249: optionbutton with worksheet change

250: Transforming pivot table back to the source table

251: search a column for a specific piece of data using vba

252: concatenate cells by a given range

253: Time formulas

254: Various different page headers for one sheet

255: Passwords

256: CAGR formula - Ajit

257: IF statement

258: InpurBox & Directory

259: color hidden columns

260: v-lookup error

261: HELP! run-time error 424

262: COUNTIF

263: Excel Macro to find instances of a word

264: Sum results of VLOOKUP

265: max # of spreadsheets in a workbook Excel 2000?

266: Static Now() function

267: Automating Autofill Coding Question

268: Excel SmartDocument with ActiveX problem

269: Links Between Worksheets

270: Using Property Let with a Type as member of a Class

271: Solver Max Time dialog

272: Hiding a Zero Result

273: Open en close a workbook with password

274: ANY SPECIAL ARRAY OR OTHER FORMULA

275: is there a way to delete all characters to the right of a ":"?

276: VB Excel Range

277: drop down cells with color

278: SUM and font colour

279: does code for this exist? help please

280: Capture value in worksheet & use in macro code

281: Workbooks.Open fails when using a full network path....

282: convert currency to text in Excel ($2,000 to Two Thousand)

283: Create Excel worksheet in .Net

284: Calculation problem

285: Changes in Excel file by *.VBS script without Excel installed

286: Array formula that works columnwise?

287: Creating a Combo Box

288: Fill Searched array with text

289: payroll calculations

290: Listbox Column Count and Width Dont work. Seems Easy

291: macro in vba to display autoshape

292: Referring to multiple worksheets via a variable

293: Finding the lowest mode in a set of numbers

294: use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"

295: Create an array inside a For...Next loop

296: rgb

297: VBA to Make Check Box Entry

298: divide total over linked cell

299: summing a single cell across multiple worksheets

300: display and count the number of times a value appears

2: Excel base 10 log for Optical Density vs %T

3: Referencing Shapes

4: Another way with cell comments.

5: How to create compounded int table?

6: Define a Name

7: How to get Countif to work this out?

8: Populating a Combo Box

9: Getting Run-time error although code looks correct

10: ADO SQL statment

11: sum cells based on criteria in first set of cells

12: Email attachment when someone else has it open

13: how to dynamically import a text file

14: Data Form confusion

15: Sorting ListBox results or transposing ListBox values to other cells for sorting

16: One Record Only

17: How to get different text formats in a concatenate function

18: appending two excel sheets into a third excel sheet.

19: Problem in SQL Query

20: VBA for each sheet in book

21: Sum function for non-continuous range

22: Excel 2000 Code works except in debug mode

23: Create Outlook Task from Data in Excel Row

24: Condition Formating

25: Searching for Duplicate Text in a column

26: VBA: how to... cell properties has to change based on a condition

27: Zoloft 2006

28: Copy from one workbook to another

29: macro to add additional lines

30: Vlookup with wildcard

31: How do I select every nth row?

32: auto fill from moving data?

33: linking pivot tables by page fields

34: How to auto run a macro in actived sheet?

35: Excel 2000 and filter feature in a protected workbook

36: Programming Help - evaluate, select and Past into new workbook

37: Excel UDF Description, Help Keyword, Help File

38: Listbox Question

39: Using variable sized range in CountIf()

40: Syntax error.

41: Excel Terminology

42: Formula error in merged cells

43: Deleting certain string within the string

44: I cant get Excel to work for me..

45: Pass control to a function/subroutine

46: Negative Number put in a certain column in a different sheet.

47: Trying to find Matches and Give a Result

48: case

49: Get List of Keyboard Shortcut Bindings

50: Excel Form and Data Retrieval

51: Over my head on this one...

52: If text exists

53: Sum Column on Array of sheets

54: "read only" statement incorrect

55: How to RANDOMLY split a whole dataset into two sub-dataset?

56: CLick on Box to enter time of day

57: Removing spaces from columns

58: "Difference from" pivot table custom calculation

59: Excel Frozen Sheets

60: How to name a chart for referencing in VBA? And move it.

61: code needed

62: VB Save

63: Help Crafting an Inventory Spreadsheet

64: fill series that runs along opposite axis?

65: Path Name

66: How to split filename from filepath?

67: Charting question

68: commandbutton?

69: Vlookup in large named range

70: Conditional Deleting of Subtotals

71: how do the details in an excel spreadsheet move to a summary page

72: any formula

73: How to change positive numbers to negative numbers without re-ente

74: How do I add a reference to an object library using VBA?

75: Problem with Dialogs(xlDialogWorkbookNew)

76: Macro to open multiple macros

77: Create a single sheet from many sheets

78: Programme Printing of Several Sheets

79: Maybe Mission Impossible...

80: Delete break line between column A & B

81: Added page won't incorporate into original spreadsheet Excel 2003

82: Tough Sumproduct Question

83: ActiveSheet is blank

84: Date and Time

85: using VLOOKUP to condense data on separate spreadsheet

86: Double lookup

87: Assign data to chart series, using array

88: Help me understand Transpose

89: cell auto format

90: CountIf / SumIf or other..

91: How to create a comboboxhandler

92: store the drop down box results in seperate excel sheet

93: Sumproduct not returning expected results

94: Mod function

95: Percentrank function display

96: VB for Apps Confusion

97: Tabels and calculation methods

98: Using Command Button to Hide Columns in another worksheet

99: Digitally signing VBA Project

100: Compiler says "Invalid qualifier" when using Application object

101: Index and match among sheets

102: Dynamically generating a spreadsheet with custom pivot table including data

103: Double sided printing with entire workbook with multiple pages

104: SaveAs Issues

105: Do loop error while using FindNext command

106: Pivot Tables-Calculations?

107: Macro Protection

108: Right text function

109: Open workbook in existing Excel session

110: How to count unique values?

111: Create new commandbar with call procedure

112: Populating Values In One Table With Values From Another Using VBA

113: Getting data from a workbook without opening it

114: Automating a date field to change on certain action

115: Require Minimum Amount When Entering Data

116: How do I make sure all empty columns are present in a .csv file?

117: macro to filter out data

118: Place The Contents Of A Cell From The Active Worksheet Into A Cell On An Inavtive Worksheet

119: Not enough system resources to display completely

120: Excel template issues

121: Sumproduct returns value error when ref is formula

122: convert date to day of week in excel 2003

123: calculate weighted average of stock cost

124: Limiting cell size to 25 characters

125: Excel macro/vba loops

126: Question about references

127: Lotus domino form to excel

128: Listview and colored line

129: SUMPRODUCT question

130: Intelimouse scroll wheel

131: Adding a Name range with vba

132: Deleting Custom Views when Deleting Sheets

133: formula for inserting rows

134: Type of macro (Excel Version 4) that cannot be disabled?

135: Original cell formatting clears when I move contents

136: repetitive items in For each loop

137: In between

138: toggling between open work books

139: filtering/autofill problem

140: Please HELP

141: Automatic Summations

142: How change unprotected cell formats on protected worksheets?

143: Producing a list of all possible combinations

144: Sorting/Adding certian cells

145: About function BAHTTEX

146: How do I set all caps as the default?

147: color of comment lines in vba

148: help with a macro

149: Entering a formula via VBscript

150: Clickable button on worksheet & hiding question

151: Button on Userform calling GetOpenFilename

152: Numbering

153: divide multiline text cell across several rows

154: copy multiple rows from a database

155: Countif or another Solution Needed

156: Need help implementing EPA rounding method

157: Excel Calculation Result Display Failure

158: Extension to Excel INDEX function

159: Running mixed Office components

160: List boxes, Arrays and Sorting

161: Lock cell formats (conditional format)

162: Bookmarks help

163: Excel PageBreaks and the Rows to Count thereof

164: Workbook/sheet protection doesn't seem to work

165: Macro to sort numeric rows left to right

166: Pivot Table Is Not in Order

167: disable F1 after F2

168: formulae to look at 52 sheets &count if 2 cells have data entered

169: userforms / worksheets

170: About workbook_Open madro

171: Moving Average Question? Help

172: rep files in excel

173: Complex Data Validations

174: COUNTIF In The Row Below

175: Re: How to highlight active row and column?

176: How do I link a cell outside a pivot table to one inside the table

177: Passing reports to PowerPoint?

178: Linking worksheets in Excel

179: ListBox Click...

180: VB Editor

181: Reading dates from text file

182: Re-initialising Excel calculation settings

183: How to execute an SQL insert/update from Excel for Mac

184: relative Named Ranges based on worksheet

185: Payback analysis using array SHIFT-CNTRL-ENTER

186: Variant array is empty problem

187: Determine delimiter in csv or txt file

188: Problem with range

189: Close WorkBook with CommandButton

190: Creating xls file via xml getting Run-time error '1004'

191: Executing sub procedure when Excel starts

192: More counting!

193: Vlookup

194: Sorting Grouped Data?

195: DropDown

196: toolbars: form vs control

197: multiple conditions with IF function.

198: random number without repeating?

199: Programming Organisation Charts

200: Excel does not print

201: can I sort names in a column by the last name if it is typed last

202: Please help with auto Date and Time with VBA

203: Question about Sample Size and Margin of Error

204: Auto-Layout Shapes in Excel

205: If Function - Date Problem

206: Breaking a link.

207: Creating fixture lists

208: Run function

209: retaining superscript after a cell merge using =text

210: Value of a data point in a graph

211: Chart Title Reverts Back To Previous Value

212: Excel case

213: Conditional

214: multiple workbooks with common structure

215: Open a new instance with a shortcut

216: Sheet Event

217: Inputbox accepting desired response

218: find method?

219: Color formatting

220: Haw can I to create the numeric counter?

221: subtracting ranges?

222: Cell address

223: Deploying and don't have CD

224: Data searching between sheets

225: Identifying the first date(s) from a list

226: Document formatting problem

227: How to turn off clipboard in Excel 2003

228: Search for Excel worksheet in Windows Explorer using dollar value

229: How can you copy selected cells when one cell contains a specified string?

230: Formula Help

231: SUMPRODUCT

232: Excel 2007 & XP/Vista

233: How to make an image into a command button?

234: Pictures don't move when I sort list

235: Problem using Autofilter

236: Adding A Set Number Once a Week?

237: subroutine variable decleration issue

238: Changing the row reference in a link

239: extracting a remark

240: Subtract working days

241: wrap on

242: Creating Combinations

243: Place The Contents Of A Cell From The Active Worksheet Into A Cell On An Inavtive Worksheet

244: Offset Function

245: External data - change cell color

246: action upon selection

247: Creating new Excel Application problem

248: Problem renaming worksheet

249: optionbutton with worksheet change

250: Transforming pivot table back to the source table

251: search a column for a specific piece of data using vba

252: concatenate cells by a given range

253: Time formulas

254: Various different page headers for one sheet

255: Passwords

256: CAGR formula - Ajit

257: IF statement

258: InpurBox & Directory

259: color hidden columns

260: v-lookup error

261: HELP! run-time error 424

262: COUNTIF

263: Excel Macro to find instances of a word

264: Sum results of VLOOKUP

265: max # of spreadsheets in a workbook Excel 2000?

266: Static Now() function

267: Automating Autofill Coding Question

268: Excel SmartDocument with ActiveX problem

269: Links Between Worksheets

270: Using Property Let with a Type as member of a Class

271: Solver Max Time dialog

272: Hiding a Zero Result

273: Open en close a workbook with password

274: ANY SPECIAL ARRAY OR OTHER FORMULA

275: is there a way to delete all characters to the right of a ":"?

276: VB Excel Range

277: drop down cells with color

278: SUM and font colour

279: does code for this exist? help please

280: Capture value in worksheet & use in macro code

281: Workbooks.Open fails when using a full network path....

282: convert currency to text in Excel ($2,000 to Two Thousand)

283: Create Excel worksheet in .Net

284: Calculation problem

285: Changes in Excel file by *.VBS script without Excel installed

286: Array formula that works columnwise?

287: Creating a Combo Box

288: Fill Searched array with text

289: payroll calculations

290: Listbox Column Count and Width Dont work. Seems Easy

291: macro in vba to display autoshape

292: Referring to multiple worksheets via a variable

293: Finding the lowest mode in a set of numbers

294: use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"

295: Create an array inside a For...Next loop

296: rgb

297: VBA to Make Check Box Entry

298: divide total over linked cell

299: summing a single cell across multiple worksheets

300: display and count the number of times a value appears