Page 194

view full version: back to formated view

1: Cell access

2: how to copy data with out using paste method

3: Weight Loss

4: Need help in forcing number that wants to stay in Sci. Notation fo

5: Print Help

6: Re: Previous Date Calculation Post

7: Formula needed for 2 criteria

8: pivot table formatting

9: copying results to other location

10: /e switch isn't working

11: Function Bug ?

12: Concatenate a range of cells with delimiter

13: OLAP Question

14: Web Query imput/return data problem

15: Mouse Scrolling in VBA Module

16: Finding Procedure which generated error

17: I NEED HELP ASAP!!!!

18: data validation

19: Conditional Sum Brackets { }

20: Excel=>Word

21: connection test

22: formula result valid, but not appearing on spreadsheet

23: Macro - code for ranges urgent!!!

24: Prompt for update

25: range selection help needed

26: Hyperlinks - relative references

27: my code too long?

28: Can Paste-Special-Values be VBA programmed?

29: Workbooks.Open incorrectly formating date column

30: Lock cell as reference not value

31: SUMPODUCT - Some one please help !!!

32: VBA search

33: Default Printing Options

34: what is array size limit in VBA?

35: Naming objects on creation

36: IF formulas and monthly finances

37: Count cells within a date range

38: Conditional Formatting Not showing without editing cell

39: How do I select the first cell of a filtered list?

40: How to succesfully sort column of formulas?

41: Textbox adding problem

42: Formating text

43: Greater of Two Cells

44: vlookup help

45: 2005 Excel User Conference

46: How to assign a short cut key for user defined word?

47: SUMIF non-contiguous range

48: Filtering

49: spell check ranges in a do loop

50: "Insert row" event?

51: Count maybe?

52: margines

53: CHECK BOX HELP NEEDED PLEASE

54: Find Unique Records from two sheets

55: Need Help with Macro Code

56: How I write following macro?

57: Reading txt file into the buffer

58: how do I make a formula NOT change when the data range is moved?

59: COUNTIF provides weird results

60: AutoNumber/RecordID

61: Find row with the same data like in another row

62: Copy Titles in a long list of rows

63: count blanks in pivot table

64: Pivot Table Grouping

