Page 115

view full version: back to formated view

1: consolidation of tables in excel with text and figures

2: ControlTips not showing.

3: Passing a value and getting results

4: Adjustable Font Size

5: Public Variable in ThisWorkbook

6: Copying the entire sheet if columns H & G are equal to row.

7: Annual Percentage Rate for Mortgage

8: Pulling a # from a sheet bound text string

9: What does an ampersand mean in VBA?

10: Advanced filtering

11: variable that keeps its value until reset

12: Format as fraction - why doesn't this work?

13: UserForm Activation

14: expanding IF

15: copy from previous page

16: SumIF Question

17: screen updating

18: Double lines

19: Lookup? Match? pulling rows from one spreadsheet to match a text f

20: Code not woring - please help!!!

21: Excel - special sort

22: IF statements and moving data to different columns

23: How to total items if they fall between a date range

24: Number list

25: Hiding Workbooks

26: Save an excel file in vbscript without user prompt

27: Sort data failure

28: SP2 & Self signed Digital Certificate

29: copy all worksheet data into a new worksheet

30: Compile Errors and Missing references

31: How do I activate sort in Excel?

32: remove item from list box

33: Passwords and protection: wordtlengths?

34: Pivot Query

35: SUMPRODUCT - Error #NUM!

36: before variable contains a value

37: copy chart from one sheet to other.

38: Hide row if all cells in another range are blank

39: DocumentPrperties Collection

40: Tab Names

41: how do I get my 2003 excel to recegnize my pocket excel worksheet?

42: Query Folder for Spreadsheets

43: How do I enter time without colons?

44: Help with code

45: Open as Read-Only

46: Merge the data

47: HELP delete duplicate rows.

48: run time error '5'

49: Drop down lists - thanks (and one more query)

50: Access query not returning results

51: MS MAP

52: Read Only Prompt

53: AutoFilter & UserForm

54: Count entries in a range that match a certain criteria within data

55: setting a condition to call a macro

56: Excel 2003

57: Excel 2000: Unprotected cells - how to prevent cursor from wrapping ???

58: Can you convert this formula to 2003 from 2007?

59: disabling always on top

60: How to copy from each sheet and paste to a summary sheet

61: how do i create help text to personal function?

62: COUNTIF a value within a range equals any value in an array/list

63: Open file, copy field and paste into an Excel doc! - Pl help ..

64: PivotCache memory resource Problem

65: Font in Comment Box

66: convert column and row

67: Open two new workbooks with macro

68: formula for matching text

69: VB NEEDED TO SHIFT INITIALS FROM BEGINING OF THE NAME TO END OF THE NAME

70: Fill down to nonblank rows

71: workbook - for cash management

72: OpenText, column separation problem.

73: How do I sendkeys to Interner Explorer from Excel?

74: Excel VBA: Move Userform Based on Active Cell?

75: Custom Properties

76: COUNT IF

77: average without 0 value

78: Temporary Files Creation

79: I know what I need but dont know how to do it

80: Handling a Null Cell in Macro

81: Select a chart without the handles appearing?

82: mailmerge maximum field size

83: VBA problem importing and auditing Unix reports

84: Charts not showing or printing.

85: Copy Filter Selection to a Cell ?

86: My & and TEXT formula is not calculating

87: capture directory listings to Excel

88: Email Header within spreadsheet - how to get rid of?

89: deleting internet links

90: how to send message to multable recipients

91: how to use vba spin boxes in excel

92: Selecting Certain Cells

93: Add method of "Sheets" class fails

94: Multivariate statistics

95: Full path in Active Title Bar

96: How can you have data automatically populate btw workbooks

97: Spin button

98: different between CreatePivotTable and PivotTableWizard

99: continue to move data until all moved

100: ListBox with Horizontal Values

101: MACRO not working on two different files

102: Creating a league table based on results

103: RE: VBA problem

104: deleteing a range from one cell within it?

105: Could someone help me to do that please ?

106: Does some one has a golfscore in excel sheet format

107: SQLOpen VBA

108: comctl1.hlp file file for Treeview Ctl

109: Help to align FORMAT

110: counting 0 in a row

111: Macro to insert data from another sheet stops working

112: Code to bold names within a cell- With a twist

113: PRINTING TWO PAGES TO FIT ON ONE

114: Merging

