Page 323

view full version: back to formated view

1: Count Occurrences and Print Total

2: How to use VBA to set "update changes" automatically every 5 min on a shared file?

3: Rename active sheet to contents of specific cell

4: text in a cell upon entering the cell

5: IF formulas

6: Running total w/2 columns - Excel

7: Grabbing Data from another File

8: Enter login details on a web page using macro

9: Sum the ranges

10: result is Zero on every maths functions - sum, multiplication ... etc

11: Bad QueryTable Row Count

12: row number in Excel

13: Detect Comment + Happy Christmas

14: conditional formatting 24-hour clock

15: Remove color when printing?

16: Setting a Worksheets Codename to a variable programmatically

17: Entering data

18: hide a worksheet so that a macro can still find it

19: How to Connect Data with ComboBoxes and Dependency on each other

20: M'I`5'Persecuti on the BBC, televis ion a nd radio

21: how do I merge cells into one then delete the original cells?

22: calculating probabilty of x number of successes with multiple tria

23: Pass Parameter to Access Query

24: Extra Line Space

25: update excel

26: VBA : xlDialogPrint function

27: Finding Unique Entries Among Two Columns

28: Test Only

29: Freeze when toggling from UserForm to Spreadsheet

30: Strange Occurrence

31: Time formatting

32: sequential date related question

33: Remove Excess

34: macro to copy to another workbook

35: Alter code

36: Changing XL97 Application Icon

37: Dispaly message

38: Subtotal and Names - Excel 2003

39: Tracing Links

40: Excel 97

41: Personal.xls "Before Print"

42: Using loop for selection macro

43: Error 448

44: Pivot Table - Adding a % of Total Column along with Grand Total

45: sheet copy method fails...

46: ADODB Connection String

47: Finding an external update

48: how to print label on the very end of excel sheet

49: ActiveWorkbook.SaveAs FileName;= 'sequential

50: save as txt saves different tab, why???

51: option view (Sheet Tabs)

52: Extracting values from multiple EXCEL spreadsheets into one

53: index match with blank entries

54: combinations

55: How do you keep source values on a Pivot Table w/o formulas?

56: How to convert xls to plain ascii text.

57: Saving and Sending Custom Buttons

58: Extract select group of numbers

59: how do I set a button in a sprdsheet to email that sprdsheet to me

60: Is this Possible

61: Date affected cell referencing

62: EXCEL data sorting

63: Help on Run-time error after "Save As"

64: numers extracting??

65: zip codes starting with a "0" in excel

66: "program shortcut keys in Excel"

67: excel path incorrect problem

68: Microsoft Calendar Control

69: Userform & crash

70: Excel dislikes searching *.zip in WinXPPro

71: Formatting text

72: How to display formula instead value?

73: Referring to named ranges in a macro

74: spreadsheet no holding format

75: Thank You Helpers!

76: COUNTIF With two criteria

77: Converting numbers to column letters

78: Hyperlink to another Workbook (97)

79: How do you remove all the symbols?

80: worksheets

81: Determine real colour of automatic line colours?

82: is there spelling check function in excel 2000?

83: Is sheet protected

84: Accessing solver in XL2003 from vb

85: How can I link from an external website to a particular worksheet

86: Service Charge Formula

87: Copy and paste between workbooks?

88: Use a formula to populate a label from a textbox

89: Want to Convert #REF! to Zeros

90: Opening Text File From internet

91: vlookup function in excel doesn't work in the german version - translation name?

92: SUMIF with two or more variables

93: conditional formula

94: formula question

95: adding a colon to military time

96: Sub checker

97: Change the MSGBOX

98: Help with a Lookup Formula

99: ActiveCell.Value changes with Format?

100: Opening .xlsm workbooks in older versions of excel

101: Summing visible column values but not hidden column values

102: How to calculate the area under a curve?

103: Writing Localized Strings In Cells Using Automation

104: Hiding controls with rows

105: In Excel how do I get 2 zeros to show automatically after I enter.

106: Maximization of a Cell

107: Select Cells in Print Area

108: 25 changes to 35

109: Loop through worksheets to unhide rows

110: Number convert in to text ?

111: How to unhide worksheet tabs in Excel 2007?

112: Calculating Column and off setting calculated value to another column

113: Insert Rows Macro

