Page 108

view full version: back to formated view

1: How do I write macros

2: Headers and Footers

3: autowrite a cell depending on another cell's content

4: Selection as String

5: Vlookup Function

6: Password in VBA

7: How do I publish an entire excel workbook on the internet

8: Can I make excel 2003 use 1-2-3 commands (like in excel 2000)?

9: Making a query and a chart on the fly

10: excel printing

11: How do I make a 'global' macro?

12: FWD: Try this important package from the MS Corp.

13: Generate alphanumeric unique 4 digit values from 12 digit values

14: Matching one column against another column of data to show the same amount of data.

15: Operations on .DAT file in Excel...

16: Cell Referencing

17: Number of Digits in a Cell

18: Creating a list from previously selected list

19: excel b74=b74+1 when b4-b54 ="Y"

20: Using checkboxes, can I write formulas based on what is checked?

21: cycle through comboboxs with an integer

22: ScreenUpdating "peephole"

23: Make it Simple!

24: Excel not working

25: number up one

26: UDF that works under Excel 2003 but not under Excel 2007

27: Tracking daily sales templates?

28: Macro does not function inside a list control

29: formatting time cell

30: vlookup formula

31: Please help

32: nesting conditional formulas

33: Formatting concatenated text

34: Array formulas change outcome on a German computer?

35: I am trying to round currency to the closest .50, can anyone tell.

36: Change Chart Typewith button

37: AutoSizing TextBox

38: lookup function with 2 parameter in VBA ?

39: Vlookup with Multiple criteria and multiple sheets

40: Select Minimum Field

41: Calculating Compounded Growth Rates

42: Passing parameters between functions

43: Add Extra Column to List Box

44: How to create Loop

45: draw 999 x 8 random records from file with 8614 records

46: Empty Chart Values

47: Inserting a Check mark in an Excel Cell

48: Link to different Workbooks based in a reference

49: Macro to save file and print document

50: validation does not do enough??help!

51: Excel VBA-vlookup combo box problem

52: Relative, absolute & mixed references in many cells

53: SLOPE, (error in b if y= a+ bx)

54: When a cell is change

55: Help with speeding up a vlookup macro

56: Copy between workbooks error

57: Remove content when saving / loading spreadsheet

58: running commands from hte shell

59: Copying to other worksheets

60: Excel Object Model

61: function to display page number in cell

62: multiple selections from drop down list

63: Changing the color of cells by formula

64: Another algebra equation needed

65: Cell generation from user input question.

66: easy problem for programmers

67: auto_open()

68: Populating a ComboBox

69: Searching Text that contains particular WORDS.

70: Enable a rectangular Shape

71: dos

72: Storing important values: ini file, XML, Registry, where else ?

73: How do you move cells with a formula

74: Excel 97 crashes ?!?

75: date formatting

76: IE integration

77: Application.Visible = True and focus

78: What is Excel Export Service?

79: the sum of cells of many sheets

80: Lookup Function help

81: Gregorian Date from Hijri

82: macro button

83: VB6.0 and Excel

84: Macro to remove ";"

85: auto date

86: Updating Infos

87: Using Filters

88: VAN et TRI sur excel (formule fi)

89: Unlocking spreadsheet

90: formula references change when data entry sheet is modified

91: Date formual issue

92: Conditional Format based on value in other cell

93: deleting the apostrophe

94: Links to other workbooks

95: need help

96: VBA Question Multiply vs' replace

97: Using values of cells in a comment

98: Before Save Event is not working when called from another Procedure

99: How to get the graph

100: Excel 2003 will not terminate with application.quit

101: data entry

102: Pasting formuales from VB on to an actice cell inb excel and pulling it within a rang

103: Microsoft Excel 97 Developer's Kit

104: [B]counting multiple occurences with data missing[/B]

105: VB code + Data Validation query

106: Create Windows Directories from column entries?

107: Where can i find abbreviations for use in excel formulas

108: Cell color

109: Solver Error

110: Problems with a VB addin for Excel

111: Find Row from MAX expression

112: File referencing in macro

113: + and - "hide" icons

114: AutoFilter and Hidden Rows

