Page 198

view full version: back to formated view

1: Microsoft Map

2: Weekday formula calculating to end of month

3: Exporting numbers into Excel

4: Pasting filtered rows

5: Exceed Row Limit

6: workbook macros now run VERY slowly ... ideas please

7: badly struck! how to pass values from asp to excel

8: export excel macros

9: Macintosh and VB Scripts

10: Investment FV

11: file properties with cell data?

12: Automatically enter page breaks?

13: LOOKUP funciion giving an error

14: Macro Request: Fill in empty cells with previous Filled cell in column

15: Concat and summarize 6 columns to 2 columns

16: How can I combine the functions of a vlookup and sumif without a p

17: countif number of occurences per month per year.

18: Help: Making a copying macro from cursor position ?

19: Assign macro to button in EXCEL 2003

20: two problems with excel 2003

21: my excel printout not straight

22: How to: Assign pop up when command button is pushed

23: ?IF function for preventing a cell being filled by formula

24: Time Delay for Macros

25: Simple +formula not reading value from the reference cell

26: Adding and Reading a ListBox Item

27: how create library of routines?

28: RePost - Creating WBooks

29: Excel won't quit

30: read data from a cell absolutely

31: TIME math

32: Logical Functions

33: TypeLib Information Problem? Pass a Function's parameter names as string for parsing?

34: Summary of Different Workbooks

35: How to declare variable as public.

36: Two If's - one in a range

37: VLookUp Error Handling Needed

38: printing time literally

39: Calculated Fields in Pivot Tables

40: Locked cell without alert

41: YAPTQ - Yet Another Pivot Table Question

42: Redirecting a formula in an "IF THEN" statement

43: Formulas in Excel XP

44: I need an excel sheet to creating a new folder every month, and save a new spreadsheet every day, untill the next month, when it creates a new folder

45: Macro not found in Application.Run

46: Create copy of sheet using VB with columns in different order

47: Is there a way to remove a menue option (other than macro code)?

48: Hide Empty Rows When Printing

49: Right mouse click doesn't work

50: Tough problem with rotas

51: Return next non-Blank Cell in a Column ?

52: Excel 2000 VBA Form Combobox value

53: changing active cell

54: Customizing Toolbar

55: Windows Forms 2.0

56: Adding Range Names

57: .onaction, passing arguments

58: $ format in cell

59: Adding "0" as leading digits into cells in Excel

60: Charts

61: Chart source data when copying from one workbook to another

62: Excel Bug Moves Cmd Buttons When Print

63: Entering Seconds but displaying minutes & seconds

64: Sum up identical workbooks

65: Moving data from column A to Columns B,C,D,E

66: A questions of versions

67: Excel Droping The Last Number

68: Loop through Column and add hyperlink

69: Cell check

70: Document Recovery

71: Converting Text Dates to Serial Numbers

72: Excel 2003 User name

73: Preserving hyperlinks in linked cells

74: can you create a macro to compare two different doc side by side

75: Excel add-in set title?

76: Auto Formatting on Open

77: Check if a worksheet exists

78: Create a Button that will print sheets

79: Office 2003 Detect & Repair

80: Name of the defualt shortcut commandbar.

81: SUMIF only it has 3 ceretain texts in the same row

82: text box size problem

83: ODBC error linking to Sybase database

84: Needing help with Vlookup or if there's a simplier way of doing it

85: vb scripting -- copying web page, paste as text

86: How do I read data from an OPC server into an Excel worksheet?

87: Enable Live Preview -Excel 2007

88: Error querying for open VBprojects in XP?

89: Linking and/or macros

90: Date Criteria in Excel Macro

91: Automating XL charts from VB.NET 2003

92: Freeze titles (Figer les volets)

93: drop down list

94: Combo Box easy question?

95: VBA WinInet Code Crashes Excel

96: Reference the active sheet

97: sheet name

98: Can autofilter sum and average columns of numbers? Thank you

99: SeriesCollection object in Excel 2007 and 2003

100: Multipage: [Me.Controls("Page" & i).Name] does not work

101: MOUS - Pivot Tables..I'm never going to get it

102: Debug.Print in a WITH procedure?

103: Command for recalculating macros

104: Match and extract

105: SUMPRODUCT Question

106: i need help

107: Calculating Dates and Hours

108: updating email addresses in cells

109: FollowHyperlink ExtraInfo string max length?

110: Template Question

111: Progress bar/meter for duration of code - No loop

112: Learning resource for VBA

113: run macro after print command.

114: create a ASCII semi-colon or comma delimited file

115: Column Widths

116: getting wrong results with my VLOOKUP usage

