Page 193

view full version: back to formated view

1: Comparing two different sets of data with common element

2: Change the code to copy whole row

3: is workbook open

4: Need help with macro to save selection to csv file!

5: ex. Can you use the IF formula in each cell within a column and g.

6: What is "Cancel=True"?

7: If cell contains -0 then return blank cell

8: how do i use the sumif function in non cons cells

9: Automatically open Excel file set to "Enable Macros"

10: Digitally Signed Excel Sheet - can someone send me one?

11: Convert Decimal to Percent Within Text String

12: Swap Cells

13: Row Number

14: count only visible cells

15: Disable Excel's Auto Formatting

16: Disable Shortcut Menus / Alt-F8

17: Need help with cell formulas

18: Excel User Conference

19: how do you turn an email address list into an Excel csv or txt file?

20: Think I may have screwed myself...

21: Locate Excel files by searching for key words?

22: Conditional listing & double selecting

23: Is there a way to calulate M-T-D or Y-T-D in Excelt?

24: Error Handling and Cleanup

25: lookup value and date from a list with restrictions

26: Filter Switches vs Sheet Protection?

27: How do I combine the contents of multiple cells in one cell?

28: Pivot Table Relative References

29: is there a limt to the amount of if statements you use in just 1 c

30: create a micro for Auto Column Width and put on tool bar

31: Shortening a formula

32: Copying values from one file to another

33: How to determine the value?

34: Populate the Concatenate function using VBA

35: Macro doesn't run...

36: range select question

37: Error in grouping rows in excel using VB

38: Code to view and Print several documents

39: Excel makes it possible:celverwijzing to a remark on another page

40: How do I calculate rate when pmt is made at end of periods

41: Date in VBA Code Printout

42: Addition code for 110 TextBoxes

43: Advanced Filter Problem with Unique List

44: combine two workbooks

45: ScreenUpdating Question

46: vlookup between excel files

47: Normal font

48: Create Month Timetable on a worksheet different month each works

49: Excel FileSaveAs dialog freezes when used via automation from Access

50: Cannot install MSOffice XP SP1

51: Subscript and Superscript with the TEXT function

52: Relative Reference Outlining

53: How to find hidden text

54: How can Rowsource be used for a combobox on a form?

55: Userform Image help

56: Sending information from a cell in excel to a task in outlook

57: Sumif Greater than 0

58: Transferring data in Excel

59: Coditional Formatting?

60: Lookup on multiple sheets in file

61: MACRO FOR DELETING DEBIT AND CREDIT FIGURES ROWS

62: list box / scroll bar

63: Cell protection in Excel is lost when file is uploaded to website.

64: Problem with pivot table on large spreadsheet in Excel 2007

65: Excel printing problem - won't print cell under a "fill effect" bo

66: Re: Calculate duration day +1

67: disable alt and control shortcut keys

68: turn an filter off or back to All

69: Button caption identification

70: E-mail Attachments

71: find a specific or several values in a massive datasheet

72: Command button to refresh data

73: Crazy Combobox

74: Grid lines not printing

75: a data entry form with combo box

76: Can I hide my running totals when there is no change?

77: lookup in one sheet and insert in second if not found

78: birthdays, anniversaries etc

79: ASP

80: Can we create a viewport in Excel like Autocad?

81: Excel User Conference - Atlantic City, April 19-21 - deadline tomorrow - Registration Giveaway

82: Format cell to capital letters.

83: Combobox on change event

84: Link Excel dates to Calendar in Outlook

85: Evaluate Custom Expression

86: Cell Selection Bug!!

87: Add-in does not autoload on programmatic opening

88: Memory problem: Need to set object variables for userforms? For

89: Programatically changing picture in UserForm - VBA - Mac OSX

90: VBA question

91: Is this when it's appropriate to put the macro in the worksheet's code area?

92: "Checkmarks"

93: rows 1-2 missing from excel worksheet

94: Macro to record history of Excel files

95: How to expand the formula bar when excel opens

96: Attaching a document to a cell - Is this possible?

97: Finding Last entry in a Column

98: How do I calculate ones age as of todays date?

99: Excel 2003 very slow

100: How to customize error bars by VB code?

101: Dates

102: how do i update my stocks in "STOCK INVESTMENT PERFORMANCE"

103: Function Updates from another sheet

104: Write a code with another code

105: Web Queries Excel 97

106: re: Automatically Delete WorkBook 2 modules by using Workbook 1 module

107: How to populate all cells of a column with the same comment?

108: Outlook Address Properties > Excel