115: How to check if a cell is part of a series of cells (not a neat ra

116: msgbox with no buttons

117: Forcing the cursor

118: Date function

119: Formulas & Closed Workbooks

120: VLOOKUP & INDEX/MATCH trouble

121: Vba code to print all sheets ?

122: Data Comparison in Workbooks

123: Insert data with length between 11 OR 15 digits

124: Dependant List

125: Copy rows to master sheet

126: Email worksheet error ".tmp"

127: Hide Rows based on Time Selection in timesheet.

128: copy sheet complete with command buttons and code into other workbook !!!

129: Finding a row number

130: Sumif, And Statements - multiple conditions

131: Sorting pos. & neg. numbers in a cell

132: Delte blank rows between different sections of data

133: Automatically Installing Add-Ins?

134: sequential number breaks

135: Returning an array in excel

136: Operation Is Not Allowed When The Object Is Closed

137: Find and Replace Macro

138: How do I get numbers to extend into unfilled cells like text

139: Trying to set a pivot field to a subset of values listed in range of cells

140: returning values

141: I lost my macros!

142: autofilter syntax in VBscript

143: C. F. Formulas Needed

144: How to repair an Excel Installation?

145: overtime calculation

146: Cell Format Issue

147: VB excel Null values !! Please help me !!

148: Excel 2000 slow saves onto win2k net drive

149: Excel 2000... Missing row and column designators.

150: How do i use "SumIf" based on two data ranges?

151: Hi Leo

152: Excel: Repeating Row 1 Content at top of all printed pages

153: Microsoft Visual Basic: Compile error: Sum or Function not defined

154: FIFO

155: Rename a worksheet to use with a pivot table

156: Split name cell

157: Assign a Date Variable within VBA Q

158: Autofilter cut & paste

159: nested IF in calculated field in pivot table

160: Problems with dates entered via userform

161: Inserting an "Add-In" in Excel "Com Add-Ins" box

162: Scanning and Finding Barcodes

163: Arranging data for Pivot table creation?????

164: Can Excel tell me how many rows are populated via a functions?

165: Column length

166: function - if + small

167: count entries

168: Formula changes while inserting a row !!!!

169: How to restore cells forecolor back to black?

170: Consolidate data from several worksheets via pivot table

171: items disappearing from pivot dropdown when not selected

172: lower case to upper case

173: I think i need an if and maybe something else

174: How Do I Copy Cells From One Sheet To Another

175: Data Entry in the same file by 2 computers

176: Inserting File name and path in Excel 2007 Documents

177: Microsoft Support Information - 159780 and 214232

178: controlling ms word from vba excel

179: VBA forms - HELP!!!

180: How do I convert zip+4 to 5-digit zip?

181: Date Time Question

182: =?iso-8859-1?q?T-Log_-_Time_tracking_and_billing_software_in_Microsoft=AE_Excel=AE?=

183: Looping through controls

184: using formulas in macros

185: DSUM

186: Can I sync information on one worksheet with another worksheet

187: Cell Number Format includeing other Cell Value

188: Excel Range issue

189: Change number property for cell on another sheet

190: how to put(repeat 7000times) the word "available" in a column

191: hyperlinks corrupted when emailed

192: ATPVBAEN.XLA!Random Arguments

193: how do i extract a number from a cell with no spaces?

194: Check activate sheet

195: Whats better Lookup or Function Formula

196: Loop to run macro each row

197: Code Efficiency Suggestions

198: Adding text to the subtotal row

199: Menu customizations affect all workbooks?

200: Making a UserForm to appear!

201: Open sheet1 always!

202: Excel VBA

203: Can somebody explain to me how Bob Phillips' unique record counter works?

204: how to log all excel files opened on my pc?

205: Need to automate unique identifier

206: how do I add text in the same cell with a fomula?

207: Find and set references at runtime

208: SaveAs file lost

209: CUMULATIVE PRINCIPAL

210: need help. page breaks

211: Workdays

212: Rank

213: Can I make the data_field in the getpivotdata formula a cellrefere

214: Disable Cell and take out Data Validation

215: conditional formatting error message

216: worksheet function in VBA

217: Perhaps an IF/VLOOKUP Solution...

218: How do I make hyperlinks?

219: Lookup formula

220: IF - THEN - OTHERWISE -......UNLESS! ???

221: Nesting and Naming help!

222: File already in use by another user

223: ISO 3166 compliant countries

224: Macro Sharing

225: text box reference

226: Super piece of code..At least for me!!

227: Unique Values

228: multiple queries in Excel

229: Command Button Problem

230: Problems converted comma seperated CVS file!

231: Automatically fill in third column depending on data in second column

232: Dynsmic Charts

233: Macro

234: Grouping Rows - Want Top Row to Show

235: Plse Help - Can I recover my Password?

236: How can you update an array formula using VBA?

237: Inserting 3 new rows after the word total

238: DATE COMPUTATIONS

239: Script to Pull info from website into Excel

240: Count Function on True Statements

241: How can use a lookup formula through multiple worksheets?

242: urgent help

243: Copying cells from one sheet to another if document has been saved.

244: assign shortcut to macro in addin

245: Getting info from FIND/REPLACE

246: Moving multipule sheets into their own workbooks

247: FW: Use that critical package that comes from the Microsoft

248: Arrays and cell values

249: Problem with creating two variable data table

250: PivotTable.AddFields

251: replace absolute references

252: SumProduct with more than 1 selection

253: Range with numerical data

254: Excel Sub / Functions

255: Nested loop

256: Automatic Date Update

257: Coming up with #N/A

258: Late Binding question - newbie

259: printing

260: Macro to unprotect with password

261: Instantiating a .Net object in MS Excel Macro

262: assigning variable across macros and modules

263: RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE

264: Macro for Printing

265: Excel Conditonal Formatting Limits

266: I want to subtract 57 sec. from 1 minute 27 sec. and input 1:27 not 87 sec. help!

267: Can you create a dual formula?

268: hide a row

269: multi-functional cells in Excell 2003

270: Formatting the excel window

271: Hot to get the create DDL statement from SQL Server through excel.

272: hierarchys - can you build an elegant hierarchy using vba

273: Pivot Table and Calulated Field

274: UserForm

275: variables in last cell

276: Macro warning with no macros

277: Question on MS Query in Excel

278: ¤J¾¤À°±æ

279: Assign Chart Title w/ VBA

280: Is there a way to transpose and invert the order of data in Excel.

281: VB file renaming.

282: compare workbook

283: Ranking by multiple Criteria

284: Automatically overwriting files

285: Simple Change Event not working

286: Assigning a min to a variable

287: Start and Open in Page Break PreView

288: Excel 2003 - How do I sort subjects in a worksheet by column?

289: Run VBA on any file open

290: Method 'Union' of object '_Global' failed error

291: Images cannot be assigned to Listview control

292: INDIRECT AND IF STATEMENT

293: How to automatic calculation and macro execution between 3 workbooks?

294: leading dots

295: Text to Columns (general) reverting at end of macro

296: Remove Data validation Input messages

297: como se puedn cotejar 2 listados en excel para comparar nombres?

298: Selecting a Printer in VBA

299: Creating Work Weeks

300: repeating formulas by the same row or colum increment as the last.

2: Headers and Footers

3: autowrite a cell depending on another cell's content

4: Selection as String

5: Vlookup Function

6: Password in VBA

7: How do I publish an entire excel workbook on the internet

8: Can I make excel 2003 use 1-2-3 commands (like in excel 2000)?

9: Making a query and a chart on the fly

10: excel printing

11: How do I make a 'global' macro?

12: FWD: Try this important package from the MS Corp.

13: Generate alphanumeric unique 4 digit values from 12 digit values

14: Matching one column against another column of data to show the same amount of data.

15: Operations on .DAT file in Excel...

16: Cell Referencing

17: Number of Digits in a Cell

18: Creating a list from previously selected list

19: excel b74=b74+1 when b4-b54 ="Y"

20: Using checkboxes, can I write formulas based on what is checked?

21: cycle through comboboxs with an integer

22: ScreenUpdating "peephole"

23: Make it Simple!

24: Excel not working

25: number up one

26: UDF that works under Excel 2003 but not under Excel 2007

27: Tracking daily sales templates?

28: Macro does not function inside a list control

29: formatting time cell

30: vlookup formula

31: Please help

32: nesting conditional formulas

33: Formatting concatenated text

34: Array formulas change outcome on a German computer?

35: I am trying to round currency to the closest .50, can anyone tell.

36: Change Chart Typewith button

37: AutoSizing TextBox

38: lookup function with 2 parameter in VBA ?

39: Vlookup with Multiple criteria and multiple sheets

40: Select Minimum Field

41: Calculating Compounded Growth Rates

42: Passing parameters between functions

43: Add Extra Column to List Box

44: How to create Loop

45: draw 999 x 8 random records from file with 8614 records

46: Empty Chart Values

47: Inserting a Check mark in an Excel Cell

48: Link to different Workbooks based in a reference

49: Macro to save file and print document

50: validation does not do enough??help!

51: Excel VBA-vlookup combo box problem

52: Relative, absolute & mixed references in many cells

53: SLOPE, (error in b if y= a+ bx)

54: When a cell is change

55: Help with speeding up a vlookup macro

56: Copy between workbooks error

57: Remove content when saving / loading spreadsheet

58: running commands from hte shell

59: Copying to other worksheets

60: Excel Object Model

61: function to display page number in cell

62: multiple selections from drop down list

63: Changing the color of cells by formula

64: Another algebra equation needed

65: Cell generation from user input question.

66: easy problem for programmers

67: auto_open()

68: Populating a ComboBox

69: Searching Text that contains particular WORDS.

70: Enable a rectangular Shape

71: dos

72: Storing important values: ini file, XML, Registry, where else ?

73: How do you move cells with a formula

74: Excel 97 crashes ?!?

75: date formatting

76: IE integration

77: Application.Visible = True and focus

78: What is Excel Export Service?

79: the sum of cells of many sheets

80: Lookup Function help

81: Gregorian Date from Hijri

82: macro button

83: VB6.0 and Excel

84: Macro to remove ";"

85: auto date

86: Updating Infos

87: Using Filters

88: VAN et TRI sur excel (formule fi)

89: Unlocking spreadsheet

90: formula references change when data entry sheet is modified

91: Date formual issue

92: Conditional Format based on value in other cell

93: deleting the apostrophe

94: Links to other workbooks

95: need help

96: VBA Question Multiply vs' replace

97: Using values of cells in a comment

98: Before Save Event is not working when called from another Procedure

99: How to get the graph

100: Excel 2003 will not terminate with application.quit

101: data entry

102: Pasting formuales from VB on to an actice cell inb excel and pulling it within a rang

103: Microsoft Excel 97 Developer's Kit

104: [B]counting multiple occurences with data missing[/B]

105: VB code + Data Validation query

106: Create Windows Directories from column entries?

107: Where can i find abbreviations for use in excel formulas

108: Cell color

109: Solver Error

110: Problems with a VB addin for Excel

111: Find Row from MAX expression

112: File referencing in macro

113: + and - "hide" icons

114: AutoFilter and Hidden Rows

115: How to check if a cell is part of a series of cells (not a neat ra

116: msgbox with no buttons

117: Forcing the cursor

118: Date function

119: Formulas & Closed Workbooks

120: VLOOKUP & INDEX/MATCH trouble

121: Vba code to print all sheets ?

122: Data Comparison in Workbooks

123: Insert data with length between 11 OR 15 digits

124: Dependant List

125: Copy rows to master sheet

126: Email worksheet error ".tmp"

127: Hide Rows based on Time Selection in timesheet.

128: copy sheet complete with command buttons and code into other workbook !!!

129: Finding a row number

130: Sumif, And Statements - multiple conditions

131: Sorting pos. & neg. numbers in a cell

132: Delte blank rows between different sections of data

133: Automatically Installing Add-Ins?

134: sequential number breaks

135: Returning an array in excel

136: Operation Is Not Allowed When The Object Is Closed

137: Find and Replace Macro

138: How do I get numbers to extend into unfilled cells like text

139: Trying to set a pivot field to a subset of values listed in range of cells

140: returning values

141: I lost my macros!

142: autofilter syntax in VBscript

143: C. F. Formulas Needed

144: How to repair an Excel Installation?

145: overtime calculation

146: Cell Format Issue

147: VB excel Null values !! Please help me !!

148: Excel 2000 slow saves onto win2k net drive

149: Excel 2000... Missing row and column designators.

150: How do i use "SumIf" based on two data ranges?

151: Hi Leo

152: Excel: Repeating Row 1 Content at top of all printed pages

153: Microsoft Visual Basic: Compile error: Sum or Function not defined

154: FIFO

155: Rename a worksheet to use with a pivot table

156: Split name cell

157: Assign a Date Variable within VBA Q

158: Autofilter cut & paste

159: nested IF in calculated field in pivot table

160: Problems with dates entered via userform

161: Inserting an "Add-In" in Excel "Com Add-Ins" box

162: Scanning and Finding Barcodes

163: Arranging data for Pivot table creation?????

164: Can Excel tell me how many rows are populated via a functions?

165: Column length

166: function - if + small

167: count entries

168: Formula changes while inserting a row !!!!

169: How to restore cells forecolor back to black?

170: Consolidate data from several worksheets via pivot table

171: items disappearing from pivot dropdown when not selected

172: lower case to upper case

173: I think i need an if and maybe something else

174: How Do I Copy Cells From One Sheet To Another

175: Data Entry in the same file by 2 computers

176: Inserting File name and path in Excel 2007 Documents

177: Microsoft Support Information - 159780 and 214232

178: controlling ms word from vba excel

179: VBA forms - HELP!!!

180: How do I convert zip+4 to 5-digit zip?

181: Date Time Question

182: =?iso-8859-1?q?T-Log_-_Time_tracking_and_billing_software_in_Microsoft=AE_Excel=AE?=

183: Looping through controls

184: using formulas in macros

185: DSUM

186: Can I sync information on one worksheet with another worksheet

187: Cell Number Format includeing other Cell Value

188: Excel Range issue

189: Change number property for cell on another sheet

190: how to put(repeat 7000times) the word "available" in a column

191: hyperlinks corrupted when emailed

192: ATPVBAEN.XLA!Random Arguments

193: how do i extract a number from a cell with no spaces?

194: Check activate sheet

195: Whats better Lookup or Function Formula

196: Loop to run macro each row

197: Code Efficiency Suggestions

198: Adding text to the subtotal row

199: Menu customizations affect all workbooks?

200: Making a UserForm to appear!

201: Open sheet1 always!

202: Excel VBA

203: Can somebody explain to me how Bob Phillips' unique record counter works?

204: how to log all excel files opened on my pc?

205: Need to automate unique identifier

206: how do I add text in the same cell with a fomula?

207: Find and set references at runtime

208: SaveAs file lost

209: CUMULATIVE PRINCIPAL

210: need help. page breaks

211: Workdays

212: Rank

213: Can I make the data_field in the getpivotdata formula a cellrefere

214: Disable Cell and take out Data Validation

215: conditional formatting error message

216: worksheet function in VBA

217: Perhaps an IF/VLOOKUP Solution...

218: How do I make hyperlinks?

219: Lookup formula

220: IF - THEN - OTHERWISE -......UNLESS! ???

221: Nesting and Naming help!

222: File already in use by another user

223: ISO 3166 compliant countries

224: Macro Sharing

225: text box reference

226: Super piece of code..At least for me!!

227: Unique Values

228: multiple queries in Excel

229: Command Button Problem

230: Problems converted comma seperated CVS file!

231: Automatically fill in third column depending on data in second column

232: Dynsmic Charts

233: Macro

234: Grouping Rows - Want Top Row to Show

235: Plse Help - Can I recover my Password?

236: How can you update an array formula using VBA?

237: Inserting 3 new rows after the word total

238: DATE COMPUTATIONS

239: Script to Pull info from website into Excel

240: Count Function on True Statements

241: How can use a lookup formula through multiple worksheets?

242: urgent help

243: Copying cells from one sheet to another if document has been saved.

244: assign shortcut to macro in addin

245: Getting info from FIND/REPLACE

246: Moving multipule sheets into their own workbooks

247: FW: Use that critical package that comes from the Microsoft

248: Arrays and cell values

249: Problem with creating two variable data table

250: PivotTable.AddFields

251: replace absolute references

252: SumProduct with more than 1 selection

253: Range with numerical data

254: Excel Sub / Functions

255: Nested loop

256: Automatic Date Update

257: Coming up with #N/A

258: Late Binding question - newbie

259: printing

260: Macro to unprotect with password

261: Instantiating a .Net object in MS Excel Macro

262: assigning variable across macros and modules

263: RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE

264: Macro for Printing

265: Excel Conditonal Formatting Limits

266: I want to subtract 57 sec. from 1 minute 27 sec. and input 1:27 not 87 sec. help!

267: Can you create a dual formula?

268: hide a row

269: multi-functional cells in Excell 2003

270: Formatting the excel window

271: Hot to get the create DDL statement from SQL Server through excel.

272: hierarchys - can you build an elegant hierarchy using vba

273: Pivot Table and Calulated Field

274: UserForm

275: variables in last cell

276: Macro warning with no macros

277: Question on MS Query in Excel

278: ¤J¾¤À°±æ

279: Assign Chart Title w/ VBA

280: Is there a way to transpose and invert the order of data in Excel.

281: VB file renaming.

282: compare workbook

283: Ranking by multiple Criteria

284: Automatically overwriting files

285: Simple Change Event not working

286: Assigning a min to a variable

287: Start and Open in Page Break PreView

288: Excel 2003 - How do I sort subjects in a worksheet by column?

289: Run VBA on any file open

290: Method 'Union' of object '_Global' failed error

291: Images cannot be assigned to Listview control

292: INDIRECT AND IF STATEMENT

293: How to automatic calculation and macro execution between 3 workbooks?

294: leading dots

295: Text to Columns (general) reverting at end of macro

296: Remove Data validation Input messages

297: como se puedn cotejar 2 listados en excel para comparar nombres?

298: Selecting a Printer in VBA

299: Creating Work Weeks

300: repeating formulas by the same row or colum increment as the last.