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. Execution of macro when contents of cell changed?
  2. Abandon Auto_Close
  3. saving a document
  4. Make Excel open not IE
  5. Should be Simple Variable in Formula
  6. Adding a msgbox to a cell in excel
  7. Question about References for VB in Macro?
  8. Help! Can't enter data in Excel when UserForm showing
  9. How to code a range for multisheet workbook
  10. using text to check a check box
  11. Pastespecial Driving me up the wall
  12. Objects... Objects...
  13. running a macro when a cell value changes
  14. Enable button if....
  15. IE Dialogue Box Help
  16. Copying one sheet to another
  17. Creating a pivot table from a dynamic Range
  18. Killing a Macro
  19. Pop-up Menus
  20. Delete Toolbar Error
  21. VBA and Solver
  22. passing collection between sub and functions
  23. Question on Excel Interface with COM DLL
  24. strange looping
  25. Find & Replace plus format the range
  26. Data transfer from a List box to Excel
  27. how to approach my new project
  28. Clearcontents multiiple ranges
  29. how and why would you use a union statement
  30. How do I select ONLY text?
  31. Listbox remove item problem
  32. about listbox autofiltering...
  33. Preventing UDF from Recalculating
  34. Help with a very easy function
  35. Whats the best process to solve my problem
  36. BEGINNERS QUESTION for Excel Macro
  37. Random function
  38. Macro starts fast and slows down
  39. Pop-up menu generating object error
  40. menubar question
  41. Event procedure
  42. Check selected value of listbox
  43. workbook.Saved won't set True
  44. Transposing An Array
  45. Bit Check
  46. find method problem
  47. Excel Application.workbooks.open("filename") doesn't return Excel workbook
  48. Log Graphs?
  49. NumberFormat issue with _)
  50. Pivot Table Grouping
  51. Reject or Accept Excel Data
  52. Copying Page without alerts - ERROR
  53. Excel Formatting
  54. about date value..
  55. Mass change hyperlinks?
  56. Toolbars - restore user's original settings
  57. Close Excel file without Workbook_BeforeClose?
  58. Excel Freezes on Pop-Menu
  59. What's wrong with my Excel?
  60. Excel-VBA Q: Mill's posting Excel 101: filtering data using multiple combobox
  61. Loading EXCEL Sheet's values in the VB form
  62. Using CountA
  63. Workbook.Close causes runtime error
  64. [:] cannot be accessed - Error 1006 on application.saveas - Any ideas?
  65. Hidden rows in protected worksheet
  66. Using an autofilter in a VB macro
  67. Form loading
  68. setting column width in Excel using VB
  69. hidden formulas and networking
  70. Application Window
  71. Adjust userform to screen resolution
  72. Application.quit
  73. I need help adding to an existing macro
  74. If Value = True, Delete Row
  75. Copy and paste loop
  76. Excel in VB
  77. Set WS1 = ("Sheet1") can I do this for workbooks?
  78. save function
  79. Adjusting Excel Cells
  80. Modeless Windows
  81. Restoring Excel File
  82. Newbie wants to learn...
  83. XL: Read and edit data in Userform with ADO
  84. Trouble closing Excel process
  85. capture text typed in Combo Box
  86. Msgbox
  87. Project Advice
  88. Very basic VB/Excel question
  89. ODBC update of MSQuery in Excel
  90. Confused by Countif function
  91. using shell command to open csv file in excel
  92. Can VB detect Screen Resolution, Zoom Excel accordingly ??
  93. copy veritcally and paste horizonally
  94. to let Excel knows my 'dumb' brain
  95. For . . . Next
  96. Date Controlled
  97. Excel combo box query
  98. Making Exam, Starting From Scratch
  99. VBA template function definition
  100. Conditionnal Compiling - Is it possible to make this work?
  101. copying multiple sheets with links
  102. Directory information / file information
  103. ListBox
  104. datediff
  105. why "displayAlerts" method failed?
  106. Subtotal TotalList=
  107. Combobox id's...is there a better way?
  108. Excel formula to detect particular text
  109. VB to open workbook with "n" sheets?
  110. Range Problem
  111. string Length
  112. Making available addins etc to other users
  113. Combining texts from 2 columns in sheet
  114. Pasting problem
  115. Graphing an Excel Sheet using VB
  116. About like operator..
  117. Set Variables
  118. VBA best method: make UserForm fill the screen
  119. Check three cells, combine them and copy
  120. Variable images on userform
  121. About protecting worksheets...
  122. Automation Error 80010108
  123. VBA ActiveWorkbook
  124. Current File Size of Workbook
  125. Looping in a VB Macro
  126. Help!
  127. detect if printer is installed
  128. Find within Do Loop
  129. Problem with versions ???
  130. A function to skip cells
  131. AddLine in VBA
  132. Application Inputbox Cancel Problem
  133. I'm done!!!!! Thank You All
  134. DateFormat After Create a New Excell File
  135. Retreive function result (value) from excel sheet in VB 6
  136. Controling Exel Chart Axis from VB app
  137. return to last selected worksheet
  138. Paste or Range Copy = #Ref!
  139. Counting the number of characters in a cell
  140. Workbook_AfterSave
  141. Delete rows in spreadsheet IF...
  142. Errors when program runs multiple times
  143. String / Date errors
  144. Strings inputs in a array
  145. Special Caracters - Range.Find
  146. Small problem... cannot save after automatic edit.
  147. Really stupid question
  148. Speed up worksheet comparison
  149. Open spreadsheet as readonly if not authorised
  150. Out of Shape & Mystified
  151. Speed problem..this is taking too long..
  152. Listbox -> clear cell
  153. VBA events
  154. Is it faster enough?
  155. Prevent WorkBook for being opened by diff. Excel Version
  156. Excel Glitch
  157. Viewing Macro code! Help!
  158. If isempty statement trouble
  159. Excel formulas
  160. inserting a function into a spreadsheet from VBA
  161. Drop Down List Trouble!
  162. Excel Lookup
  163. Simple Excel Help - I think
  164. Copy a specified Range (what am I missing?)
  165. sum by colour
  166. Seletion limitation
  167. Problem using optional aguments on sub
  168. How to let a user know who is using the workbook
  169. How control chart points from VB6
  170. Update Formulas
  171. Huge web query - takes up more than 256 cols
  172. Excel with VB
  173. Need to referance an older version of Excell
  174. Custom Defined functions within worksheets
  175. Can Two Macro execute at the same time?
  176. Need help with code - Next empty row
  177. Hiding Unused Sheets
  178. msgbox problems
  179. Conditional formatting on book shared
  180. Dealing with logic
  181. Using a variable for Excel workbook name
  182. Worksheets with random names, delete all except of a couple
  183. Find in Excel with a user-defined function
  184. App.Path not working
  185. Optional Parameters, IsMissing and Boolean
  186. Difficulty with onTime()
  187. Reduce PivotRange
  188. Number to Letter
  189. Date problem
  190. Parameters & Properties
  191. Help! VB to Excel without using a referance.
  192. Checkbox "greyed out"
  193. help: how do I 'translate' a vba command to vb?
  194. Force recalc after "#REF!"
  195. Saving Problem
  196. Finding more then one in a Doc
  197. Array problem
  198. Adding a Procedure to a sheet event w/ macro
  199. need some help with dates
  200. Excel object - count rows and cols
  201. Excel object - count rows and cols
  202. Abort button..?
  203. forms - list boxe
  204. Still cannot resolve date problem
  205. If statement or function?
  206. To draw boxes around cells
  207. excel lotus notes
  208. Perform operation on multiple sheets
  209. Excel database
  210. Convert CSV to XML...
  211. Identify Cell address of the last entry in range
  212. How to move to the next Excel sheet using Vb6
  213. programming a choice
  214. Equivalent of IsNumeric for text
  215. how to read data from excel sheet?...help urjent
  216. Hiding from Macro Menu a rotine
  217. Folder problem
  218. Insert Comments in a Cell
  219. drag cell value
  220. Array formulas to sum data.
  221. Macro works But!
  222. cell back color in excel
  223. Hiding rows if.....
  224. VS6 VB distributable program that uses Excel
  225. set image as background in word and excel
  226. Iterating through Comboboxes
  227. Lookup months in a range
  228. Limit on # of methods in VBA module
  229. Excel VBA
  230. Specify the selection
  231. Invert Selection
  232. get the row number using Autofilter?
  233. Chart plots blank cells as zero's
  234. Add Controls With Events at Runtime
  235. Append post-script print jobs?
  236. Limiting Users to Ceratin Data Types
  237. Detect the Excel File Name in Visual Basic
  238. Find
  239. Counting between two events
  240. Subscript 9 Error on some computers
  241. save copy as
  242. Excel Losing Reference Locations
  243. Excel versions - differences
  244. References for older versions
  245. Next i type thing
  246. Reading Excel and witing into Access
  247. Disable listbox
  248. Copy from excell sheet to grid in VB or read the clipboard and store it to array
  249. New Font objects
  250. Open Excel as Read Only