Page 3

view full version: back to formated view

1: Advanced filter in VBA

2: Pivot Chart Help!

3: How do I flag duplicate addresses

4: Autoopen of an Excel File at the set time

5: space

6: Summation with a Condition

7: How can I shrink a file size w/ a pivot table and many formulas?

8: scheduling

9: Error Handling of system codes

10: On startup text to speech installation keeps appearing

11: change text format to time

12: From variable to excel constant

13: refresh a new worsheet on pivot table refresh

14: how do i convert a word document to excel

15: Are 2 dates between today's date

16: Calculation formula needed

17: «æ! ¤â¾÷²M³f5§é°_

18: use an if formula to fill cells with color

19: Changing specific Listbox value

20: Counting occurance of text values across multiple worksheets

21: copying nested if statements

22: how do i copy various sheets date to one sheet in the same excel .

23: Subtract/divide answer/add in one cell

24: Summing Values using multiple criertia

25: Easiest Way to do this Importing method?

26: Excel Returns for a Named Formula ; How is it gonna be Regular or Array Flavoured ?

27: combine 111 in one column & .jpg in another thru out entire works

28: Best Way to download XIRR

29: Help locking column on date value

30: Sheet1 object not Worksheets("Sheet1")

31: Compounding a percentage

32: Code to edit code

33: Comparing current time to a particular cell

34: Excel Quering Excel

35: Starting telnet/ssh from Excel

36: Using 'i' to calculate public variables

37: Help understanding truely strange error involving access query and filling cells

38: quick money

39: how do i assign a cel a colour system on a monthly report?

40: Count of Cells Based on Format

41: conditional indirect with data range

42: Chart placement

43: char to numeric value

44: finding matching cells in worksheets

45: Is there a way to have an Excel Macro fill out a IE web form repeatedly?

46: Transfering information to the next free cell in a column

47: Best Add-ins!

48: XL2000 "Custon Views" "Column width" Problem

49: Office 12 will be different?

50: Pulling a value from another sheet, based on date

51: Macro help

52: Hide columns & rows that contain "0" or blank in a range of cells

53: Leading 0s in zip codes suppressed - should be text or zip format

54: custom cell formatting

55: Adding sheets and copying data problem

56: editing spreadsheet

57: Custom data validation doesn't work well

58: Source data of a pivot table

59: Including .csv to end of filename

60: Open Word and fetch specific data

61: Trim not working....

62: looking for titps

63: Listbox Selection

64: formula

65: Pasting links & preserving original conditional formatting

66: Repeat: Active Cell's Address

67: trouble with an if statement

68: PRINTING COLOR

69: Create unique list from duplicates

70: userform zoom

71: Print Areas on multiple sheets

72: FWD: Install these corrective package from the MS Corporation

73: Subtracting dates

74: Declarations variables, Dim, some guidance please

75: Easy Excel Macro?

76: Help Request

77: Need help ....

78: Formula problem

79: Hyperlink

80: limits to amount of text in a cell

81: Automated range selection

82: MACRO TO LINK DATA !

83: index / match /lookup ? help

84: data formatting integrity

85: VLookup? Or something else

86: Macro: Excel 2000 does not work, XP does...

87: How do I get For Each C in Range to read columns first?

88: Removing Space

89: LINK TO OPEN EXCEL FILE !

90: Duplicate prevention from Listbox selections to worksheet

91: Help with COUNTIF formula

92: Protected sheet - Autofilter - Excel 97

93: Editing Code from Code

94: Horizontal category axis all packed together.

95: logic problem: help needed

96: Deleting Last values in an array

97: Formula para excel

98: ex2003: "The picture is too large and will be truncated" error

99: Formula for Numbers in Running Sequence

100: Why do I have a split screen on a saved Excel file?

101: SUMPRODUCT and other formulas combined...

102: Array

103: display the cell value in the next 33rd cell

104: countif????

105: Pivot table range over more than one worksheet

106: Macro log

107: Indirect inside a vlookup

108: Delete cell contents

109: Using Excel to find age

110: funcres.xla

111: Generating a Weekly Report based on a Date Range, where 1 Column = 1 Day

112: looking for information in the last column

113: Excel Buttons Disappear

114: Reference closed files in formula

115: Multiplying two columns

116: Formula to replace invalid filename characters

117: Buffer Overflow

118: Opening a PDF document from Visual basic

119: Help with a loop

120: Prevent rows from being selected

121: font colors print light

