Page 273

view full version: back to formated view

1: CHANGE SHEET

2: Protected Workbook

3: Pivot table NOT showing zero value calculations

4: Emergency! Can I use Maco to export excel data into word forms

5: Help! Limit on number of Ranges you can use at one time?

6: combination

7: Conditional Formating

8: How do I make a formula determine a.m. hrs and p.m. hrs in excel?

9: How to get an exact mactch with Vlookup

10: Need to tailor my macro code.

11: enter formula into Excel worksheet without losing numbers

12: an excellent time waster

13: selecting a range

14: Circle Reference

15: Question about Input Box and how to use the entered value

16: SUMPRODUCT

17: Using VBA to send email to distribution list ... how to CC?

18: compare data in two lists to find matching entries

19: difference between the 2

20: Help with logical function

21: ascii file import round 2

22: VBA Script to Print several named ranges to PDF with cell-defined filenames

23: Find

24: Unable to Update Links.

25: How do i get Excel not to drop my 1st zero (02360)

26: Macro Programming in Excel 2003

27: Having troubles using visual basic to paste info from one workbook to another

28: Calculate Minimum numbers

29: Getting Zoom Factor

30: How do I enter a function that has more than 7 nested functions

31: Adding Cells and Indexing

32: counting blank cells via pivot table

33: Problem with time calc

34: Checking for security level to allow macros to run

35: In Excel,how do I display my title cells so that as I scroll down.

36: Delete Tab Formula Problem

37: Problem with a date and concatenation

38: Download other functions

39: Updating links with VBA

40: Declaring variables (Long, String, Integer) and interpretation spe

41: Foolproof .find

42: Macro warning pops up at file open

43: msgbox on workbook open

44: Saving File with information from Text Box

45: Count number of cells that are highlighted

46: Filter

47: Create a hyperlink with querystring from cell

48: Parsing text

49: saving worksheet without code page

50: separate copy of excel

51: data set for linear regression

52: Slow Open & Odd Close

53: Retrieving data over a network

54: filtering out whole pages only

55: recursive or loopless combinations

56: Excel 2007

57: Referencing 3 values for a lookup

58: Sorting into Groups equal size

59: Autofill columns

60: linking problem REALLY NEED SOMEONE TO HELP ME!!

61: Worksheet Change to build product list

62: Matching athletes and scores

63: How to create a live chart

64: How can I type business cards?

65: Converting Comments to Footnote Type References

66: Make it possible to split unmerged cells again!!!

67: Advance handling with duplicates

68: Copying hidden pages

69: Select specific cells in same row as active cell

70: (repost) Code to refer to 6 pivot tables on same sheet

71: Save excel sheet.

72: Changing the font in a check box

73: transfer data between sheets

74: Userform and Cell Email Hyperlink

75: Userfrm Lookup Works For text not Number

76: Euro Converstion

77: math

78: COUNTIF when range is cells with formula

79: Code runs every other time

80: Why text to columns is not available when there is mulipule line .

81: Closing a possible Workbook

82: display the day of the date

83: Executing a macro

84: InputBox to get user hidden columns question

85: Getting digits out of a text string

86: Hide Rows in one W/S Based on a cell value in Another W/S

87: Convert column values into a single cell

88: RTD only alive when Excel is active app?

89: Multiple functions based on date.

90: Re: Format cell color based on multiple variables

91: Workbook disappeared

92: HOW CAN YOU ADD 3 SPREADSHEETS AT THE SAME TIME?

93: find numbers in a list which sum a total

94: Quick creation of hyperlinks

95: UF within a loop

96: Action on Error

97: Collections problem

98: Jumping reference cell in dependent cell formula

99: Adding conditional formatting to individual bars in bar chart

100: Can't see sheet, and have tried unhide, etc?

101: Using Concatenate inside a vlookup

102: Hiding Rows

103: saving an excel file as an ASCII text file without delimiters

104: Struggling with TIME calculations ...

105: conditional formating

106: stillcheckbox remains a pain Frank

107: General Cut & Paste Issue

108: Inserting Rows, but keeping row size

109: How do I add a picture to the background?

110: delete vbcode dynamically

111: Turn this into VBA code

112: Delete many cell comments simultaneously

113: Delete all rows not today

114: Copy rows to master sheet

115: Printing names and addresses

116: Workbooks.Add fails when executed within IE