117: How do I auto change text colour in excel to reflect the value ent

118: Count Function in Date Field

119: VBA AVERAGE formula, ignoring zeros

120: Break one line item into many...

121: How to trim a string to the last "."

122: Problem With Opening Embedded Object After Turning On "Track Chang

123: I want to limit the result of a calculation to a maximum number...

124: VB

125: How do I rename files that are related.

126: Can I make a cell change colour automatically

127: Lookup in an array

128: Conditional formatting and formula

129: Formatting

130: Macro and user created button Question?

131: Excel Runtime Available?

132: Automatic generation of Trouble Tickets

133: disable X button in main window

134: Control Combo Box Macros

135: Excel question, will pay for answer, calculating commission schedu

136: Formal to compare a list

137: Implimenting a shift in a power trendline graph

138: Change "Company" field in File Properties

139: variable paste or fill range

140: Excel NewWorkbook event

141: merging excel program with tdc finance program

142: excel formula

143: MapPoint Colors

144: Excel Pivot tables connecting to sql

145: Importing Data Into Excel

146: Bullet Points in Excel

147: Popup message when clicking on a cell

148: How do I insert spaces between characters

149: odd vlookup solution required - can you rise to the challenge?!

150: Refresh Pivot Table from other worksheet cell entry

151: Adding New Member Variables to Cells and Worksheets

152: NETWORKDAYS FORMULA

153: Naming Current Region

154: screen flicking

155: Resizing a Picture

156: Cells: Any way to code an event behind one?

157: Turn off automatic date formatting

158: ODBC driver does not support the requested properties

159: Dynamic dropdown?

160: VB for importing data into excel in proper columns

161: Can I lock the selection in the pivot table?

162: Visual Basic Macro(VBA) for a password protected file?

163: Eliminating a split

164: Match a text

165: replace Hyperlink with URL

166: Summing while hiding?!

167: New from Template Issue

168: Combo box list depends on value

169: Print to File Technique

170: User defined function: Address where UDF is used

171: Quick hiding of rows in WS_Activate ()

172: Enable/Disable SAVE AS button from code

173: Can I use serial comm port in Excel VB script?

174: Sudoku puzzle template

175: Is it possible?

176: vlookup combo box

177: 2007 Excel Skipping Columns on printout preview and printing.

178: is sheet protected?

179: opening a file

180: Checking access to Sharepoint prior to use

181: How to feed a userform a variable to display in a textbox?

182: counta in array formula not working

183: Can anyone please help with this - 3rd post

184: repost: Need Help With Steaming Data Macro

185: Commandbar

186: Counting Positions

187: Comparing values in two columns and displaying missing values in n

188: Check Box/Tick Box

189: how to copy same percentage to complete worksheet

190: Help With Very Simple Code

191: Simple Equation Builder/Solver in Excel for use in Dell Axim X51v

192: Help with quiting a workbook

193: 'conditional format' cells for the highest number in a range

194: Running a query and/or 3D Referencing

195: VLookup & Column Sum

196: Project is unviewable

197: Plesae help: Excel function

198: Find value and adress

199: Copy pasted name range

200: Exporting Excel Data As Unformatted Text

201: Execute a batch file from inside Excel

202: I am stupid and don't know what the heck I am doing wrong on this pivot table

203: Client Access to iSeries Automation

204: Conditional Row Deleting

205: Drop down list options dependent on cell value

206: delete non adjacent columns when blank

207: How do i copy rows to columns on separate sheet, and have them upd

208: no focus when spreadsheets opens

209: probably simple, but not for me, help please

210: Comparing data based on two columns

211: Hidden Character

212: Event Change Question

213: Calculation Question

214: Is it possible...lookup macro

215: Grabbing Data From Second Combo Box Column

216: Setting up a rule to reply to specific people

217: Can we get the size of a sheet ?

218: Dates formula problem

219: Update XLS File from XLT File

220: Workbook level recalculation

221: how do i put color in a cell based on data in a second cell

222: blank cells

223: Function for splitting a name to two cells from 1 input

224: Q re: TextToColumns

225: Try this critical pack from MS

226: exluding missing data values from equation

227: a summation problem

228: Êóïëþ Windows,Office,Server

229: greater than but less than operators for VBA

230: VBA PC-Mac Compatibility

231: Help on subscript out of range error (VB6/VBA)

232: How do I substitute text for numbers

233: Find and replace consecutive numbers

234: On load

235: Delete Insert Worksheet on Open/Reset on Close

236: VB Editor in Excel

237: range.comment.Text(...)

238: Concatenating a cell address

239: Values in spreadsheets do not update