122: Deactivate tabs to click

123: Test on Username

124: A macro that copies and pastes autofiltered cells will fail.

125: Control Display Area

126: Excel's Personal Macro Workbook

127: VLookup not finding values unless lookup value is manually entered

128: Assigning numeric value to text in drop-down menu

129: linking multiple workbooks (VBA)

130: How to audit and edit Excell files on the journey?

131: I need help with comparing values in Excel and retrieving!!!

132: formula

133: Copy and pastespecial without formulas

134: Copying a formula with a pattern

135: Macro Error

136: Excel to COUNTIF if number greater than one but less than another

137: VLOOKUP won't generate correct response for "inbetween" values

138: Copy, delete and printing in 1step

139: downside standard deviation

140: ELSEIF for multiple if ??

141: deleting blank rows

142: VBA code to CC email

143: how do you use microsoft excel to calculate year to date average

144: enter into an excel cell...

145: Default Objects and code in cells to be in New cells/row when inse

146: Functions

147: Conditional Formatting lowest # if it only appears once

148: Looking for Excel VBA Example

149: Appending/Combining Named Ranges

150: Match cells by columns

151: Add Column Names to VBA script

152: pivot table converts to text

153: Count Occurance

154: Creating remote objects

155: A simple problem...

156: Make textbox1.value default

157: calculating number of weeks between two dates

158: Concatenate 3 columns.

159: RE-Post Max Function not working properly on 2D Array

160: Date function and combobox

161: Wondering If Possible

162: Values of non-contiguous cells

163: A real cut and paste

164: need help with a If=then situation.

165: delete rows with certain condition

166: Adding Column A for All sheets : Please HELP

167: How to change type of the cell?

168: Adding a date prompt to get external information

169: Division

170: How do I create a new worksheet using a template or xls file

171: Default Shading Darkness on Cells Selected

172: how to run other program's macro in excel?

173: Find Text File Import Cell

174: How to line up the last cell in each row?

175: Dates

176: Auto-fill Acrobat forms with Excel's data

177: Formula in VBA

178: How do I get an Excel Macro to repeat automatically?

179: Launch "Browser URL" when Cell clicked

180: FUNCTION STABILITY

181: Identifying Duplicate Values Code Modification Help

182: I guess this is something to do with "match".

183: increase range programmatically

184: Excel ScrollBar - Don't Move or Size with Cells ...

185: AutoFit

186: Macro help to rearrange excel table

187: Convert string from one codepage to another

188: Problems with Match function

189: How do I add the E column basd on the F column

190: Validation - e-mail

191: Textboxes on a worksheet

192: How this function S=( P*47/7-P) in Exel work

193: Help on Codes for Accumulating Figures

194: How do I find out what items are in one list but not in another l.

195: Location of arbitrary lookup

196: PriorSheet Function

197: sumproduct in a given year

198: Working out the age of a vehicle from UK Registration plate

199: How do you step thru a macro?

200: adding combo/list box to msgbox/inputbox

201: ListBox question

202: Which info to change in my macro?

203: Replace not giving expected results

204: SUMIF with two conditions

205: listbox works in form; not imbedded???

206: Automate Combine 2 Spreadsheets into two worksheets

207: Unable to Unhide Personal Macro workbook

208: counting multiple columns

209: set focus to form

210: 2004 Calendar

211: date

212: Formatting a cell

213: Is there a construction cost spreadsheet already available?

214: I want to make one loop

215: Project or Libary problem

216: Match function problem

217: Paste Cells in Column A to Columns B-K

218: sorting

219: countif = < > AND value in adjacent columns match criteria

220: Marco problem

221: Linking to external workbook

222: Vlookup function question

223: Macro List - personal.xls

224: Excel Date Time to Unix Time

225: missing toolbar

226: Macro To Print Files By A Listing of Filenames And Paths

227: Redefine UsedRange property of Worksheet Object

228: Weekly, Monthly Sums

229: Excel Macro using vb script

230: when i open a workbook, i cant type in it?

231: VBA on the net?

232: ScreenUpdating

233: Auto-format shading color.

234: FormulaArray problem

235: Need help with offset sort function

236: Writing complicated If statement in Excel

237: prevent cells to be mark

238: How do I change one line of a 3 line header

239: Sort a named range

240: Using cell text in a formula

241: Summary sheet for a list of sheets

242: Areas Collection Question

243: Listbox question please

244: using ado db connection in different workbook