115: Date Range (Starting & Ending Date) - syed shahzad

116: Excel - User Defined Function Error: This function takes no argume

117: excel

118: Overflow Error

119: What do I use to test this. Not isblank

120: Non repeating random numbers

121: ActiveSheet.QueryTables.Add using InputBox and/or a URL list in a .txt file list

122: Can I delete an entire row if condition is not met?

123: Why does text in posts re-format?

124: PasteSpecial issue

125: Where should the code be stored? (Excel97)

126: formula will not fill correctly due to odd number rows

127: SumProduct Function

128: Chart Y-axis definition. Limitation for Maximum characters ?

129: Range.Select with variable cells ?

130: 2 nice requests

131: count all the text in red

132: How can I list values in a combo box?

133: Removing Rows for Printing

134: need help with nested for-next loops

135: Multiple Criteria and Adding Them Together

136: keeping one cell constant

137: undo date format questions

138: Excel Function

139: Decimal place + - button use in protected worksheet

140: add "0" to the beginning of each value

141: How can I add values to a closed excel file?

142: Opening Excel

143: Date

144: Speical Characters and Macros

145: Macro to remove ";"

146: Deleting Unique Rows

147: Menus Delete vs Reset

148: Applying a formula to a broad range of numbers.

149: Formula Question

150: Date format in a text string

151: Military Time Data Entry

152: equal sign in front of date in formual bar

153: Use both ISNA and ISERROR in a long formula

154: weird saving of a document with macros resulting with macros being transfered to the copy

155: Locked cells

156: Excel should automaticaly update a feild when printing ex:Version

157: What formula can i use to add time?

158: Avoiding a range in recalculation

159: Excel

160: Excel VBA talking to Excel COM Add-in

161: Summarising/Counting variable data

162: Choose Which Macro to use

163: Naming working sheets

164: Myrna Larson, locate??

165: absolute function - range

166: Best research method

167: Urgent help!!!! VBA

168: Import a word document

169: COM + Excel + Win2k3 Standard Version + IIS6

170: How to write code for find a word in excel?

171: AutoSum for variable number of cells

172: Creating a toolbar

173: Unidentical VLOOKUP

174: Formatting Numbers in Excel 2003

175: Find?

176: Updateting Oracle from Excel

177: calculate time in the building

178: help needed

179: Cannot Sort: Help Please

180: Excel VBA-open & save all delimited files

181: 'vlookup' and/or 'if' help!

182: Listbox Item Focus

183: messagebox without default button

184: Tabulating Player Positions

185: Excel error

186: Text Manipulation from PDF

187: Check value and add to list

188: Last "Numeric Value" in a column of formulas

189: Seeking Book Recommendation

190: IF Command Help

191: Total Different Cells

192: Accessing File Properties

193: how to save to Access

194: UnauthorisedAccessException

195: Drop Down Menu Help

196: MailMerge from Excel 2000 using self as datasource

197: Print certain cells

198: help with formula

199: Vlookup?

200: Code to include a one-up suffix to a field value

201: Get External Data VBA

202: Putting text in a cell

203: Adding minutes.

204: Invalid References

205: Grouping data and pivot tables

206: Finding Overlapping Data

207: Inhibit Cut (allow Copy)

208: Retrieving data from a table

209: Keep Values and Formulas

210: current worksheet

211: experts help required plz

212: Changing Range in Forms Drop Down Without Selecting

213: Linking a Summary Workbook

214: How do I interpret Regression alanysed data ?

215: Create Folder with VBA

216: Break Chart Links

217: how do I remove the e-mail view on my excel sheet?

218: Formulas behaving badly

219: Find Method problem in Excel VBA....

220: Get Last Day of Month

221: Environ user tracking

222: data validation

223: Functions that will move info to a different location in column

224: Linking Excel to a Word Document

225: Save As File Type

226: Access problems with Excel spreadsheet

227: Data Tables

228: what are you going to do NOW, Harlan?

229: Setting Font properties in Code clears Undo list

230: Macro help

231: Frozen Panes and Visible Graphs...Marti

232: Removing Add-ins programmatically from Excel 2003 using VBScript

233: Excel taking too long to open up

234: insert 'x' number of rows in excel

235: Cubic splines

236: Changing data in a column

237: Conditional number format of cell

238: touche F4 défaillante

239: question about SUMPRODUCT