240: Format a whole section if cell=0

241: Context Menu, Paste Special From Selected Range

242: Create several sheets

243: COUNTIF Function

244: Secure excel spreadsheet

245: Installing Office 2000 Standard new PC w/Windows XP Home Edition

246: Protecting a field

247: Excel not searching right

248: Q: search string

249: Points Ranking Formulas

250: Reply to Tom Ogilvy

251: Create worksheets and populate

252: Is the active worksheet protected?

253: cell help

254: characters...

255: displaying pictures

256: zip code

257: how to disable chart tab in Excel?

258: Check box formulas

259: How Do I Make My Userform Pop-up At The Begining

260: add-ins & security

261: VLOOKUP From Another Worksheet???

262: Screen updating

263: Problem with a selection in a matrix-function

264: Use of New Range Names in Macro

265: Lists in excel

266: Month End Projection formula?

267: autofilter question, quickie

268: copy temp sum in bottom right of excel to clipboard

269: Adding a scroll bar to a cell to scroll its contents.

270: Copy cell formating as part of a formula

271: buttons

272: Auto-Formatting in Excel: changing values

273: DOWNLOAD CRACKED 2008's SOFTWARE: ARCHICAD 11,UNIGRAPHICS NX5,SOLIDWORKS 2008,XSTEEL 13,AUTOCAD 2008

274: scanning data into excel

275: Power API

276: Error on macro

277: How to change closed file name - Error: file not found

278: Combine files

279: Counting instances of found text (Excel error? Or user error?)

280: mail merge

281: I am looking for a Business Valuation template?

282: auto filter problem

283: Format Cells - Hyperlink

284: CheckBox Checked Function

285: Is there a better formula than this Q

286: Hiding Parts of Excel

287: Formula to VB Code

288: How to set an alarm when there is a difference between cells?

289: VB Complie error - can You Help

290: IF Statement nightmare

291: programing reference worksheet

292: before print macro not printing multiple selected worksheets

293: Single formula to 'sort' a list onto a second sheet?

294: Excel - VBA (Freezing the Display During Maacro Execution)

295: Conditional formating

296: I need documents on VBA conversion from excel 97 to excel xp

297: Macro Help Needed

298: Declaring subs Public vs Private

299: Excel & Adobe hyperlinking problem

300: Help with Userform/Autofilter/VBA

2: Weekday formula calculating to end of month

3: Exporting numbers into Excel

4: Pasting filtered rows

5: Exceed Row Limit

6: workbook macros now run VERY slowly ... ideas please

7: badly struck! how to pass values from asp to excel

8: export excel macros

9: Macintosh and VB Scripts

10: Investment FV

11: file properties with cell data?

12: Automatically enter page breaks?

13: LOOKUP funciion giving an error

14: Macro Request: Fill in empty cells with previous Filled cell in column

15: Concat and summarize 6 columns to 2 columns

16: How can I combine the functions of a vlookup and sumif without a p

17: countif number of occurences per month per year.

18: Help: Making a copying macro from cursor position ?

19: Assign macro to button in EXCEL 2003

20: two problems with excel 2003

21: my excel printout not straight

22: How to: Assign pop up when command button is pushed

23: ?IF function for preventing a cell being filled by formula

24: Time Delay for Macros

25: Simple +formula not reading value from the reference cell

26: Adding and Reading a ListBox Item

27: how create library of routines?

28: RePost - Creating WBooks

29: Excel won't quit

30: read data from a cell absolutely

31: TIME math

32: Logical Functions

33: TypeLib Information Problem? Pass a Function's parameter names as string for parsing?

34: Summary of Different Workbooks

35: How to declare variable as public.

36: Two If's - one in a range

37: VLookUp Error Handling Needed

38: printing time literally

39: Calculated Fields in Pivot Tables

40: Locked cell without alert

41: YAPTQ - Yet Another Pivot Table Question

42: Redirecting a formula in an "IF THEN" statement

43: Formulas in Excel XP

44: I need an excel sheet to creating a new folder every month, and save a new spreadsheet every day, untill the next month, when it creates a new folder

45: Macro not found in Application.Run

46: Create copy of sheet using VB with columns in different order

47: Is there a way to remove a menue option (other than macro code)?

48: Hide Empty Rows When Printing

49: Right mouse click doesn't work

50: Tough problem with rotas

51: Return next non-Blank Cell in a Column ?

52: Excel 2000 VBA Form Combobox value

53: changing active cell

54: Customizing Toolbar

55: Windows Forms 2.0

56: Adding Range Names

57: .onaction, passing arguments

58: $ format in cell