117: Midnight disappears

118: PivotCache

119: scan rows

120: Identify if a page break occours while entering data

121: calculation in pivot table with value of a column

122: Renaming a standard module

123: Print button

124: Protecting Cells

125: structure of classes,objects,properties,methodes,events...

126: Problem with overflow

127: Font sizes changes erratically

128: msgbox text vbyesno

129: Balanced Scorecards

130: Printing to Generic / Text printer

131: Excel Workbook opened twice with dotnet interop

132: Returning expected dates

133: Selecting filename in cell from file browser

134: Find a Min positive value

135: Info

136: Macros - Range Selection

137: Removing minus numbers from a sumif

138: Extracting Email Addresses

139: How do I find the last number in a column?

140: Price List and Quote Form

141: Transfer data as per there date in there month.

142: Accessing External Data

143: How Merge 2 files with same acc# in each file

144: UDFs/Macros in workbook

145: Having data automatically populated in a different sheet

146: Function to return True/False if all are validated as True by ISNU

147: Linking from Excel to Word

148: Data Validation

149: Entering time values

150: problem with subtotal

151: How to search the Windows registry by recursion until a reg key is found

152: Dates and linking between spreadsheets question.

153: Change source ofr edit link is greyed out

154: Macro to hide rows with a certain cell empty then set print area and print

155: How to add one digit "0" in the front of a number

156: Check cell for data before running code

157: Problem with Macro Code

158: adding IF statement to subtotal for autofiltered data

159: Shared Workbook in Excel XP or greater

160: colums in uppercase only

161: secondary mouse button

162: need help with IF

163: PDF Add-in for Excel 2003

164: Constant loan payments vs. constant payments of principal

165: Screen Resolution

166: Dependant Combobox

167: How can I connect a word of text to a certain dollar value?

168: needing some If Range value

169: Age from birthdate

170: Sum the values of cells based on fontcolor

171: modify cells from VBA formula context

172: Calling a function in another project from within a cell formula

173: AddIn Project for Excel

174: Automation Error and Document not saved

175: How to calculate number of month from 2008 in Excel?

176: Volume and pricing calculations

177: Button Problem

178: Pull Down Menu Macro

179: macro to hide # of columns based on value

180: is there a way to add single digits within a single cell?

181: check if cell is part of range

182: How to format cells to show dates as the week-ending date of that

183: Sum numbers based on specified criteria

184: dynamic color changing within cells

185: Excel Template Needed

186: reducing a fraction

187: Linking files where end-product will be on CD

188: Currency format for combo box in a user form

189: Print wrapping

190: MS Access Query

191: How can I convert This

192: Multiple Vlookups & IF statments

193: Calendar Mail Merge??

194: Extracting information from a database

195: form button question

196: formula: counting presence

197: double array

198: MACROS: Protect a cell depending on the value of another cell

199: hidden VBA

200: moving cursor, may solve big problem

201: Break Link

202: Problem using names as integer type

203: Looping through cells using VBA

204: Trendline Coefficients

205: OnAction

206: COUNTIF

207: Failure to save a "shared" workbook

208: MailMerge Label printing from Excel

209: Chart

210: Wrong text in msgbox

211: Unknown problem with simple VBA code

212: set print area based on selection

213: Head in pieces over formula

214: How do you delete leading zeros from numbers?

215: Extract date from right to left in a cell

216: Protect cell - VBA

217: I want to accept one value only or error out cell

218: Tab color

219: import rss feed into excel ( rss --> excel )

220: Unable to edit DialogSheets in XLA

221: Formats Cells in Worksheet not avaible

222: Highlight / "Selection" of AutoShape Text (Like SelStart for TextBoxes)

223: Excel VBA to send email using Lotus Notes

224: Calculate Employee Vacation Due

225: fixed length file

226: my worksheet getting blank

227: List of Printers

228: M.I'5`Per secution - Comparin g th e M I5 Per secution wi th G erman Fi nal S olution

229: Over a million cells in my spreadsheet

230: exit event

231: consolidate data

232: Currency Format

233: how to close app in code?

234: Saving data

235: Macro help

236: Variable Reference in R1C1 format

237: Remote Access to a Spreadsheet

238: AutoExec

239: Suggest some vb books

240: Object Name

241: Programmatically query Excel drop-down list ?

242: Excel VBA job

243: Make active cell a variable, return there later