240: copying text from one group of cells and putting them in a table?

241: Excel 2007 and the context-menu mini toolbar

242: Merge Rows of like data

243: Can outdated cells transfer automatically?

244: I was using Excel 2007, now 2003 and my Macros won't work

245: Find last number

246: Form Question

247: Excel: Is it possible to count the number of "yes" answers?

248: Permissions

249: appearance of cursor/cell outline box

250: Applying background color to cells

251: Cell value programming question

252: Checking user has input a valid address.

253: Virus Protection Workaround??

254: Move file to a different folder

255: Adobe using VB

256: formatting a macro

257: Alternating background row colour

258: Data Validation Input Message Box Position Frozen

259: Show date in cell if data changes

260: drop down lists and forms

261: How to get data from server?

262: Using Lookup on an expanding list

263: Meal Break on Time Sheet in Excel

264: Any examples of VBA and Amazon Web Services (ECS) Programs???

265: What is the fastest way to bulk load data into Excel?

266: comparison

267: Add text to cells

268: Checkbox macro

269: Hide ALL dropdowns on autofilter

270: Adding Zeros in front of numbers in cells using Excel 2003

271: Activating the next cell

272: Return a value if 2 Conditions apply

273: HAPPY NEW YEAR !!!

274: paste formula to each cell in a column without changing values

275: Getting a range from Excel into a Word document

276: VB Forms

277: macro security

278: if - then actions

279: List the contents of a directory

280: auto expand row hieght of merged cells

281: range values in an array?

282: Excel/Access

283: Count Column Difference

284: TextBox Validation - Time Format

285: ignore this posting test (sorry)

286: Fill Series

287: mscal issue

288: How do i link an entire source wksheet to a dest' wksheet

289: VBA Imaginary Breakpoints Error

290: how can i have one cell always go up 1 number?

291: manually entering data in a cell with formula w/o losing the formu

292: auto calculate not working

293: XLA calls dll

294: How do you "Find" on NonActive Page & Return Values?

295: Rows(arguments)???

296: vba code for inserting formula

297: VB Excel file multiple opening from a folder problem

298: Can't save new file in Excel 2003

299: Write macro don't ask to save when exit excel

300: Find Next problem

2: ControlTips not showing.

3: Passing a value and getting results

4: Adjustable Font Size

5: Public Variable in ThisWorkbook

6: Copying the entire sheet if columns H & G are equal to row.

7: Annual Percentage Rate for Mortgage

8: Pulling a # from a sheet bound text string

9: What does an ampersand mean in VBA?

10: Advanced filtering

11: variable that keeps its value until reset

12: Format as fraction - why doesn't this work?

13: UserForm Activation

14: expanding IF

15: copy from previous page

16: SumIF Question

17: screen updating

18: Double lines

19: Lookup? Match? pulling rows from one spreadsheet to match a text f

20: Code not woring - please help!!!

21: Excel - special sort

22: IF statements and moving data to different columns

23: How to total items if they fall between a date range

24: Number list

25: Hiding Workbooks

26: Save an excel file in vbscript without user prompt

27: Sort data failure

28: SP2 & Self signed Digital Certificate

29: copy all worksheet data into a new worksheet

30: Compile Errors and Missing references

31: How do I activate sort in Excel?

32: remove item from list box

33: Passwords and protection: wordtlengths?

34: Pivot Query

35: SUMPRODUCT - Error #NUM!

36: before variable contains a value

37: copy chart from one sheet to other.

38: Hide row if all cells in another range are blank

39: DocumentPrperties Collection

40: Tab Names

41: how do I get my 2003 excel to recegnize my pocket excel worksheet?

42: Query Folder for Spreadsheets

43: How do I enter time without colons?

44: Help with code

45: Open as Read-Only

46: Merge the data

47: HELP delete duplicate rows.

48: run time error '5'

49: Drop down lists - thanks (and one more query)

50: Access query not returning results

51: MS MAP

52: Read Only Prompt

53: AutoFilter & UserForm

54: Count entries in a range that match a certain criteria within data

55: setting a condition to call a macro

56: Excel 2003

57: Excel 2000: Unprotected cells - how to prevent cursor from wrapping ???

58: Can you convert this formula to 2003 from 2007?

59: disabling always on top

60: How to copy from each sheet and paste to a summary sheet