59: Adding "0" as leading digits into cells in Excel

60: Charts

61: Chart source data when copying from one workbook to another

62: Excel Bug Moves Cmd Buttons When Print

63: Entering Seconds but displaying minutes & seconds

64: Sum up identical workbooks

65: Moving data from column A to Columns B,C,D,E

66: A questions of versions

67: Excel Droping The Last Number

68: Loop through Column and add hyperlink

69: Cell check

70: Document Recovery

71: Converting Text Dates to Serial Numbers

72: Excel 2003 User name

73: Preserving hyperlinks in linked cells

74: can you create a macro to compare two different doc side by side

75: Excel add-in set title?

76: Auto Formatting on Open

77: Check if a worksheet exists

78: Create a Button that will print sheets

79: Office 2003 Detect & Repair

80: Name of the defualt shortcut commandbar.

81: SUMIF only it has 3 ceretain texts in the same row

82: text box size problem

83: ODBC error linking to Sybase database

84: Needing help with Vlookup or if there's a simplier way of doing it

85: vb scripting -- copying web page, paste as text

86: How do I read data from an OPC server into an Excel worksheet?

87: Enable Live Preview -Excel 2007

88: Error querying for open VBprojects in XP?

89: Linking and/or macros

90: Date Criteria in Excel Macro

91: Automating XL charts from VB.NET 2003

92: Freeze titles (Figer les volets)

93: drop down list

94: Combo Box easy question?

95: VBA WinInet Code Crashes Excel

96: Reference the active sheet

97: sheet name

98: Can autofilter sum and average columns of numbers? Thank you

99: SeriesCollection object in Excel 2007 and 2003

100: Multipage: [Me.Controls("Page" & i).Name] does not work

101: MOUS - Pivot Tables..I'm never going to get it

102: Debug.Print in a WITH procedure?

103: Command for recalculating macros

104: Match and extract

105: SUMPRODUCT Question

106: i need help

107: Calculating Dates and Hours

108: updating email addresses in cells

109: FollowHyperlink ExtraInfo string max length?

110: Template Question

111: Progress bar/meter for duration of code - No loop

112: Learning resource for VBA

113: run macro after print command.

114: create a ASCII semi-colon or comma delimited file

115: Column Widths

116: getting wrong results with my VLOOKUP usage

117: How do I auto change text colour in excel to reflect the value ent

118: Count Function in Date Field

119: VBA AVERAGE formula, ignoring zeros

120: Break one line item into many...

121: How to trim a string to the last "."

122: Problem With Opening Embedded Object After Turning On "Track Chang

123: I want to limit the result of a calculation to a maximum number...

124: VB

125: How do I rename files that are related.

126: Can I make a cell change colour automatically

127: Lookup in an array

128: Conditional formatting and formula

129: Formatting

130: Macro and user created button Question?

131: Excel Runtime Available?

132: Automatic generation of Trouble Tickets

133: disable X button in main window

134: Control Combo Box Macros

135: Excel question, will pay for answer, calculating commission schedu

136: Formal to compare a list

137: Implimenting a shift in a power trendline graph

138: Change "Company" field in File Properties

139: variable paste or fill range

140: Excel NewWorkbook event

141: merging excel program with tdc finance program

142: excel formula

143: MapPoint Colors

144: Excel Pivot tables connecting to sql

145: Importing Data Into Excel

146: Bullet Points in Excel

147: Popup message when clicking on a cell

148: How do I insert spaces between characters

149: odd vlookup solution required - can you rise to the challenge?!

150: Refresh Pivot Table from other worksheet cell entry

151: Adding New Member Variables to Cells and Worksheets

152: NETWORKDAYS FORMULA

153: Naming Current Region

154: screen flicking

155: Resizing a Picture

156: Cells: Any way to code an event behind one?

157: Turn off automatic date formatting

158: ODBC driver does not support the requested properties

159: Dynamic dropdown?

160: VB for importing data into excel in proper columns

161: Can I lock the selection in the pivot table?

162: Visual Basic Macro(VBA) for a password protected file?

163: Eliminating a split

164: Match a text

165: replace Hyperlink with URL

166: Summing while hiding?!

167: New from Template Issue

168: Combo box list depends on value

169: Print to File Technique

170: User defined function: Address where UDF is used

171: Quick hiding of rows in WS_Activate ()

172: Enable/Disable SAVE AS button from code

173: Can I use serial comm port in Excel VB script?

174: Sudoku puzzle template

175: Is it possible?

176: vlookup combo box

177: 2007 Excel Skipping Columns on printout preview and printing.

178: is sheet protected?

179: opening a file