109: Advanced Pivot Table

110: SUMIF With Variable Consecutive Days

111: Copy Lotus Data Into Excel

112: Exit when its a Mac

113: Taking out an Extra space before some entries in a column

114: Excel Client Safety Options

115: Name Box cell reference

116: How to count process running time ( process not finished)

117: double conditions for CountIf

118: Time formats and adding.

119: Executing a subroutine from within a loop

120: Cross-Referencing

121: User form to assign an autonumber to spreadsheet - Any Ideas pleas

122: Calculation Question

123: "In Today's Dollars" help needed...

124: styles not applying

125: multiple data ranges for countif

126: Sorting worksheets alphabetically (code)

127: if statements in sumproduct formula

128: vlookup error

129: HELP: opening/closing Excel remotely!!!!

130: Sumproduct Question

131: Working with Two WorkBooks

132: SUMPRODUCT Help

133: Batch Workbook Printing for selected

134: removing data in a combobox

135: add text into right-side of menu bar

136: VBA to Protect Worksheet

137: Which commands to use in a macro

138: Loan Amoritization Spreadsheet Issue

139: How do I hide spreadsheet range from data entry?

140: Find cells with color sum other column

141: you cannot save to this file format when the VBA project is protected

142: Overlapping combinations problem

143: HELP NEEDED: Date Range in Excel

144: jpg file name change

145: Formula is

146: FFT in Excel

147: HTML outputs to distribute

148: changes in the date function from 2000 to 2003?

149: waiting for click on the button

150: variable not set error?

151: Merging Excel Spreadsheets Together

152: combo box

153: Data management error?

154: Ok what's the trick to do this?

155: SUMPRODUCT - comma versus semicolon

156: adding cells in time format

157: .NET application does not release Excel

158: HOW DO I COPY THE LAST NON BLANK CELL IN A COLUMN

159: How to insert a column

160: Importing data from Access to Excel 2003 for Invoicing

161: 2 same ways of protecting Excel file

162: Autofill

163: Counting based on the occurrence of text in a cell

164: Editing MS Query

165: sum of cells

166: Start Up Position for Workbooks...

167: Finding Duplicate Values

168: Need an assist with existing code

169: Multiple worksheets

170: data tables in Excel

171: Editing MS Project File from Excel VBA

172: Need step by step for entering data into combobox

173: changing text to numerals

174: Enable/Disable Button

175: I want Cell to remain blank

176: Parameters wthin Query of External Data

177: Problem entering dashes in certain spots

178: Keeping track of useful macros

179: pressing the "reset" button and freeing memory

180: I am looking for a good golf tournament program for excel

181: protect cell