61: how do i create help text to personal function?

62: COUNTIF a value within a range equals any value in an array/list

63: Open file, copy field and paste into an Excel doc! - Pl help ..

64: PivotCache memory resource Problem

65: Font in Comment Box

66: convert column and row

67: Open two new workbooks with macro

68: formula for matching text

69: VB NEEDED TO SHIFT INITIALS FROM BEGINING OF THE NAME TO END OF THE NAME

70: Fill down to nonblank rows

71: workbook - for cash management

72: OpenText, column separation problem.

73: How do I sendkeys to Interner Explorer from Excel?

74: Excel VBA: Move Userform Based on Active Cell?

75: Custom Properties

76: COUNT IF

77: average without 0 value

78: Temporary Files Creation

79: I know what I need but dont know how to do it

80: Handling a Null Cell in Macro

81: Select a chart without the handles appearing?

82: mailmerge maximum field size

83: VBA problem importing and auditing Unix reports

84: Charts not showing or printing.

85: Copy Filter Selection to a Cell ?

86: My & and TEXT formula is not calculating

87: capture directory listings to Excel

88: Email Header within spreadsheet - how to get rid of?

89: deleting internet links

90: how to send message to multable recipients

91: how to use vba spin boxes in excel

92: Selecting Certain Cells

93: Add method of "Sheets" class fails

94: Multivariate statistics

95: Full path in Active Title Bar

96: How can you have data automatically populate btw workbooks

97: Spin button

98: different between CreatePivotTable and PivotTableWizard

99: continue to move data until all moved

100: ListBox with Horizontal Values

101: MACRO not working on two different files

102: Creating a league table based on results

103: RE: VBA problem

104: deleteing a range from one cell within it?

105: Could someone help me to do that please ?

106: Does some one has a golfscore in excel sheet format

107: SQLOpen VBA

108: comctl1.hlp file file for Treeview Ctl

109: Help to align FORMAT

110: counting 0 in a row

111: Macro to insert data from another sheet stops working

112: Code to bold names within a cell- With a twist

113: PRINTING TWO PAGES TO FIT ON ONE

114: Merging

115: Date Range (Starting & Ending Date) - syed shahzad

116: Excel - User Defined Function Error: This function takes no argume

117: excel

118: Overflow Error

119: What do I use to test this. Not isblank

120: Non repeating random numbers

121: ActiveSheet.QueryTables.Add using InputBox and/or a URL list in a .txt file list

122: Can I delete an entire row if condition is not met?

123: Why does text in posts re-format?

124: PasteSpecial issue

125: Where should the code be stored? (Excel97)

126: formula will not fill correctly due to odd number rows

127: SumProduct Function

128: Chart Y-axis definition. Limitation for Maximum characters ?

129: Range.Select with variable cells ?

130: 2 nice requests

131: count all the text in red

132: How can I list values in a combo box?

133: Removing Rows for Printing

134: need help with nested for-next loops

135: Multiple Criteria and Adding Them Together

136: keeping one cell constant

137: undo date format questions

138: Excel Function

139: Decimal place + - button use in protected worksheet

140: add "0" to the beginning of each value

141: How can I add values to a closed excel file?

142: Opening Excel

143: Date

144: Speical Characters and Macros

145: Macro to remove ";"

146: Deleting Unique Rows

147: Menus Delete vs Reset

148: Applying a formula to a broad range of numbers.

149: Formula Question

150: Date format in a text string

151: Military Time Data Entry

152: equal sign in front of date in formual bar

153: Use both ISNA and ISERROR in a long formula

154: weird saving of a document with macros resulting with macros being transfered to the copy

155: Locked cells

156: Excel should automaticaly update a feild when printing ex:Version

157: What formula can i use to add time?

158: Avoiding a range in recalculation

159: Excel

160: Excel VBA talking to Excel COM Add-in

161: Summarising/Counting variable data

162: Choose Which Macro to use

163: Naming working sheets

164: Myrna Larson, locate??

165: absolute function - range

166: Best research method

167: Urgent help!!!! VBA

168: Import a word document

169: COM + Excel + Win2k3 Standard Version + IIS6

170: How to write code for find a word in excel?

171: AutoSum for variable number of cells

172: Creating a toolbar

173: Unidentical VLOOKUP

174: Formatting Numbers in Excel 2003

175: Find?

