PDA

View Full Version : Excel


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 [20] 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61

  1. Send Workbook & message via Lotus Notes
  2. download web pages from list in spreadsheet
  3. How would I name my .xls file once it's opened
  4. multiple IF or OR Excel formula needed
  5. Run Time Error 430
  6. Paste Special the same formula?
  7. Excel, sorting column by textlength
  8. Only unique values or IDs?
  9. vb6 and excel
  10. disable Read Only notify
  11. excel data - counting text
  12. Lost worksheet menubar
  13. Find the last cell in a Col with a specific value
  14. Error 440
  15. string too short
  16. Pasting column widths?
  17. Make my code wait for excel to open
  18. Datavalidation and Duplicate items
  19. Pivot tables or VBA (or VB)
  20. Check existence of item in pivotitems?
  21. Frame Error
  22. update excel sheet
  23. context menu -> function with arguments
  24. Printing Problems
  25. Userform question
  26. Complex SUMIF
  27. Printing options
  28. Removing Fomatting
  29. Closing without save
  30. Save excel worksheet
  31. Worksheet in Excel dosn't change
  32. yet another last cell question
  33. recording macro's
  34. irritating file dialog
  35. Close workbook if haven't changed in certain time
  36. Shared Pivottable. Possible?
  37. excel 2 postscript continued...
  38. Find Method doesn't work from VB6
  39. parsing XML file to excel worksheet
  40. scan for folders
  41. Print All Except..one
  42. Optimisation help needed for data-sorting subroutine.
  43. Best way to determine if a range of cells is empty
  44. Module updating in Excel
  45. Closing and file killing, somethings conflicting here
  46. Excel ADODB - 'Installable ISAM?'
  47. selecting several cells
  48. printing in reverse order UP TO A SPECIFIC ROW
  49. printing OWC from vb form?
  50. Trying to Save to a full disk
  51. Counting Valid Excel Rows
  52. Excel will not Close with VB6
  53. Excel troubleshooting/loading
  54. accessing a variable with its name
  55. Combining some ranges
  56. check if filesavename is valid
  57. Boolean???
  58. problem with naming opened XML
  59. Listview Index Question
  60. Stop Excel From Scrolling
  61. Bypass "Do you want to Save Changes?"
  62. Graph code
  63. Row Sum
  64. Type Mismatch? Object Defined Errors? What's wrong here?
  65. Control Box
  66. How to prevent Excel from modifying named ranges?
  67. Application.Quit
  68. Open a workbook in a default sheet
  69. Formatting
  70. Autofilter with >=date, <=date criteria...?
  71. vb6 text alignment in excel cell
  72. Is there any way to "flatten" conditional formatting?
  73. help with vba rpta rotation
  74. User Forms in Excel
  75. Newbie questions
  76. Help! Calendar Control in Excel
  77. finding column number
  78. Formatting? Please help
  79. delete sheets except specified one
  80. Linking Colors
  81. LastRow count returns 1 or 0?
  82. right click in excel to execute query???
  83. Auto_Close....deleteing temp files
  84. Entering a time, then changing to General format.
  85. newb ? putting data from database into cells
  86. Help....please...
  87. VBA:Excel macro change date format
  88. Runtime Error 13 'Type Mismatch'
  89. Matrix style report from vertical data sheet
  90. Executing Excel Macro from a Web Page
  91. user defined functions
  92. Autofilter questions
  93. Reading different sheets name (Excel) in VB
  94. Excel Timer()
  95. Mouse over on clip art?
  96. Bizarre error when trying to open a spread sheet
  97. how do i get a macro to select a cell depending on another cells data
  98. Save as not working
  99. On working with multiple worksheets.
  100. Selecting a reference
  101. Copy/Paste in one cell
  102. Help Pls Trying to Do Too much
  103. copy specifc text out of cell and not the whole cell???
  104. Login ID
  105. Fullscreen Scroll Bars...
  106. Help on last row probs...
  107. restoring minimized excel window
  108. How to prevent links from being updated?
  109. Saving strings to different cells
  110. Add information from a file into Excel...
  111. selectionchange for pictures excel vba
  112. merge data from 2 workbooks
  113. Outlook loop for excel files
  114. using a macro to edit a combo box format range
  115. Incrementing by letters rather than numbers
  116. Annoying problem
  117. :=PasteColumnWidths undefined variable?
  118. Adding an object from a Class Collection to another Class Collection
  119. Appending a range to a print file
  120. convert macro into vb executable
  121. Newbie needs help
  122. Problem With Name Ranges
  123. excel file save
  124. Difference between Module and Class Module!?!
  125. Auto_Open alternate
  126. Populating a listbox with Filenames
  127. What type is LastRowInColumn? (code attached)
  128. Transfer data to workbook that isnt open?
  129. Consolidating data from Various Excel Workbooks
  130. Charting question
  131. Loop question
  132. Problem with function
  133. color excel row
  134. prob with setting the height after word wrap
  135. Is there a way to add a reference (library)?
  136. vb6 add-ins, timers and Excel 2000
  137. Copying and pasting from excel
  138. finding existing records in excel using VB
  139. i need a way to Do While Find
  140. PopUp
  141. seriously difficult value extraction!
  142. How can I detect when a cell changes?
  143. Help with Excel Hyperlinks In Email
  144. Problem in Excel
  145. check if shell window is active?
  146. Limits in user defined functions
  147. lost on Workbook_Open
  148. How do I present an open dialog displaying a network directory
  149. Format ID codes? -get.cell(ID#-
  150. Multiple Spreadsheets
  151. VBA calling other programs in Excel
  152. In Range?
  153. VBA unable run in Internet Explorer
  154. customising a FOR EACH statement
  155. Public declaration Vs Global declaration
  156. Charting Percentages in Excel
  157. List Box from Dynamic List
  158. About visual basic for the web
  159. Javascript commands in VBA???
  160. Number Formats
  161. Problem with Importing Data to Spreadsheet
  162. Excel Pivot capacity
  163. Some sort of search method needed
  164. passing ranges through functions
  165. Deleteing named ranges from a specific excel worksheet ?
  166. Disable save changes dialog box
  167. Simple Question
  168. Calling macro in Excel from Access with vba
  169. Checking Multiple files exist
  170. For i=1 To 5 indicating cells...
  171. Formatting Text in MsgBox
  172. copy a group of cells
  173. Easy Code!!!!!
  174. Excel - Design Mode
  175. Excel link - Subscript out of range
  176. Printing my code....
  177. Excel - Macros and VB
  178. Trust VB projet
  179. Excel DDE integration vs. cpu resources
  180. Function that gets out the numbers...
  181. Masked xla file
  182. Excel ignores my "On Error Goto" statement
  183. Export whole recordset using automation
  184. ActiveX ComboBox behavior
  185. Wait until there's an answer
  186. Help needed with Buttons and CommandBar
  187. VBA in Excel - Chart.Export Question
  188. Using Find Method
  189. help needed with formula
  190. Problem with CSV files
  191. Loops
  192. Rte 1004
  193. Excel Batch Renaming Mechanism
  194. How to deal with error conditions of SaveAs?
  195. Incrementing Dates
  196. I have a small problem.
  197. input string???
  198. Renaming Worksheets
  199. File Save As
  200. GoTo xx seaches whole module or just sub?
  201. Template/Save As/Copy Whole Sheet ?????
  202. Opening a Hyperlink With Parameters
  203. Trapping Events in Edit Mode
  204. Check for proper filename syntax.
  205. Hiding Columns/Rows in Excel
  206. using excel without excel object ?
  207. How to open word template?
  208. Setting Chart Title + a few other things
  209. assign values to list of named ranges
  210. Deleting Rows: Need Help
  211. Returning Filenames
  212. Close workbook
  213. Display On Load
  214. Deleting Columns
  215. Converting cells to variables
  216. Excel Sheets in Vb
  217. How do you call this Sub from another one
  218. Find total no. of rows with records
  219. Custom Collections in VBA vs VB6
  220. Select case statement
  221. Cell length
  222. Making Selected Values available to other worksheets
  223. Insert rows when cell contents change
  224. Overflow
  225. Need help with Payroll program
  226. Cell range user prompt and passage to formula
  227. Use relative paths
  228. directory
  229. pivot table and subtotals
  230. goal seek
  231. undo - macro
  232. Auto Import Code
  233. excel newbie needs help
  234. Problem with a macro?
  235. Help(Urgent)
  236. Changing Value
  237. Using RefEdit in a form to delete a range
  238. Functions, Formulas, and array dump (just wondering if it is possible)..
  239. ListCount/ListIndex
  240. Saving Cell location After using find in VB6
  241. search procedure
  242. Recreate a macro menu
  243. Problems with ShellExecute
  244. Find Cell, Change Color
  245. Multiple Code Needs!
  246. Select cells in the same column till the last one with data
  247. Standard Toolbars/Menubars on Userforms?
  248. Reading in Excel files
  249. calling procedures from different workbook
  250. Trouble with Excel