244: lookup function .... I think???

245: Selecting File and FilePath

246: Full hyperlink issue, please help - end of my tether lol

247: Dates in Excel

248: changing the semicolon as separator in csv

249: help with Hyperlink formula setup

250: Urgent-formating of columns

251: ANSI codes

252: How to use an if statement to show if ANY value in the cell?

253: Vary formula based on what another cell contains

254: Concatinating text plus cell containing date

255: How to copy data in one cell into different rows

256: Custom Function to Retrieve Spread Sheet Data

257: Text box on userform

258: unbound pastespecial in Access

259: Changing to lower case

260: Cumulative sum with a ceiling

261: change minimum and maximum on logarithmic scale chart in excel

262: Option Buttons from the Forms Toolbar - Excel 2003

263: On Error Goto ignored

264: Refresh XML Data programmatically.

265: lookup

266: Printpreview problem - disable various buttons

267: Solver Table missing in Data Menu of Excel2003. Where is it?

268: Fill in the blanks!

269: Help with multi sheet referencing

270: Need to search workbook for NEW worksheet

271: Metafile Import in Excel 98 for Macintosh

272: Have the width/height of a autoshape placed in a cell

273: QuattroPro

274: Time differences in excel

275: making macro run automatically

276: One text box for multiple cells

277: Formula fails to read name

278: overflow error 6.. the macro just stops any idea why?

279: worksheet events and a little more help

280: Excel 2003 ODBC Add-in

281: Ron - Summary_cells_from_Different_Workbooks_2

282: Filling a ComboBox?

283: Count if array contains cells of a certain value

284: Visual Studio 2005 Tools for Office

285: Excel Sort Tie Breaker

286: Statistics on data

287: VBA Code incorrectly formatting data

288: variable = current cell in VB

289: Converting Mainframe DISPLAY data to EXCEL formats

290: Inserting a Value into a Range

291: Macro for multiple charts

292: UCase?

293: Adding a date when something was created.

294: Application.OnKey problem

295: Budget tracking tool

296: Move Column Data into a row

297: Formula/function

298: Can't paste cells between sheets and have formulas follow

299: Conditional Functions

300: How do I deal with a "Too many different cell formats".

2: Protected Workbook

3: Pivot table NOT showing zero value calculations

4: Emergency! Can I use Maco to export excel data into word forms

5: Help! Limit on number of Ranges you can use at one time?

6: combination

7: Conditional Formating

8: How do I make a formula determine a.m. hrs and p.m. hrs in excel?

9: How to get an exact mactch with Vlookup

10: Need to tailor my macro code.

11: enter formula into Excel worksheet without losing numbers

12: an excellent time waster

13: selecting a range

14: Circle Reference

15: Question about Input Box and how to use the entered value

16: SUMPRODUCT

17: Using VBA to send email to distribution list ... how to CC?

18: compare data in two lists to find matching entries

19: difference between the 2

20: Help with logical function

21: ascii file import round 2

22: VBA Script to Print several named ranges to PDF with cell-defined filenames

23: Find

24: Unable to Update Links.

25: How do i get Excel not to drop my 1st zero (02360)

26: Macro Programming in Excel 2003

27: Having troubles using visual basic to paste info from one workbook to another

28: Calculate Minimum numbers

29: Getting Zoom Factor

30: How do I enter a function that has more than 7 nested functions

31: Adding Cells and Indexing

32: counting blank cells via pivot table

33: Problem with time calc

34: Checking for security level to allow macros to run

35: In Excel,how do I display my title cells so that as I scroll down.

36: Delete Tab Formula Problem

37: Problem with a date and concatenation

38: Download other functions

39: Updating links with VBA

40: Declaring variables (Long, String, Integer) and interpretation spe

41: Foolproof .find

42: Macro warning pops up at file open

43: msgbox on workbook open

44: Saving File with information from Text Box

45: Count number of cells that are highlighted

46: Filter

47: Create a hyperlink with querystring from cell

48: Parsing text

49: saving worksheet without code page

50: separate copy of excel

51: data set for linear regression

52: Slow Open & Odd Close

53: Retrieving data over a network

54: filtering out whole pages only

55: recursive or loopless combinations

56: Excel 2007

57: Referencing 3 values for a lookup

58: Sorting into Groups equal size

59: Autofill columns