245: Serious Slowness in this Situation--EnableEvents apparently not the issue

246: order worksheets alphabetically???

247: excel file size problems

248: No Undo after save - am i the only one bothered by this?

249: How to hidde sheet?

250: VBA excel issues

251: Summary of values from a date range

252: Index/Match Problem

253: Incorrect total of calculated field in pivot table

254: How can SS#s be displayed as text with all zeros and no dashes?

255: lookup formatted cell

256: subtotaling and manipulating a list of data

257: How to Delte Multiple Rows Given a Value Existing

258: PageSetup

259: Printing several worksheets as on page

260: cell change

261: Find images in a Excel document.. How !!

262: Extract data

263: Does Microsoft have a software to help with ongoing events planni.

264: Edit within a cell to select parts

265: Ttransferring excel from win98 to win2000 to excel 95

266: stop showing changed text in formula bar on different level

267: Any utility for joining two or more Excel or CVS files

268: Bullets

269: When word says Install I want it count the days for 3 days w.o wee

270: Help: How to Get Fields Mapped (using .Net ?

271: Make Border Lines Stay during Cut & Paste of Cell Contents

272: Tweaking a Macro to Count Words

273: extracting a subset of an array with VBA.

274: How can I insert stock quotes in excel (not through msn)?

275: Delete a row when a condition is met using VBA

276: Cell reference to userform

277: Area code funtion help

278: pivot tables and t-tests

279: Benefit attendance calendar make 2 items .5 points not 1 pt

280: vba code for Pivot Table

281: After File Open View Preview get error message

282: Selecting one cell will highting another(or range of) cell

283: i want to down load a solver in my excel programme...help...

284: refresh offline cube

285: retrieve a column I hid for printing

286: C# with Excel and conditional format

287: Auto fill references

288: Listbox refuses to resize

289: I want to change the column width on a spread sheet?

290: Excel 2003 Help Files

291: Combine 2 Data Validations Q

292: How to write an importer/exporter for excel

293: xlNone incorrectly valued?

294: How to Zoom current cell

295: Format of calculated member in VBA

296: API to find position of active cell no longer working in 2007.

297: The =IF key function

298: track employee on daily shortages of money

299: simple scrollbar question

300: Extracting same column from large number of workbooks

301: My post does not go through (twice)

2: Pivot Chart Help!

3: How do I flag duplicate addresses

4: Autoopen of an Excel File at the set time

5: space

6: Summation with a Condition

7: How can I shrink a file size w/ a pivot table and many formulas?

8: scheduling

9: Error Handling of system codes

10: On startup text to speech installation keeps appearing

11: change text format to time

12: From variable to excel constant

13: refresh a new worsheet on pivot table refresh

14: how do i convert a word document to excel

15: Are 2 dates between today's date

16: Calculation formula needed

17: «æ! ¤â¾÷²M³f5§é°_

18: use an if formula to fill cells with color

19: Changing specific Listbox value

20: Counting occurance of text values across multiple worksheets

21: copying nested if statements

22: how do i copy various sheets date to one sheet in the same excel .

23: Subtract/divide answer/add in one cell

24: Summing Values using multiple criertia

25: Easiest Way to do this Importing method?

26: Excel Returns for a Named Formula ; How is it gonna be Regular or Array Flavoured ?

27: combine 111 in one column & .jpg in another thru out entire works

28: Best Way to download XIRR

29: Help locking column on date value

30: Sheet1 object not Worksheets("Sheet1")

31: Compounding a percentage

32: Code to edit code

33: Comparing current time to a particular cell

34: Excel Quering Excel

35: Starting telnet/ssh from Excel

36: Using 'i' to calculate public variables

37: Help understanding truely strange error involving access query and filling cells

38: quick money

39: how do i assign a cel a colour system on a monthly report?

40: Count of Cells Based on Format

41: conditional indirect with data range

42: Chart placement

43: char to numeric value

44: finding matching cells in worksheets

45: Is there a way to have an Excel Macro fill out a IE web form repeatedly?

46: Transfering information to the next free cell in a column

47: Best Add-ins!

48: XL2000 "Custon Views" "Column width" Problem

49: Office 12 will be different?

50: Pulling a value from another sheet, based on date

51: Macro help

52: Hide columns & rows that contain "0" or blank in a range of cells

53: Leading 0s in zip codes suppressed - should be text or zip format

54: custom cell formatting

55: Adding sheets and copying data problem

56: editing spreadsheet

57: Custom data validation doesn't work well

58: Source data of a pivot table

59: Including .csv to end of filename

60: Open Word and fetch specific data

61: Trim not working....

62: looking for titps

63: Listbox Selection

64: formula

65: Pasting links & preserving original conditional formatting

66: Repeat: Active Cell's Address

67: trouble with an if statement

68: PRINTING COLOR

69: Create unique list from duplicates

70: userform zoom

71: Print Areas on multiple sheets

72: FWD: Install these corrective package from the MS Corporation

73: Subtracting dates

74: Declarations variables, Dim, some guidance please

75: Easy Excel Macro?

76: Help Request

77: Need help ....

78: Formula problem

79: Hyperlink

80: limits to amount of text in a cell

81: Automated range selection

82: MACRO TO LINK DATA !

83: index / match /lookup ? help

84: data formatting integrity

85: VLookup? Or something else

86: Macro: Excel 2000 does not work, XP does...

87: How do I get For Each C in Range to read columns first?

88: Removing Space

89: LINK TO OPEN EXCEL FILE !

90: Duplicate prevention from Listbox selections to worksheet

91: Help with COUNTIF formula

92: Protected sheet - Autofilter - Excel 97

93: Editing Code from Code

94: Horizontal category axis all packed together.

95: logic problem: help needed

96: Deleting Last values in an array

97: Formula para excel

98: ex2003: "The picture is too large and will be truncated" error

99: Formula for Numbers in Running Sequence

100: Why do I have a split screen on a saved Excel file?

101: SUMPRODUCT and other formulas combined...

102: Array

103: display the cell value in the next 33rd cell

104: countif????

105: Pivot table range over more than one worksheet

106: Macro log

107: Indirect inside a vlookup

108: Delete cell contents

109: Using Excel to find age

110: funcres.xla

111: Generating a Weekly Report based on a Date Range, where 1 Column = 1 Day

112: looking for information in the last column

113: Excel Buttons Disappear

114: Reference closed files in formula

115: Multiplying two columns

116: Formula to replace invalid filename characters

117: Buffer Overflow

118: Opening a PDF document from Visual basic

119: Help with a loop

120: Prevent rows from being selected

121: font colors print light

122: Deactivate tabs to click

123: Test on Username

124: A macro that copies and pastes autofiltered cells will fail.

125: Control Display Area

126: Excel's Personal Macro Workbook

127: VLookup not finding values unless lookup value is manually entered

128: Assigning numeric value to text in drop-down menu

129: linking multiple workbooks (VBA)

130: How to audit and edit Excell files on the journey?

131: I need help with comparing values in Excel and retrieving!!!

132: formula

133: Copy and pastespecial without formulas

134: Copying a formula with a pattern

135: Macro Error

136: Excel to COUNTIF if number greater than one but less than another

137: VLOOKUP won't generate correct response for "inbetween" values

138: Copy, delete and printing in 1step

139: downside standard deviation

140: ELSEIF for multiple if ??

141: deleting blank rows

142: VBA code to CC email

143: how do you use microsoft excel to calculate year to date average

144: enter into an excel cell...

145: Default Objects and code in cells to be in New cells/row when inse

146: Functions

147: Conditional Formatting lowest # if it only appears once

148: Looking for Excel VBA Example

149: Appending/Combining Named Ranges

150: Match cells by columns

151: Add Column Names to VBA script

152: pivot table converts to text

153: Count Occurance

154: Creating remote objects

155: A simple problem...

156: Make textbox1.value default

157: calculating number of weeks between two dates

158: Concatenate 3 columns.

159: RE-Post Max Function not working properly on 2D Array

160: Date function and combobox

161: Wondering If Possible

162: Values of non-contiguous cells

163: A real cut and paste

164: need help with a If=then situation.

165: delete rows with certain condition

166: Adding Column A for All sheets : Please HELP

167: How to change type of the cell?

168: Adding a date prompt to get external information

169: Division

170: How do I create a new worksheet using a template or xls file

171: Default Shading Darkness on Cells Selected

172: how to run other program's macro in excel?

173: Find Text File Import Cell

174: How to line up the last cell in each row?

175: Dates

176: Auto-fill Acrobat forms with Excel's data

177: Formula in VBA

178: How do I get an Excel Macro to repeat automatically?

179: Launch "Browser URL" when Cell clicked

180: FUNCTION STABILITY

181: Identifying Duplicate Values Code Modification Help

182: I guess this is something to do with "match".

183: increase range programmatically

184: Excel ScrollBar - Don't Move or Size with Cells ...

185: AutoFit

186: Macro help to rearrange excel table

187: Convert string from one codepage to another

188: Problems with Match function

189: How do I add the E column basd on the F column

190: Validation - e-mail

191: Textboxes on a worksheet

192: How this function S=( P*47/7-P) in Exel work

193: Help on Codes for Accumulating Figures

194: How do I find out what items are in one list but not in another l.

195: Location of arbitrary lookup

196: PriorSheet Function

197: sumproduct in a given year

198: Working out the age of a vehicle from UK Registration plate

199: How do you step thru a macro?

200: adding combo/list box to msgbox/inputbox

201: ListBox question

202: Which info to change in my macro?

203: Replace not giving expected results

204: SUMIF with two conditions

205: listbox works in form; not imbedded???

206: Automate Combine 2 Spreadsheets into two worksheets

207: Unable to Unhide Personal Macro workbook

208: counting multiple columns

209: set focus to form

210: 2004 Calendar

211: date

212: Formatting a cell

213: Is there a construction cost spreadsheet already available?

214: I want to make one loop

215: Project or Libary problem

216: Match function problem

217: Paste Cells in Column A to Columns B-K

218: sorting

219: countif = < > AND value in adjacent columns match criteria

220: Marco problem

221: Linking to external workbook

222: Vlookup function question

223: Macro List - personal.xls

224: Excel Date Time to Unix Time

225: missing toolbar

226: Macro To Print Files By A Listing of Filenames And Paths

227: Redefine UsedRange property of Worksheet Object

228: Weekly, Monthly Sums

229: Excel Macro using vb script

230: when i open a workbook, i cant type in it?

231: VBA on the net?

232: ScreenUpdating

233: Auto-format shading color.

234: FormulaArray problem

235: Need help with offset sort function

236: Writing complicated If statement in Excel

237: prevent cells to be mark

238: How do I change one line of a 3 line header

239: Sort a named range

240: Using cell text in a formula

241: Summary sheet for a list of sheets

242: Areas Collection Question

243: Listbox question please

244: using ado db connection in different workbook

245: Serious Slowness in this Situation--EnableEvents apparently not the issue

246: order worksheets alphabetically???

247: excel file size problems

248: No Undo after save - am i the only one bothered by this?

249: How to hidde sheet?

250: VBA excel issues

251: Summary of values from a date range

252: Index/Match Problem

253: Incorrect total of calculated field in pivot table

254: How can SS#s be displayed as text with all zeros and no dashes?

255: lookup formatted cell

256: subtotaling and manipulating a list of data

257: How to Delte Multiple Rows Given a Value Existing

258: PageSetup

259: Printing several worksheets as on page

260: cell change

261: Find images in a Excel document.. How !!

262: Extract data

263: Does Microsoft have a software to help with ongoing events planni.

264: Edit within a cell to select parts

265: Ttransferring excel from win98 to win2000 to excel 95

266: stop showing changed text in formula bar on different level

267: Any utility for joining two or more Excel or CVS files

268: Bullets

269: When word says Install I want it count the days for 3 days w.o wee

270: Help: How to Get Fields Mapped (using .Net ?

271: Make Border Lines Stay during Cut & Paste of Cell Contents

272: Tweaking a Macro to Count Words

273: extracting a subset of an array with VBA.

274: How can I insert stock quotes in excel (not through msn)?

275: Delete a row when a condition is met using VBA

276: Cell reference to userform

277: Area code funtion help

278: pivot tables and t-tests

279: Benefit attendance calendar make 2 items .5 points not 1 pt

280: vba code for Pivot Table

281: After File Open View Preview get error message

282: Selecting one cell will highting another(or range of) cell

283: i want to down load a solver in my excel programme...help...

284: refresh offline cube

285: retrieve a column I hid for printing

286: C# with Excel and conditional format

287: Auto fill references

288: Listbox refuses to resize

289: I want to change the column width on a spread sheet?

290: Excel 2003 Help Files

291: Combine 2 Data Validations Q

292: How to write an importer/exporter for excel

293: xlNone incorrectly valued?

294: How to Zoom current cell

295: Format of calculated member in VBA

296: API to find position of active cell no longer working in 2007.

297: The =IF key function

298: track employee on daily shortages of money

299: simple scrollbar question

300: Extracting same column from large number of workbooks

301: My post does not go through (twice)