176: Updateting Oracle from Excel

177: calculate time in the building

178: help needed

179: Cannot Sort: Help Please

180: Excel VBA-open & save all delimited files

181: 'vlookup' and/or 'if' help!

182: Listbox Item Focus

183: messagebox without default button

184: Tabulating Player Positions

185: Excel error

186: Text Manipulation from PDF

187: Check value and add to list

188: Last "Numeric Value" in a column of formulas

189: Seeking Book Recommendation

190: IF Command Help

191: Total Different Cells

192: Accessing File Properties

193: how to save to Access

194: UnauthorisedAccessException

195: Drop Down Menu Help

196: MailMerge from Excel 2000 using self as datasource

197: Print certain cells

198: help with formula

199: Vlookup?

200: Code to include a one-up suffix to a field value

201: Get External Data VBA

202: Putting text in a cell

203: Adding minutes.

204: Invalid References

205: Grouping data and pivot tables

206: Finding Overlapping Data

207: Inhibit Cut (allow Copy)

208: Retrieving data from a table

209: Keep Values and Formulas

210: current worksheet

211: experts help required plz

212: Changing Range in Forms Drop Down Without Selecting

213: Linking a Summary Workbook

214: How do I interpret Regression alanysed data ?

215: Create Folder with VBA

216: Break Chart Links

217: how do I remove the e-mail view on my excel sheet?

218: Formulas behaving badly

219: Find Method problem in Excel VBA....

220: Get Last Day of Month

221: Environ user tracking

222: data validation

223: Functions that will move info to a different location in column

224: Linking Excel to a Word Document

225: Save As File Type

226: Access problems with Excel spreadsheet

227: Data Tables

228: what are you going to do NOW, Harlan?

229: Setting Font properties in Code clears Undo list

230: Macro help

231: Frozen Panes and Visible Graphs...Marti

232: Removing Add-ins programmatically from Excel 2003 using VBScript

233: Excel taking too long to open up

234: insert 'x' number of rows in excel

235: Cubic splines

236: Changing data in a column

237: Conditional number format of cell

238: touche F4 défaillante

239: question about SUMPRODUCT

240: copying text from one group of cells and putting them in a table?

241: Excel 2007 and the context-menu mini toolbar

242: Merge Rows of like data

243: Can outdated cells transfer automatically?

244: I was using Excel 2007, now 2003 and my Macros won't work

245: Find last number

246: Form Question

247: Excel: Is it possible to count the number of "yes" answers?

248: Permissions

249: appearance of cursor/cell outline box

250: Applying background color to cells

251: Cell value programming question

252: Checking user has input a valid address.

253: Virus Protection Workaround??

254: Move file to a different folder

255: Adobe using VB

256: formatting a macro

257: Alternating background row colour

258: Data Validation Input Message Box Position Frozen

259: Show date in cell if data changes

260: drop down lists and forms

261: How to get data from server?

262: Using Lookup on an expanding list

263: Meal Break on Time Sheet in Excel

264: Any examples of VBA and Amazon Web Services (ECS) Programs???

265: What is the fastest way to bulk load data into Excel?

266: comparison

267: Add text to cells

268: Checkbox macro

269: Hide ALL dropdowns on autofilter

270: Adding Zeros in front of numbers in cells using Excel 2003

271: Activating the next cell

272: Return a value if 2 Conditions apply

273: HAPPY NEW YEAR !!!

274: paste formula to each cell in a column without changing values

275: Getting a range from Excel into a Word document

276: VB Forms

277: macro security

278: if - then actions

279: List the contents of a directory

280: auto expand row hieght of merged cells

281: range values in an array?

282: Excel/Access

283: Count Column Difference

284: TextBox Validation - Time Format

285: ignore this posting test (sorry)

286: Fill Series

287: mscal issue

288: How do i link an entire source wksheet to a dest' wksheet

289: VBA Imaginary Breakpoints Error

290: how can i have one cell always go up 1 number?

291: manually entering data in a cell with formula w/o losing the formu

292: auto calculate not working

293: XLA calls dll

294: How do you "Find" on NonActive Page & Return Values?

295: Rows(arguments)???

296: vba code for inserting formula

297: VB Excel file multiple opening from a folder problem

298: Can't save new file in Excel 2003

299: Write macro don't ask to save when exit excel

300: Find Next problem