60: linking problem REALLY NEED SOMEONE TO HELP ME!!

61: Worksheet Change to build product list

62: Matching athletes and scores

63: How to create a live chart

64: How can I type business cards?

65: Converting Comments to Footnote Type References

66: Make it possible to split unmerged cells again!!!

67: Advance handling with duplicates

68: Copying hidden pages

69: Select specific cells in same row as active cell

70: (repost) Code to refer to 6 pivot tables on same sheet

71: Save excel sheet.

72: Changing the font in a check box

73: transfer data between sheets

74: Userform and Cell Email Hyperlink

75: Userfrm Lookup Works For text not Number

76: Euro Converstion

77: math

78: COUNTIF when range is cells with formula

79: Code runs every other time

80: Why text to columns is not available when there is mulipule line .

81: Closing a possible Workbook

82: display the day of the date

83: Executing a macro

84: InputBox to get user hidden columns question

85: Getting digits out of a text string

86: Hide Rows in one W/S Based on a cell value in Another W/S

87: Convert column values into a single cell

88: RTD only alive when Excel is active app?

89: Multiple functions based on date.

90: Re: Format cell color based on multiple variables

91: Workbook disappeared

92: HOW CAN YOU ADD 3 SPREADSHEETS AT THE SAME TIME?

93: find numbers in a list which sum a total

94: Quick creation of hyperlinks

95: UF within a loop

96: Action on Error

97: Collections problem

98: Jumping reference cell in dependent cell formula

99: Adding conditional formatting to individual bars in bar chart

100: Can't see sheet, and have tried unhide, etc?

101: Using Concatenate inside a vlookup

102: Hiding Rows

103: saving an excel file as an ASCII text file without delimiters

104: Struggling with TIME calculations ...

105: conditional formating

106: stillcheckbox remains a pain Frank

107: General Cut & Paste Issue

108: Inserting Rows, but keeping row size

109: How do I add a picture to the background?

110: delete vbcode dynamically

111: Turn this into VBA code

112: Delete many cell comments simultaneously

113: Delete all rows not today

114: Copy rows to master sheet

115: Printing names and addresses

116: Workbooks.Add fails when executed within IE

117: Midnight disappears

118: PivotCache

119: scan rows

120: Identify if a page break occours while entering data

121: calculation in pivot table with value of a column

122: Renaming a standard module

123: Print button

124: Protecting Cells

125: structure of classes,objects,properties,methodes,events...

126: Problem with overflow

127: Font sizes changes erratically

128: msgbox text vbyesno

129: Balanced Scorecards

130: Printing to Generic / Text printer

131: Excel Workbook opened twice with dotnet interop

132: Returning expected dates

133: Selecting filename in cell from file browser

134: Find a Min positive value

135: Info

136: Macros - Range Selection

137: Removing minus numbers from a sumif

138: Extracting Email Addresses

139: How do I find the last number in a column?

140: Price List and Quote Form

141: Transfer data as per there date in there month.

142: Accessing External Data

143: How Merge 2 files with same acc# in each file

144: UDFs/Macros in workbook

145: Having data automatically populated in a different sheet

146: Function to return True/False if all are validated as True by ISNU

147: Linking from Excel to Word

148: Data Validation

149: Entering time values

150: problem with subtotal

151: How to search the Windows registry by recursion until a reg key is found

152: Dates and linking between spreadsheets question.

153: Change source ofr edit link is greyed out

154: Macro to hide rows with a certain cell empty then set print area and print

155: How to add one digit "0" in the front of a number

156: Check cell for data before running code

157: Problem with Macro Code

158: adding IF statement to subtotal for autofiltered data

159: Shared Workbook in Excel XP or greater

160: colums in uppercase only

161: secondary mouse button

162: need help with IF

163: PDF Add-in for Excel 2003

164: Constant loan payments vs. constant payments of principal

165: Screen Resolution

166: Dependant Combobox

167: How can I connect a word of text to a certain dollar value?

168: needing some If Range value

169: Age from birthdate

170: Sum the values of cells based on fontcolor

171: modify cells from VBA formula context

172: Calling a function in another project from within a cell formula

173: AddIn Project for Excel

174: Automation Error and Document not saved

175: How to calculate number of month from 2008 in Excel?

176: Volume and pricing calculations

177: Button Problem

178: Pull Down Menu Macro

179: macro to hide # of columns based on value