182: Replace formula with IF(error(formula;"";formula)

183: Application.Quit

184: Error when Execute New Procedure Created Using VBE

185: Printing

186: Sorting rows

187: Remaining workdays

188: 2 IF statements in same cell

189: Conditional Formatting

190: Finding and Extracting new Data

191: multiple results

192: Increment Macro - Order numbers

193: User input to name a sheet?

194: opening text files that have more rows than 65536

195: Office 2000 Installer Popup?

196: VB timing question

197: Printing a Page

198: Ensuring Macros are running

199: Turning Design Mode off in VB code

200: Code Edit

201: Text to column and selecting values based on a different column

202: VBA password protect

203: Sum Relative Number of Cells in Column

204: my date range does not work in an = ifsum

205: (--(Function))

206: Helpful New Functions: ALL and ANY

207: copy several sheets from a workbook to a single sheet in a new wor

208: Please Help With Chart Code

209: can com port data be imported & sorted into cells?

210: change control properties according to a cell value

211: Need Help With Export Code

212: How to lookup and display info?

213: vba macro for getting external data

214: Customised Interface

215: Excel - Standard Deviation

216: Can I control Internet Explorer using Excel VBA?

217: BYPASS blank cell

218: Using a collection as a property

219: If..then..Lookup?

220: MS Works Spreadsheet conversion to Excel

221: Macro Auto Run Problem

222: Side by Side Comparison Add-on

223: vlookup range changes

224: macro working very slow

225: Get current cell with VBA function

226: Putting sums on your spreadsheet

227: loan amortization template

228: Can't see the user name of the person who has the worksheet locked

229: How do I make histogram graphs look the same?

230: i'm stuck with an excel qujitting problem

231: Can I run a macro on loading?

232: MS Querry for Excel

233: XL97 - Command Bar Removal

234: HOW DO I BLOCK DUPLICATE NUMBERS IN EXCEL

235: Need

236: Getting rid of update links popup?

237: List Validation Based on another sheet

238: How to skip the blank cells for calculating StdDev?

239: Lost Menu Bar.

240: Updating "#Invalid entity XXXX" using VBA

241: Sorting rows and columns using VBA

242: Export worksheet only

243: Cursor movement

244: Updating a named range with SQL like command

245: Problems Programming a sort to move rows

246: Reference Sub from another workbook

247: Cell Formula Help

248: Highlight Range - wrong macro, please edit.

249: need help using the offset function differently

250: Dynamic Defined name formula

251: Using formula problem

252: Copy Only Visible Cell

253: API Timer Function Issue

254: Dynamically changing a link name

255: Populate unique list in combobox

256: Q: Changing a link without link validation

257: Macro Sort Errors

258: Problems with Combobox

259: Code needs tweaking :P

260: Display files in a directory

261: sum of time

262: Position To Start At

263: help - how to list all excel files in a folder

264: find command using variables

265: Pivot Table

266: Does Excel have compacting utility?

267: Can I do this?

268: Opening xls files with works suite 2000 spreadsheet or database

269: Open a picture based on Excel Value

270: Help With Formula For Date Comparison

271: Replace the Find Function with a formula

272: Averaging excluding min and max numbers

273: Need Help on Ranking

274: Exponential

275: VB to open the Form window

276: referencing a sheet in a list box

277: Copying data at specific positions

278: Get External data from a webpage

279: advance level of sorting data? by Ting

280: Don't understand why I'm getting an argument not optional

281: Macro

282: Extra projects in VBA editor?

283: doesnt become Hyperlink

284: dynamic arrays in excel

285: Navigation

286: Importing text-files

287: Dropdown event in validation cell

288: Fred saves the day % retainage

289: Disabling Screensaver

290: help on sizing a check box created using the Forms toolbar

291: Thanks

292: skipping a cell in a form in Excel

293: Run-time Error 1004 - retry x times or end

294: On Error and Loops

295: put cells based on condition in sheet2

296: Format from function

297: Formatting e-mails after creation

298: WORKDAY() Function Equivalent with SUMPRODUCT()

299: How to find the rows existing in one column but not the other?

300: How working with Access Databases through Excel 2003 Standar Editi

301: Cell access

2: Change the code to copy whole row

3: is workbook open

4: Need help with macro to save selection to csv file!

5: ex. Can you use the IF formula in each cell within a column and g.

6: What is "Cancel=True"?

7: If cell contains -0 then return blank cell

8: how do i use the sumif function in non cons cells

9: Automatically open Excel file set to "Enable Macros"

10: Digitally Signed Excel Sheet - can someone send me one?

11: Convert Decimal to Percent Within Text String

12: Swap Cells

13: Row Number

14: count only visible cells

15: Disable Excel's Auto Formatting

16: Disable Shortcut Menus / Alt-F8

17: Need help with cell formulas

18: Excel User Conference

19: how do you turn an email address list into an Excel csv or txt file?

20: Think I may have screwed myself...

21: Locate Excel files by searching for key words?

22: Conditional listing & double selecting

23: Is there a way to calulate M-T-D or Y-T-D in Excelt?

24: Error Handling and Cleanup

25: lookup value and date from a list with restrictions

26: Filter Switches vs Sheet Protection?

27: How do I combine the contents of multiple cells in one cell?

28: Pivot Table Relative References

29: is there a limt to the amount of if statements you use in just 1 c

30: create a micro for Auto Column Width and put on tool bar

31: Shortening a formula

32: Copying values from one file to another

33: How to determine the value?

34: Populate the Concatenate function using VBA

35: Macro doesn't run...

36: range select question

37: Error in grouping rows in excel using VB

38: Code to view and Print several documents

39: Excel makes it possible:celverwijzing to a remark on another page

40: How do I calculate rate when pmt is made at end of periods

41: Date in VBA Code Printout

42: Addition code for 110 TextBoxes

43: Advanced Filter Problem with Unique List

44: combine two workbooks

45: ScreenUpdating Question

46: vlookup between excel files

47: Normal font

48: Create Month Timetable on a worksheet different month each works

49: Excel FileSaveAs dialog freezes when used via automation from Access

50: Cannot install MSOffice XP SP1

51: Subscript and Superscript with the TEXT function

52: Relative Reference Outlining

53: How to find hidden text

54: How can Rowsource be used for a combobox on a form?

55: Userform Image help

56: Sending information from a cell in excel to a task in outlook

57: Sumif Greater than 0

58: Transferring data in Excel

59: Coditional Formatting?

60: Lookup on multiple sheets in file

61: MACRO FOR DELETING DEBIT AND CREDIT FIGURES ROWS

62: list box / scroll bar

63: Cell protection in Excel is lost when file is uploaded to website.

64: Problem with pivot table on large spreadsheet in Excel 2007

65: Excel printing problem - won't print cell under a "fill effect" bo

66: Re: Calculate duration day +1

67: disable alt and control shortcut keys

68: turn an filter off or back to All

69: Button caption identification

70: E-mail Attachments

71: find a specific or several values in a massive datasheet

72: Command button to refresh data

73: Crazy Combobox

74: Grid lines not printing

75: a data entry form with combo box

76: Can I hide my running totals when there is no change?

77: lookup in one sheet and insert in second if not found

78: birthdays, anniversaries etc

79: ASP

80: Can we create a viewport in Excel like Autocad?

81: Excel User Conference - Atlantic City, April 19-21 - deadline tomorrow - Registration Giveaway

82: Format cell to capital letters.

83: Combobox on change event

84: Link Excel dates to Calendar in Outlook

85: Evaluate Custom Expression

86: Cell Selection Bug!!

87: Add-in does not autoload on programmatic opening

88: Memory problem: Need to set object variables for userforms? For

89: Programatically changing picture in UserForm - VBA - Mac OSX

90: VBA question

91: Is this when it's appropriate to put the macro in the worksheet's code area?

92: "Checkmarks"

93: rows 1-2 missing from excel worksheet

94: Macro to record history of Excel files

95: How to expand the formula bar when excel opens

96: Attaching a document to a cell - Is this possible?

97: Finding Last entry in a Column

98: How do I calculate ones age as of todays date?

99: Excel 2003 very slow

100: How to customize error bars by VB code?

101: Dates

102: how do i update my stocks in "STOCK INVESTMENT PERFORMANCE"

103: Function Updates from another sheet

104: Write a code with another code

105: Web Queries Excel 97

106: re: Automatically Delete WorkBook 2 modules by using Workbook 1 module

107: How to populate all cells of a column with the same comment?

108: Outlook Address Properties > Excel

109: Advanced Pivot Table

110: SUMIF With Variable Consecutive Days

111: Copy Lotus Data Into Excel

112: Exit when its a Mac

113: Taking out an Extra space before some entries in a column

114: Excel Client Safety Options

115: Name Box cell reference

116: How to count process running time ( process not finished)

117: double conditions for CountIf

118: Time formats and adding.

119: Executing a subroutine from within a loop

120: Cross-Referencing

121: User form to assign an autonumber to spreadsheet - Any Ideas pleas

122: Calculation Question

123: "In Today's Dollars" help needed...

124: styles not applying

125: multiple data ranges for countif

126: Sorting worksheets alphabetically (code)

127: if statements in sumproduct formula

128: vlookup error

129: HELP: opening/closing Excel remotely!!!!

130: Sumproduct Question

131: Working with Two WorkBooks

132: SUMPRODUCT Help

133: Batch Workbook Printing for selected

134: removing data in a combobox

135: add text into right-side of menu bar

136: VBA to Protect Worksheet

137: Which commands to use in a macro

138: Loan Amoritization Spreadsheet Issue

139: How do I hide spreadsheet range from data entry?

140: Find cells with color sum other column

141: you cannot save to this file format when the VBA project is protected

142: Overlapping combinations problem

143: HELP NEEDED: Date Range in Excel

144: jpg file name change

145: Formula is

146: FFT in Excel

147: HTML outputs to distribute

148: changes in the date function from 2000 to 2003?

149: waiting for click on the button

150: variable not set error?

151: Merging Excel Spreadsheets Together

152: combo box

153: Data management error?

154: Ok what's the trick to do this?

155: SUMPRODUCT - comma versus semicolon

156: adding cells in time format

157: .NET application does not release Excel

158: HOW DO I COPY THE LAST NON BLANK CELL IN A COLUMN

159: How to insert a column

160: Importing data from Access to Excel 2003 for Invoicing

161: 2 same ways of protecting Excel file

162: Autofill

163: Counting based on the occurrence of text in a cell

164: Editing MS Query

165: sum of cells

166: Start Up Position for Workbooks...

167: Finding Duplicate Values

168: Need an assist with existing code

169: Multiple worksheets

170: data tables in Excel

171: Editing MS Project File from Excel VBA

172: Need step by step for entering data into combobox

173: changing text to numerals

174: Enable/Disable Button

175: I want Cell to remain blank

176: Parameters wthin Query of External Data

177: Problem entering dashes in certain spots

178: Keeping track of useful macros

179: pressing the "reset" button and freeing memory

180: I am looking for a good golf tournament program for excel

181: protect cell

182: Replace formula with IF(error(formula;"";formula)

183: Application.Quit

184: Error when Execute New Procedure Created Using VBE

185: Printing

186: Sorting rows

187: Remaining workdays

188: 2 IF statements in same cell

189: Conditional Formatting

190: Finding and Extracting new Data

191: multiple results

192: Increment Macro - Order numbers

193: User input to name a sheet?

194: opening text files that have more rows than 65536

195: Office 2000 Installer Popup?

196: VB timing question

197: Printing a Page

198: Ensuring Macros are running

199: Turning Design Mode off in VB code

200: Code Edit

201: Text to column and selecting values based on a different column

202: VBA password protect

203: Sum Relative Number of Cells in Column

204: my date range does not work in an = ifsum

205: (--(Function))

206: Helpful New Functions: ALL and ANY

207: copy several sheets from a workbook to a single sheet in a new wor

208: Please Help With Chart Code

209: can com port data be imported & sorted into cells?

210: change control properties according to a cell value

211: Need Help With Export Code

212: How to lookup and display info?

213: vba macro for getting external data

214: Customised Interface

215: Excel - Standard Deviation

216: Can I control Internet Explorer using Excel VBA?

217: BYPASS blank cell

218: Using a collection as a property

219: If..then..Lookup?

220: MS Works Spreadsheet conversion to Excel

221: Macro Auto Run Problem

222: Side by Side Comparison Add-on

223: vlookup range changes

224: macro working very slow

225: Get current cell with VBA function

226: Putting sums on your spreadsheet

227: loan amortization template

228: Can't see the user name of the person who has the worksheet locked

229: How do I make histogram graphs look the same?

230: i'm stuck with an excel qujitting problem

231: Can I run a macro on loading?

232: MS Querry for Excel

233: XL97 - Command Bar Removal

234: HOW DO I BLOCK DUPLICATE NUMBERS IN EXCEL

235: Need

236: Getting rid of update links popup?

237: List Validation Based on another sheet

238: How to skip the blank cells for calculating StdDev?

239: Lost Menu Bar.

240: Updating "#Invalid entity XXXX" using VBA

241: Sorting rows and columns using VBA

242: Export worksheet only

243: Cursor movement

244: Updating a named range with SQL like command

245: Problems Programming a sort to move rows

246: Reference Sub from another workbook

247: Cell Formula Help

248: Highlight Range - wrong macro, please edit.

249: need help using the offset function differently

250: Dynamic Defined name formula

251: Using formula problem

252: Copy Only Visible Cell

253: API Timer Function Issue

254: Dynamically changing a link name

255: Populate unique list in combobox

256: Q: Changing a link without link validation

257: Macro Sort Errors

258: Problems with Combobox

259: Code needs tweaking :P

260: Display files in a directory

261: sum of time

262: Position To Start At

263: help - how to list all excel files in a folder

264: find command using variables

265: Pivot Table

266: Does Excel have compacting utility?

267: Can I do this?

268: Opening xls files with works suite 2000 spreadsheet or database

269: Open a picture based on Excel Value

270: Help With Formula For Date Comparison

271: Replace the Find Function with a formula

272: Averaging excluding min and max numbers

273: Need Help on Ranking

274: Exponential

275: VB to open the Form window

276: referencing a sheet in a list box

277: Copying data at specific positions

278: Get External data from a webpage

279: advance level of sorting data? by Ting

280: Don't understand why I'm getting an argument not optional

281: Macro

282: Extra projects in VBA editor?

283: doesnt become Hyperlink

284: dynamic arrays in excel

285: Navigation

286: Importing text-files

287: Dropdown event in validation cell

288: Fred saves the day % retainage

289: Disabling Screensaver

290: help on sizing a check box created using the Forms toolbar

291: Thanks

292: skipping a cell in a form in Excel

293: Run-time Error 1004 - retry x times or end

294: On Error and Loops

295: put cells based on condition in sheet2

296: Format from function

297: Formatting e-mails after creation

298: WORKDAY() Function Equivalent with SUMPRODUCT()

299: How to find the rows existing in one column but not the other?

300: How working with Access Databases through Excel 2003 Standar Editi

301: Cell access