114: Validation list not showing in cell

115: Tab Key Behavior

116: Change Print Command or add a new print command

117: How do I save more then one Excel worksheet to .csv file format?

118: vlookup

119: calculating the average of formula results

120: Matching Two Text Strings to see if Like

121: Drop Down List

122: blank rows macro question

123: How to trace a function f(x) in excel?

124: Undo macros

125: Application events

126: Code to show current hour minute and seconds in a cell

127: "Could not locate some objects...."

128: simple? question about ranges

129: Inserting Value from one cell to another

130: sorting

131: Multi-selection problem in Excel XP and 2003

132: 2 small problems

133: multline option button alignment

134: Time Calc

135: Print If statement...

136: Excel File Open and Locking Issue

137: Pulling conversion rates

138: 15

139: Reference external worksheet whose name is in a cell

140: Column of Data - Set Next Column Value Conditionally

141: Functions for Headers/Footer

142: worksheetfunction.transpose - nx1 to n element?

143: Save as *.htm with grid lines

144: Countif using vba

145: Alter text

146: calculation of partial shipments

147: Find last col with data

148: help with formula for bolding font

149: Saving Excel workbook in SQL server using c#

150: Help with compiler error

151: Control ComboBoxes & Worksheet Protection

152: change column width

153: this macro is slowing down my spreadsheet

154: Loop,Compare,Write

155: Control save prompts in VB code

156: How to refer variable while assigning string value?

157: Number of Conditional Formats

158: If statements

159: Function or Macro ?

160: Excel 2003 SP2

161: Analysis ToolPack For Excel 2002

162: numbering of rows

163: Compilers for Excel to create exe programs

164: Forcing Caps

165: Is this an array question?

166: Finding last row in a column

167: Ranking or sorting function

168: Formula & Dates

169: Pivot Tables, refreshing with additional data

170: sequential numbering when printing

171: Running Custom Code if "Entire Workbook" is Selected for Printing

172: Custom Footer

173: CUBE file

174: Round Time to 30 minutes

175: data validation

176: Insert into existing code

177: change cell shading when a number differs from the previous number

178: How to copy only some rows from range based on condition?

179: VLOOKUP Problem

180: Hide Row Numbers Only

181: Will Excel import a spooled file to look the same every month?

182: Face ID

183: Copy Modified Worksheet 1 Data to Worksheet 2

184: Newbie question

185: Nested if formula

186: Splitting a file with lookup functions into smaller parts

187: cell bar always lit

188: Using Column in Sumproduct

189: Formatting a cell in Excel, using pure VB code

190: "Method or Data Member Not Found"

191: Excel VBA to VB6 Conversion

192: Date formatting from text

193: 2003 compatibility with earlier versions

194: delete all the spreadsheet

195: Finding all Combinations...

196: Formula for comparing a date to today's date

197: Help for excel webform

198: numeric value

199: Help deffining public variables in userform1

200: Excel VBA - problem with adding item to Tools menu

201: To duplicate a row

202: Round dates to next Saturday

203: Draw down analysis

204: Kilos to Stones & Pounds

205: how to paste values created by custom format?

206: Excel keeps Calculating when Auto calculate is turned off

207: Cell Fomula

208: how do i open file for input

209: Sheet Tab name

210: Delete Multiple sheets

211: use vba function in formula

212: How to have a userform displayed and be able to work in a different spreadsheet

213: Cells in a column in half?

214: When I "Save As" I cannot get

215: About form messsage

216: lookup formulas to obtain multiple results

217: Excel 95 Vs Excel 2000

218: USENET Forum FAQs (Everyone Must Read!)

219: Help with programming

220: copied formula has correct cell reference, but result of original

221: need a macro plz...

222: Making a button in an Excel Spreadsheet to export to another

223: Disabling worksheet_change when deleting rows . .

224: Saving to subdirectory using date()

225: Sorting a Simple table

226: Create an array of all open workbooks

227: add zeros

228: script detecting the change of active cell

229: Making the date a part of the file name

230: Finding a value in a cell matching up with a column/row

231: Programmatically make cell pointer invisible

232: GetValue from closed workbook