180: is there a way to add single digits within a single cell?

181: check if cell is part of range

182: How to format cells to show dates as the week-ending date of that

183: Sum numbers based on specified criteria

184: dynamic color changing within cells

185: Excel Template Needed

186: reducing a fraction

187: Linking files where end-product will be on CD

188: Currency format for combo box in a user form

189: Print wrapping

190: MS Access Query

191: How can I convert This

192: Multiple Vlookups & IF statments

193: Calendar Mail Merge??

194: Extracting information from a database

195: form button question

196: formula: counting presence

197: double array

198: MACROS: Protect a cell depending on the value of another cell

199: hidden VBA

200: moving cursor, may solve big problem

201: Break Link

202: Problem using names as integer type

203: Looping through cells using VBA

204: Trendline Coefficients

205: OnAction

206: COUNTIF

207: Failure to save a "shared" workbook

208: MailMerge Label printing from Excel

209: Chart

210: Wrong text in msgbox

211: Unknown problem with simple VBA code

212: set print area based on selection

213: Head in pieces over formula

214: How do you delete leading zeros from numbers?

215: Extract date from right to left in a cell

216: Protect cell - VBA

217: I want to accept one value only or error out cell

218: Tab color

219: import rss feed into excel ( rss --> excel )

220: Unable to edit DialogSheets in XLA

221: Formats Cells in Worksheet not avaible

222: Highlight / "Selection" of AutoShape Text (Like SelStart for TextBoxes)

223: Excel VBA to send email using Lotus Notes

224: Calculate Employee Vacation Due

225: fixed length file

226: my worksheet getting blank

227: List of Printers

228: M.I'5`Per secution - Comparin g th e M I5 Per secution wi th G erman Fi nal S olution

229: Over a million cells in my spreadsheet

230: exit event

231: consolidate data

232: Currency Format

233: how to close app in code?

234: Saving data

235: Macro help

236: Variable Reference in R1C1 format

237: Remote Access to a Spreadsheet

238: AutoExec

239: Suggest some vb books

240: Object Name

241: Programmatically query Excel drop-down list ?

242: Excel VBA job

243: Make active cell a variable, return there later

244: lookup function .... I think???

245: Selecting File and FilePath

246: Full hyperlink issue, please help - end of my tether lol

247: Dates in Excel

248: changing the semicolon as separator in csv

249: help with Hyperlink formula setup

250: Urgent-formating of columns

251: ANSI codes

252: How to use an if statement to show if ANY value in the cell?

253: Vary formula based on what another cell contains

254: Concatinating text plus cell containing date

255: How to copy data in one cell into different rows

256: Custom Function to Retrieve Spread Sheet Data

257: Text box on userform

258: unbound pastespecial in Access

259: Changing to lower case

260: Cumulative sum with a ceiling

261: change minimum and maximum on logarithmic scale chart in excel

262: Option Buttons from the Forms Toolbar - Excel 2003

263: On Error Goto ignored

264: Refresh XML Data programmatically.

265: lookup

266: Printpreview problem - disable various buttons

267: Solver Table missing in Data Menu of Excel2003. Where is it?

268: Fill in the blanks!

269: Help with multi sheet referencing

270: Need to search workbook for NEW worksheet

271: Metafile Import in Excel 98 for Macintosh

272: Have the width/height of a autoshape placed in a cell

273: QuattroPro

274: Time differences in excel

275: making macro run automatically

276: One text box for multiple cells

277: Formula fails to read name

278: overflow error 6.. the macro just stops any idea why?

279: worksheet events and a little more help

280: Excel 2003 ODBC Add-in

281: Ron - Summary_cells_from_Different_Workbooks_2

282: Filling a ComboBox?

283: Count if array contains cells of a certain value

284: Visual Studio 2005 Tools for Office

285: Excel Sort Tie Breaker

286: Statistics on data

287: VBA Code incorrectly formatting data

288: variable = current cell in VB

289: Converting Mainframe DISPLAY data to EXCEL formats

290: Inserting a Value into a Range

291: Macro for multiple charts

292: UCase?

293: Adding a date when something was created.

294: Application.OnKey problem

295: Budget tracking tool

296: Move Column Data into a row

297: Formula/function

298: Can't paste cells between sheets and have formulas follow

299: Conditional Functions

300: How do I deal with a "Too many different cell formats".