180: Checking access to Sharepoint prior to use

181: How to feed a userform a variable to display in a textbox?

182: counta in array formula not working

183: Can anyone please help with this - 3rd post

184: repost: Need Help With Steaming Data Macro

185: Commandbar

186: Counting Positions

187: Comparing values in two columns and displaying missing values in n

188: Check Box/Tick Box

189: how to copy same percentage to complete worksheet

190: Help With Very Simple Code

191: Simple Equation Builder/Solver in Excel for use in Dell Axim X51v

192: Help with quiting a workbook

193: 'conditional format' cells for the highest number in a range

194: Running a query and/or 3D Referencing

195: VLookup & Column Sum

196: Project is unviewable

197: Plesae help: Excel function

198: Find value and adress

199: Copy pasted name range

200: Exporting Excel Data As Unformatted Text

201: Execute a batch file from inside Excel

202: I am stupid and don't know what the heck I am doing wrong on this pivot table

203: Client Access to iSeries Automation

204: Conditional Row Deleting

205: Drop down list options dependent on cell value

206: delete non adjacent columns when blank

207: How do i copy rows to columns on separate sheet, and have them upd

208: no focus when spreadsheets opens

209: probably simple, but not for me, help please

210: Comparing data based on two columns

211: Hidden Character

212: Event Change Question

213: Calculation Question

214: Is it possible...lookup macro

215: Grabbing Data From Second Combo Box Column

216: Setting up a rule to reply to specific people

217: Can we get the size of a sheet ?

218: Dates formula problem

219: Update XLS File from XLT File

220: Workbook level recalculation

221: how do i put color in a cell based on data in a second cell

222: blank cells

223: Function for splitting a name to two cells from 1 input

224: Q re: TextToColumns

225: Try this critical pack from MS

226: exluding missing data values from equation

227: a summation problem

228: Êóïëþ Windows,Office,Server

229: greater than but less than operators for VBA

230: VBA PC-Mac Compatibility

231: Help on subscript out of range error (VB6/VBA)

232: How do I substitute text for numbers

233: Find and replace consecutive numbers

234: On load

235: Delete Insert Worksheet on Open/Reset on Close

236: VB Editor in Excel

237: range.comment.Text(...)

238: Concatenating a cell address

239: Values in spreadsheets do not update

240: Format a whole section if cell=0

241: Context Menu, Paste Special From Selected Range

242: Create several sheets

243: COUNTIF Function

244: Secure excel spreadsheet

245: Installing Office 2000 Standard new PC w/Windows XP Home Edition

246: Protecting a field

247: Excel not searching right

248: Q: search string

249: Points Ranking Formulas

250: Reply to Tom Ogilvy

251: Create worksheets and populate

252: Is the active worksheet protected?

253: cell help

254: characters...

255: displaying pictures

256: zip code

257: how to disable chart tab in Excel?

258: Check box formulas

259: How Do I Make My Userform Pop-up At The Begining

260: add-ins & security

261: VLOOKUP From Another Worksheet???

262: Screen updating

263: Problem with a selection in a matrix-function

264: Use of New Range Names in Macro

265: Lists in excel

266: Month End Projection formula?

267: autofilter question, quickie

268: copy temp sum in bottom right of excel to clipboard

269: Adding a scroll bar to a cell to scroll its contents.

270: Copy cell formating as part of a formula

271: buttons

272: Auto-Formatting in Excel: changing values

273: DOWNLOAD CRACKED 2008's SOFTWARE: ARCHICAD 11,UNIGRAPHICS NX5,SOLIDWORKS 2008,XSTEEL 13,AUTOCAD 2008

274: scanning data into excel

275: Power API

276: Error on macro

277: How to change closed file name - Error: file not found

278: Combine files

279: Counting instances of found text (Excel error? Or user error?)

280: mail merge

281: I am looking for a Business Valuation template?

282: auto filter problem

283: Format Cells - Hyperlink

284: CheckBox Checked Function

285: Is there a better formula than this Q

286: Hiding Parts of Excel

287: Formula to VB Code

288: How to set an alarm when there is a difference between cells?

289: VB Complie error - can You Help

290: IF Statement nightmare

291: programing reference worksheet

292: before print macro not printing multiple selected worksheets

293: Single formula to 'sort' a list onto a second sheet?

294: Excel - VBA (Freezing the Display During Maacro Execution)

295: Conditional formating

296: I need documents on VBA conversion from excel 97 to excel xp

297: Macro Help Needed

298: Declaring subs Public vs Private

299: Excel & Adobe hyperlinking problem

300: Help with Userform/Autofilter/VBA