65: Can someone help me to understand how this formula works? =IF(E3.

66: n/a in vlookup/index/match formula

67: Sort Worksheets within a file

68: Creating Links Between Spreadsheets

69: Macros across office programs...

70: Timesheet, overtime with daytime from 7:30am to 16:30pm

71: Parsing names from one column into 3.

72: Macro syntax to open file in current explorer folder

73: Can this be simplified

74: UserForm

75: If B1 is not empty but B2 is ... conditional formatting "formula"?

76: Comparing lists

77: Break-Even (or Payoff) with inflation factor

78: Pass date to cell in spreadsheet

79: move data in bold to a summary worksheet

80: Easy entries short procedure required

81: I am looking for help on how to create a specific formula

82: Pasting Personality issues

83: SetCursorPos

84: save details to xml

85: Simple (?) Formula Problem

86: Insert Outlook Message into Excel cell

87: Setting more parameters with Print area code

88: sumproduct partial text count

89: Add Current workbook as an attachment

90: how do i unsave an excel document?

91: Ned Help with Print Macro

92: how to merge 2 colomns

93: Need Help filtering data

94: formula help

95: How can I change the tab but keep the row and column constant when

96: Embed Word doc. into Excel

97: How to

98: Application.Match and Ranges

99: selectin all the values in a column including null values

100: getting numbers in cells into formula

101: vlookup with more than number to be retrieved

102: Vlookup in VBA. How can I?

103: PlotArea picture from wbk?

104: Why help?

105: Automatically populating new rows with formuals above

106: Moving page up and down with arrow keys instead of individual cel.

107: copyfromrecordset performance

108: Pivot Table Programming

109: Conditional Formating based on a "S"

110: Conditional Format Query

111: Linking two "tables" of data.

112: counting number of times value is greater than previous week

113: copying vis basic formula in multiple column/cells

114: How can I get "=TODAY()" results to be non-volatile?

115: borders show on sheet but not in preview and they are not printing

116: order number

117: scrolling to a specific cell

118: Conditional Formatting

119: {=TABLE... what is this?

120: Referring to cells in a filtered range

121: averging prices real problem

122: Sending mail from Excel with CDO - return SMTP value

123: Populate combobox

124: Calculating overlapping time periods

125: Scheduling a Macro

126: Automating data extraction on 22nd of month

127: How to remove all instances of a command button

128: Code - Clear and Insert & If Statement

129: Paste Multiple listbox items starting at ActiveCell

130: How to know which user is having permissions on the different system folder.

131: COUNTIF In This Case?

132: using Switch() to call functions

133: Replaceing destination cell contents with new data in Excell

134: Problems with Controls Embedded in Worksheet

135: Pasting Between Workbooks

136: using worksheet name

137: XML Advantages in Excell

138: True to TRUE

139: Programatically sending a sheet through Outlook

140: cube root

141: Not empty but zero

142: Track Changes

143: Problem with Workbook_Open

144: Worksheet Range Question - Excel 2003

145: Lost new custom toolbar button with its macro

146: Tough for me - Import 30 macros from one excel file to another in one step

147: Cell switching

148: Defining an array to search by

149: Help with silly error

150: insert scanned image into text box

151: how can I compare data with two sampling rates

152: How can I know if Excel supports the fileformat constant?

153: Sheet protection

154: hiding sheets

155: Is excel capable of gouping numbers within 1 of each other

156: VBA + Excel Web Query - Timing Issues

157: Help Required With Snake Column

158: Creating a NUL Cell

159: auto filter question

160: QIF format

161: Strange currency symbols when importing .csv

162: Nesting function or other suggestions

163: Macro for sheet delete, very easy

164: replying to messages on this service

165: Lost modules being arranged by type

166: Export Japanese from MS-Access to Excel

167: Importing fractions with proper format from CSV

168: Deployment and config files

169: Probably a vlookup type ? not sure

170: bring up dialog box from command button?

171: Application-Defined or Object-Defined Error on simple code

172: auto open .xla file

173: Formula Question

174: arranging multiple custom menus

175: Circular reference error - where ?

176: Checking for a Task on windows?

177: Removing '0's' in cells

178: Open text file as text not numbers

179: deleting worksheets corrupts files

180: Visual Basic code to find next available (blank) row in a spreadsh

181: Preventing Blank based on another Cell

182: Stay in Combobox when reaching end

183: Is it possible to click in a cell and trigger a macro?

184: Global Variables using User Forms

185: How to get the row of a specified cell content

186: tab password

187: Blank fields

188: disabling send as attachment

189: xlDialogSaveAs

190: Restoring application settings at end of sub

191: Boxes in my addresses

192: Workbook_SheetChange

193: Editing Queries in Excel 2000

194: CELL CHANGE EVENT

195: How to check if the directory exists?

196: sort 2D array

197: Text to Columns help with my data

198: "show office assistant" greyed out; code suspect

199: Re: converting days into weeks

200: Using Tab Key In Excel

201: No fill color visible...not high contrast!

202: My 1st IF-THEN-ELSE Procedure

203: Reading data from a cell to a text box

204: What does the double dash or "--" do when using it in a function? (and other questions)

205: Incremental number field with User ID

206: Visual Basic run-time error when printing from web application...

207: sumif and countif nested?

208: Formatting Names

209: Why is inserting rows throwing off my hidden rows

210: Cut command

211: Use Advanced Filter to Detect non blank rows

212: Win Explorer to Excel

213: how to create constaints in solver

214: Day of the Week Calc in Excel

215: Zipping a file

216: What is the formula that works for this

217: Problem with Excel Header/Footer from .NET ???

218: Display Tab name in Cell

219: Cell Values from a Closed Workbook

220: Using lookup in a VBA procedure

221: Cell formatting -- why so slow?

222: Add per dates

223: macro...additional info

224: Changing Default Save Location for Email Attachments

225: Excel BNF

226: Random Name Generator

227: linking 9 workbooks

228: Display unique values in a range.

229: How do I update a checkbox as true when another has been updated

230: Find Excel files that have hidden workbook

231: Find Command

232: Can I count cells with specific format (e.g., yellow field?)

233: Is it a formula

234: inverse fourier

235: if declaration

236: how to switch pages in a multipage control by a commandbutton

237: finding internal links in excel directory

238: Excel 2007

239: Dynamic array seems invalid

240: Running Macro in Excel

241: Spell checking without the POP up ...

242: M I.5 Persecutio n ' abus e in set- up situati ons an d in publi c

243: offset and address?

244: using names

245: Emailing a form from a spreadsheet

246: Copy Range Issue

247: Specific Macros

248: mexcel macro to run onselect

249: countif(and) problem

250: Please help.. lost in code.

251: Kerning Issue In Excel

252: referring to previous worksheet in workbook

253: Arrange and Tiled

254: Can't Undo Macro Command

255: Printing

256: Excel Formulas

257: I need help writing a macro that will correct typing errors?

258: Simple programming help for newbie

259: Match / Sum Values

260: How do I copy data from one cell to the next occurrence of data?

261: Validation of cell results

262: How can I insert a row in MS Excel using a formula?

263: Sum formula

264: ADD-IN will not appear in MENU BAR

265: Multi Variable Formula

266: Change Event

267: Vba excel - evaluating value

268: "View" selection

269: Bringing in information from one worksheet to another dependent on the 2nd

270: Question about Query Wizard

271: calender for spreadsheet

272: Use cell value as reference to sheet in formula?

273: disappearing macros

274: How do I perform agreement statistics (kappa coeficient) in MS Ex.

275: File encoding problem

276: Insert code into worksheets programatically??

277: Re: Changes not saved in xla module

278: GETPIVOTDATA in Excel 2007

279: Array tally

280: creating formula

281: Changing active cell within a selection with mouse-click

282: Easypdf

283: Error in Excel 97 when running Excel 2000 macro

284: Get data from Outlook Public Folders in Excel

285: How do I get rid of too many active cells in Excel

286: double lookup

287: swap values between two cells

288: $ in functions

289: What function gives the Sheet name in Excel ?

290: return a collum heading

291: how do I get " 1st" to look proper (superscript the "st")

292: HELP! Brand new user to excel and having problems...

293: New sheet from the cell contents

294: Nested IF: Using CPEARSON Approach

295: Opening a Worksheet from a template

296: Multi format conditional formating

297: How check if form is loaded?

298: Commenting out code

299: =DAYS360 Function

300: Help with formula

301: VBA returning a cell address

2: how to copy data with out using paste method

3: Weight Loss

4: Need help in forcing number that wants to stay in Sci. Notation fo

5: Print Help

6: Re: Previous Date Calculation Post

7: Formula needed for 2 criteria

8: pivot table formatting

9: copying results to other location

10: /e switch isn't working

11: Function Bug ?

12: Concatenate a range of cells with delimiter

13: OLAP Question

14: Web Query imput/return data problem

15: Mouse Scrolling in VBA Module

16: Finding Procedure which generated error

17: I NEED HELP ASAP!!!!

18: data validation

19: Conditional Sum Brackets { }

20: Excel=>Word

21: connection test

22: formula result valid, but not appearing on spreadsheet

23: Macro - code for ranges urgent!!!

24: Prompt for update

25: range selection help needed

26: Hyperlinks - relative references

27: my code too long?

28: Can Paste-Special-Values be VBA programmed?

29: Workbooks.Open incorrectly formating date column

30: Lock cell as reference not value

31: SUMPODUCT - Some one please help !!!

32: VBA search

33: Default Printing Options

34: what is array size limit in VBA?

35: Naming objects on creation

36: IF formulas and monthly finances

37: Count cells within a date range

38: Conditional Formatting Not showing without editing cell

39: How do I select the first cell of a filtered list?

40: How to succesfully sort column of formulas?

41: Textbox adding problem

42: Formating text

43: Greater of Two Cells

44: vlookup help

45: 2005 Excel User Conference

46: How to assign a short cut key for user defined word?

47: SUMIF non-contiguous range

48: Filtering

49: spell check ranges in a do loop

50: "Insert row" event?

51: Count maybe?

52: margines

53: CHECK BOX HELP NEEDED PLEASE

54: Find Unique Records from two sheets

55: Need Help with Macro Code

56: How I write following macro?

57: Reading txt file into the buffer

58: how do I make a formula NOT change when the data range is moved?

59: COUNTIF provides weird results

60: AutoNumber/RecordID

61: Find row with the same data like in another row

62: Copy Titles in a long list of rows

63: count blanks in pivot table

64: Pivot Table Grouping

65: Can someone help me to understand how this formula works? =IF(E3.

66: n/a in vlookup/index/match formula

67: Sort Worksheets within a file

68: Creating Links Between Spreadsheets

69: Macros across office programs...

70: Timesheet, overtime with daytime from 7:30am to 16:30pm

71: Parsing names from one column into 3.

72: Macro syntax to open file in current explorer folder

73: Can this be simplified

74: UserForm

75: If B1 is not empty but B2 is ... conditional formatting "formula"?

76: Comparing lists

77: Break-Even (or Payoff) with inflation factor

78: Pass date to cell in spreadsheet

79: move data in bold to a summary worksheet

80: Easy entries short procedure required

81: I am looking for help on how to create a specific formula

82: Pasting Personality issues

83: SetCursorPos

84: save details to xml

85: Simple (?) Formula Problem

86: Insert Outlook Message into Excel cell

87: Setting more parameters with Print area code

88: sumproduct partial text count

89: Add Current workbook as an attachment

90: how do i unsave an excel document?

91: Ned Help with Print Macro

92: how to merge 2 colomns

93: Need Help filtering data

94: formula help

95: How can I change the tab but keep the row and column constant when

96: Embed Word doc. into Excel

97: How to

98: Application.Match and Ranges

99: selectin all the values in a column including null values

100: getting numbers in cells into formula

101: vlookup with more than number to be retrieved

102: Vlookup in VBA. How can I?

103: PlotArea picture from wbk?

104: Why help?

105: Automatically populating new rows with formuals above

106: Moving page up and down with arrow keys instead of individual cel.

107: copyfromrecordset performance

108: Pivot Table Programming

109: Conditional Formating based on a "S"

110: Conditional Format Query

111: Linking two "tables" of data.

112: counting number of times value is greater than previous week

113: copying vis basic formula in multiple column/cells

114: How can I get "=TODAY()" results to be non-volatile?

115: borders show on sheet but not in preview and they are not printing

116: order number

117: scrolling to a specific cell

118: Conditional Formatting

119: {=TABLE... what is this?

120: Referring to cells in a filtered range

121: averging prices real problem

122: Sending mail from Excel with CDO - return SMTP value

123: Populate combobox

124: Calculating overlapping time periods

125: Scheduling a Macro

126: Automating data extraction on 22nd of month

127: How to remove all instances of a command button

128: Code - Clear and Insert & If Statement

129: Paste Multiple listbox items starting at ActiveCell

130: How to know which user is having permissions on the different system folder.

131: COUNTIF In This Case?

132: using Switch() to call functions

133: Replaceing destination cell contents with new data in Excell

134: Problems with Controls Embedded in Worksheet

135: Pasting Between Workbooks

136: using worksheet name

137: XML Advantages in Excell

138: True to TRUE

139: Programatically sending a sheet through Outlook

140: cube root

141: Not empty but zero

142: Track Changes

143: Problem with Workbook_Open

144: Worksheet Range Question - Excel 2003

145: Lost new custom toolbar button with its macro

146: Tough for me - Import 30 macros from one excel file to another in one step

147: Cell switching

148: Defining an array to search by

149: Help with silly error

150: insert scanned image into text box

151: how can I compare data with two sampling rates

152: How can I know if Excel supports the fileformat constant?

153: Sheet protection

154: hiding sheets

155: Is excel capable of gouping numbers within 1 of each other

156: VBA + Excel Web Query - Timing Issues

157: Help Required With Snake Column

158: Creating a NUL Cell

159: auto filter question

160: QIF format

161: Strange currency symbols when importing .csv

162: Nesting function or other suggestions

163: Macro for sheet delete, very easy

164: replying to messages on this service

165: Lost modules being arranged by type

166: Export Japanese from MS-Access to Excel

167: Importing fractions with proper format from CSV

168: Deployment and config files

169: Probably a vlookup type ? not sure

170: bring up dialog box from command button?

171: Application-Defined or Object-Defined Error on simple code

172: auto open .xla file

173: Formula Question

174: arranging multiple custom menus

175: Circular reference error - where ?

176: Checking for a Task on windows?

177: Removing '0's' in cells

178: Open text file as text not numbers

179: deleting worksheets corrupts files

180: Visual Basic code to find next available (blank) row in a spreadsh

181: Preventing Blank based on another Cell

182: Stay in Combobox when reaching end

183: Is it possible to click in a cell and trigger a macro?

184: Global Variables using User Forms

185: How to get the row of a specified cell content

186: tab password

187: Blank fields

188: disabling send as attachment

189: xlDialogSaveAs

190: Restoring application settings at end of sub

191: Boxes in my addresses

192: Workbook_SheetChange

193: Editing Queries in Excel 2000

194: CELL CHANGE EVENT

195: How to check if the directory exists?

196: sort 2D array

197: Text to Columns help with my data

198: "show office assistant" greyed out; code suspect

199: Re: converting days into weeks

200: Using Tab Key In Excel

201: No fill color visible...not high contrast!

202: My 1st IF-THEN-ELSE Procedure

203: Reading data from a cell to a text box

204: What does the double dash or "--" do when using it in a function? (and other questions)

205: Incremental number field with User ID

206: Visual Basic run-time error when printing from web application...

207: sumif and countif nested?

208: Formatting Names

209: Why is inserting rows throwing off my hidden rows

210: Cut command

211: Use Advanced Filter to Detect non blank rows

212: Win Explorer to Excel

213: how to create constaints in solver

214: Day of the Week Calc in Excel

215: Zipping a file

216: What is the formula that works for this

217: Problem with Excel Header/Footer from .NET ???

218: Display Tab name in Cell

219: Cell Values from a Closed Workbook

220: Using lookup in a VBA procedure

221: Cell formatting -- why so slow?

222: Add per dates

223: macro...additional info

224: Changing Default Save Location for Email Attachments

225: Excel BNF

226: Random Name Generator

227: linking 9 workbooks

228: Display unique values in a range.

229: How do I update a checkbox as true when another has been updated

230: Find Excel files that have hidden workbook

231: Find Command

232: Can I count cells with specific format (e.g., yellow field?)

233: Is it a formula

234: inverse fourier

235: if declaration

236: how to switch pages in a multipage control by a commandbutton

237: finding internal links in excel directory

238: Excel 2007

239: Dynamic array seems invalid

240: Running Macro in Excel

241: Spell checking without the POP up ...

242: M I.5 Persecutio n ' abus e in set- up situati ons an d in publi c

243: offset and address?

244: using names

245: Emailing a form from a spreadsheet

246: Copy Range Issue

247: Specific Macros

248: mexcel macro to run onselect

249: countif(and) problem

250: Please help.. lost in code.

251: Kerning Issue In Excel

252: referring to previous worksheet in workbook

253: Arrange and Tiled

254: Can't Undo Macro Command

255: Printing

256: Excel Formulas

257: I need help writing a macro that will correct typing errors?

258: Simple programming help for newbie

259: Match / Sum Values

260: How do I copy data from one cell to the next occurrence of data?

261: Validation of cell results

262: How can I insert a row in MS Excel using a formula?

263: Sum formula

264: ADD-IN will not appear in MENU BAR

265: Multi Variable Formula

266: Change Event

267: Vba excel - evaluating value

268: "View" selection

269: Bringing in information from one worksheet to another dependent on the 2nd

270: Question about Query Wizard

271: calender for spreadsheet

272: Use cell value as reference to sheet in formula?

273: disappearing macros

274: How do I perform agreement statistics (kappa coeficient) in MS Ex.

275: File encoding problem

276: Insert code into worksheets programatically??

277: Re: Changes not saved in xla module

278: GETPIVOTDATA in Excel 2007

279: Array tally

280: creating formula

281: Changing active cell within a selection with mouse-click

282: Easypdf

283: Error in Excel 97 when running Excel 2000 macro

284: Get data from Outlook Public Folders in Excel

285: How do I get rid of too many active cells in Excel

286: double lookup

287: swap values between two cells

288: $ in functions

289: What function gives the Sheet name in Excel ?

290: return a collum heading

291: how do I get " 1st" to look proper (superscript the "st")

292: HELP! Brand new user to excel and having problems...

293: New sheet from the cell contents

294: Nested IF: Using CPEARSON Approach

295: Opening a Worksheet from a template

296: Multi format conditional formating

297: How check if form is loaded?

298: Commenting out code

299: =DAYS360 Function

300: Help with formula

301: VBA returning a cell address