233: IF(ISERROR function

234: Compare cells and insert row

235: Cell referencing

236: VLOOOKUP Please help

237: Getting rid of curly brackets within formula

238: Opening and deleting File with only partial Filename

239: Column Widths help ?

240: Check boxes

241: Importing Access data

242: What does ISERROR look at besides the 7 Error Types?

243: suppressing table header on a page

244: how can i protect the vba codes

245: I would like to use conditional formatting for 4 or more items.

246: filter format

247: graph points european

248: How to open a spreadsheet and make changes to it from code?

249: Using Dialog Boxes

250: Page numbers

251: Any ideas for a more customized data entry?

252: Excel Message Boxes

253: how to protect a word art in excel from edit

254: Data from another cell

255: How come ?

256: Custom Dates (VBA)

257: Emi & Fv!

258: Keydown Problem

259: Consolidate Ranges into 1 Workbook

260: Excel Comments

261: Automate cut paste

262: =?Utf-8?Q?Classifica=C3=A7=C3=A3o?=

263: New Work Project - Rent Comparability Database

264: how to count without included duplicate records

265: Echo off

266: data linked to files in shared computer

267: Inventory Age

268: Default file locations

269: Can I run a parameterized macro with medium security?

270: adding sheets together

271: Problems with XLA:s

272: EDITING TOOLBAR MAIL MERGE

273: How do I delete data,formula,and formating PERMENENTLY?

274: Type Mismatch on some PCs

275: Excel vx Application

276: VBA code to Autofill one cell to many rows below where row count will change

277: Moving up one cell

278: EXCEL charting in 3-D? How do I...

279: Copying information from 1 WB to another and loosing style

280: How do I group multiple data entries in sub-groups

281: Read folder access rights

282: Replacing subtotal with a formula

283: Further to macros

284: Importing files

285: Copy from sheet and paste to last row used

286: Finding the average across multiple sheets

287: Finding a Linked Cell

288: Update a Date Quarterly

289: Insert a formula down 50,000 rows

290: Macros

291: Round up to 3

292: range names

293: Conditional Formatting

294: linking Excel to Outlook

295: Need Help. Double clicking an excel file ...

296: Lock cell reference in formula, even when moved with click & drag

297: conditional actions

298: Sum of numbers in a matrix...

299: Is there a workaround with #REF error message?

2: How to use VBA to set "update changes" automatically every 5 min on a shared file?

3: Rename active sheet to contents of specific cell

4: text in a cell upon entering the cell

5: IF formulas

6: Running total w/2 columns - Excel

7: Grabbing Data from another File

8: Enter login details on a web page using macro

9: Sum the ranges

10: result is Zero on every maths functions - sum, multiplication ... etc

11: Bad QueryTable Row Count

12: row number in Excel

13: Detect Comment + Happy Christmas

14: conditional formatting 24-hour clock

15: Remove color when printing?

16: Setting a Worksheets Codename to a variable programmatically

17: Entering data

18: hide a worksheet so that a macro can still find it

19: How to Connect Data with ComboBoxes and Dependency on each other

20: M'I`5'Persecuti on the BBC, televis ion a nd radio

21: how do I merge cells into one then delete the original cells?

22: calculating probabilty of x number of successes with multiple tria

23: Pass Parameter to Access Query

24: Extra Line Space

25: update excel

26: VBA : xlDialogPrint function

27: Finding Unique Entries Among Two Columns

28: Test Only

29: Freeze when toggling from UserForm to Spreadsheet

30: Strange Occurrence

31: Time formatting

32: sequential date related question

33: Remove Excess

34: macro to copy to another workbook

35: Alter code

36: Changing XL97 Application Icon

37: Dispaly message

38: Subtotal and Names - Excel 2003

39: Tracing Links

40: Excel 97

41: Personal.xls "Before Print"

42: Using loop for selection macro

43: Error 448

44: Pivot Table - Adding a % of Total Column along with Grand Total

45: sheet copy method fails...

46: ADODB Connection String

47: Finding an external update

48: how to print label on the very end of excel sheet

49: ActiveWorkbook.SaveAs FileName;= 'sequential

50: save as txt saves different tab, why???

51: option view (Sheet Tabs)

52: Extracting values from multiple EXCEL spreadsheets into one

53: index match with blank entries

54: combinations

55: How do you keep source values on a Pivot Table w/o formulas?

56: How to convert xls to plain ascii text.

57: Saving and Sending Custom Buttons

58: Extract select group of numbers

59: how do I set a button in a sprdsheet to email that sprdsheet to me

60: Is this Possible

61: Date affected cell referencing

62: EXCEL data sorting

63: Help on Run-time error after "Save As"

64: numers extracting??

65: zip codes starting with a "0" in excel

66: "program shortcut keys in Excel"

67: excel path incorrect problem

68: Microsoft Calendar Control

69: Userform & crash

70: Excel dislikes searching *.zip in WinXPPro

71: Formatting text

72: How to display formula instead value?

73: Referring to named ranges in a macro

74: spreadsheet no holding format

75: Thank You Helpers!

76: COUNTIF With two criteria

77: Converting numbers to column letters

78: Hyperlink to another Workbook (97)

79: How do you remove all the symbols?

80: worksheets

81: Determine real colour of automatic line colours?

82: is there spelling check function in excel 2000?

83: Is sheet protected

84: Accessing solver in XL2003 from vb

85: How can I link from an external website to a particular worksheet

86: Service Charge Formula

87: Copy and paste between workbooks?

88: Use a formula to populate a label from a textbox

89: Want to Convert #REF! to Zeros

90: Opening Text File From internet

91: vlookup function in excel doesn't work in the german version - translation name?

92: SUMIF with two or more variables

93: conditional formula

94: formula question

95: adding a colon to military time

96: Sub checker

97: Change the MSGBOX

98: Help with a Lookup Formula

99: ActiveCell.Value changes with Format?

100: Opening .xlsm workbooks in older versions of excel

101: Summing visible column values but not hidden column values

102: How to calculate the area under a curve?

103: Writing Localized Strings In Cells Using Automation

104: Hiding controls with rows

105: In Excel how do I get 2 zeros to show automatically after I enter.

106: Maximization of a Cell

107: Select Cells in Print Area

108: 25 changes to 35

109: Loop through worksheets to unhide rows

110: Number convert in to text ?

111: How to unhide worksheet tabs in Excel 2007?

112: Calculating Column and off setting calculated value to another column

113: Insert Rows Macro

114: Validation list not showing in cell

115: Tab Key Behavior

116: Change Print Command or add a new print command

117: How do I save more then one Excel worksheet to .csv file format?

118: vlookup

119: calculating the average of formula results

120: Matching Two Text Strings to see if Like

121: Drop Down List

122: blank rows macro question

123: How to trace a function f(x) in excel?

124: Undo macros

125: Application events

126: Code to show current hour minute and seconds in a cell

127: "Could not locate some objects...."

128: simple? question about ranges

129: Inserting Value from one cell to another

130: sorting

131: Multi-selection problem in Excel XP and 2003

132: 2 small problems

133: multline option button alignment

134: Time Calc

135: Print If statement...

136: Excel File Open and Locking Issue

137: Pulling conversion rates

138: 15

139: Reference external worksheet whose name is in a cell

140: Column of Data - Set Next Column Value Conditionally

141: Functions for Headers/Footer

142: worksheetfunction.transpose - nx1 to n element?

143: Save as *.htm with grid lines

144: Countif using vba

145: Alter text

146: calculation of partial shipments

147: Find last col with data

148: help with formula for bolding font

149: Saving Excel workbook in SQL server using c#

150: Help with compiler error

151: Control ComboBoxes & Worksheet Protection

152: change column width

153: this macro is slowing down my spreadsheet

154: Loop,Compare,Write

155: Control save prompts in VB code

156: How to refer variable while assigning string value?

157: Number of Conditional Formats

158: If statements

159: Function or Macro ?

160: Excel 2003 SP2

161: Analysis ToolPack For Excel 2002

162: numbering of rows

163: Compilers for Excel to create exe programs

164: Forcing Caps

165: Is this an array question?

166: Finding last row in a column

167: Ranking or sorting function

168: Formula & Dates

169: Pivot Tables, refreshing with additional data

170: sequential numbering when printing

171: Running Custom Code if "Entire Workbook" is Selected for Printing

172: Custom Footer

173: CUBE file

174: Round Time to 30 minutes

175: data validation

176: Insert into existing code

177: change cell shading when a number differs from the previous number

178: How to copy only some rows from range based on condition?

179: VLOOKUP Problem

180: Hide Row Numbers Only

181: Will Excel import a spooled file to look the same every month?

182: Face ID

183: Copy Modified Worksheet 1 Data to Worksheet 2

184: Newbie question

185: Nested if formula

186: Splitting a file with lookup functions into smaller parts

187: cell bar always lit

188: Using Column in Sumproduct

189: Formatting a cell in Excel, using pure VB code

190: "Method or Data Member Not Found"

191: Excel VBA to VB6 Conversion

192: Date formatting from text

193: 2003 compatibility with earlier versions

194: delete all the spreadsheet

195: Finding all Combinations...

196: Formula for comparing a date to today's date

197: Help for excel webform

198: numeric value

199: Help deffining public variables in userform1

200: Excel VBA - problem with adding item to Tools menu

201: To duplicate a row

202: Round dates to next Saturday

203: Draw down analysis

204: Kilos to Stones & Pounds

205: how to paste values created by custom format?

206: Excel keeps Calculating when Auto calculate is turned off

207: Cell Fomula

208: how do i open file for input

209: Sheet Tab name

210: Delete Multiple sheets

211: use vba function in formula

212: How to have a userform displayed and be able to work in a different spreadsheet

213: Cells in a column in half?

214: When I "Save As" I cannot get

215: About form messsage

216: lookup formulas to obtain multiple results

217: Excel 95 Vs Excel 2000

218: USENET Forum FAQs (Everyone Must Read!)

219: Help with programming

220: copied formula has correct cell reference, but result of original

221: need a macro plz...

222: Making a button in an Excel Spreadsheet to export to another

223: Disabling worksheet_change when deleting rows . .

224: Saving to subdirectory using date()

225: Sorting a Simple table

226: Create an array of all open workbooks

227: add zeros

228: script detecting the change of active cell

229: Making the date a part of the file name

230: Finding a value in a cell matching up with a column/row

231: Programmatically make cell pointer invisible

232: GetValue from closed workbook

233: IF(ISERROR function

234: Compare cells and insert row

235: Cell referencing

236: VLOOOKUP Please help

237: Getting rid of curly brackets within formula

238: Opening and deleting File with only partial Filename

239: Column Widths help ?

240: Check boxes

241: Importing Access data

242: What does ISERROR look at besides the 7 Error Types?

243: suppressing table header on a page

244: how can i protect the vba codes

245: I would like to use conditional formatting for 4 or more items.

246: filter format

247: graph points european

248: How to open a spreadsheet and make changes to it from code?

249: Using Dialog Boxes

250: Page numbers

251: Any ideas for a more customized data entry?

252: Excel Message Boxes

253: how to protect a word art in excel from edit

254: Data from another cell

255: How come ?

256: Custom Dates (VBA)

257: Emi & Fv!

258: Keydown Problem

259: Consolidate Ranges into 1 Workbook

260: Excel Comments

261: Automate cut paste

262: =?Utf-8?Q?Classifica=C3=A7=C3=A3o?=

263: New Work Project - Rent Comparability Database

264: how to count without included duplicate records

265: Echo off

266: data linked to files in shared computer

267: Inventory Age

268: Default file locations

269: Can I run a parameterized macro with medium security?

270: adding sheets together

271: Problems with XLA:s

272: EDITING TOOLBAR MAIL MERGE

273: How do I delete data,formula,and formating PERMENENTLY?

274: Type Mismatch on some PCs

275: Excel vx Application

276: VBA code to Autofill one cell to many rows below where row count will change

277: Moving up one cell

278: EXCEL charting in 3-D? How do I...

279: Copying information from 1 WB to another and loosing style

280: How do I group multiple data entries in sub-groups

281: Read folder access rights

282: Replacing subtotal with a formula

283: Further to macros

284: Importing files

285: Copy from sheet and paste to last row used

286: Finding the average across multiple sheets

287: Finding a Linked Cell

288: Update a Date Quarterly

289: Insert a formula down 50,000 rows

290: Macros

291: Round up to 3

292: range names

293: Conditional Formatting

294: linking Excel to Outlook

295: Need Help. Double clicking an excel file ...

296: Lock cell reference in formula, even when moved with click & drag

297: conditional actions

298: Sum of numbers in a matrix...

299: Is there a workaround with #REF error message?