PDA

View Full Version : Excel Help



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 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174

  1. [SOLVED:] Linked Spreadsheet
  2. Sleeper: Adding a character to a defined name???
  3. Sleeper: FEM Solution using Excel/VBA
  4. Sleeper: Load Folder Content in Single Column List Box
  5. [SOLVED:] Excel - how can I fill a column with determinated values?
  6. [SOLVED:] Putting data where you want it!!
  7. Sleeper: Populating Ranges
  8. [SOLVED:] highlighting the last row
  9. Sleeper: Machine configuration for Excel VBA
  10. Hyperlinking to an Adobe PDF file?
  11. Sleeper: Aggregated charts
  12. [SOLVED:] Copy from one location and split to two locations
  13. Sleeper: Macro Code for Save but no Dialog Boxes
  14. Sleeper: Export to text files
  15. Sleeper: Summing based on numberformat
  16. [SOLVED:] Effect of "Else:"
  17. Sleeper: Concetenate with bold letter for one line
  18. Sleeper: Change text to upper case after specified symbols
  19. [SOLVED:] Distinguishing Between FALSE and 0
  20. [SOLVED:] increasing strings or adding strings
  21. [SOLVED:] Summing based on data range
  22. [SOLVED:] Fill ascending numbers
  23. Sleeper: Using VBA to count documents within a folder
  24. Sleeper: Cell reference for Duplicates
  25. Sleeper: Customize KB Code to Delete Rows
  26. Sleeper: Return a value if the selction is blank
  27. [SOLVED:] Freeze Pane
  28. Sleeper: Summing & average by numberformat
  29. [SOLVED:] Advanced Filter with duplicate deletions
  30. Sleeper: UserForms help
  31. [SOLVED:] Something better than IF(OR
  32. [SOLVED:] Remove module from closed workbook
  33. [SOLVED:] Pasting Links
  34. [SOLVED:] Proper case question
  35. [SOLVED:] Naming a Workbook from a cell
  36. [SOLVED:] Sheeting Permissions
  37. [SOLVED:] Security Level Macros - Protecting Workbook
  38. [SOLVED:] Help with If...Then
  39. Export Sheet to new Workbook
  40. Sleeper: How to allow multiple users to update workbook (on network)?
  41. [SOLVED:] Excel 97 Only Test Machine
  42. [SOLVED:] Custom Menus
  43. [SOLVED:] Code Wont' Run in 97
  44. Sleeper: How to remove a dir which already contains a dir
  45. Sleeper: Run-time error '2147417848 (80010108)'
  46. Sleeper:Running Macros from an FTP Server
  47. [SOLVED:] Cell Reference, No VBA Required
  48. [SOLVED:] Go To Previous Worksheet / Go To Next Worksheet
  49. Sleeper: Extend Cell Column Width
  50. [SOLVED:] Dynamic Series problem in Dynamic Chart
  51. [SOLVED:] Application.GetOpenFilename Dialog Box
  52. [SOLVED:] Autofilter Vs Colorindex
  53. Sleeper: Used Column Value
  54. [SOLVED:] Get selected range address w/o column name
  55. [SOLVED:] retrieving cell information from multiple files
  56. [SOLVED:] Right Click TextBox Menu
  57. [SOLVED:] Speeding up macro code
  58. [SOLVED:] Password in Macro
  59. [SOLVED:] URGENT HELP REQ. (RUN-TIME ERROR)
  60. Sleeper: Internet Explorer viewing pane in a VBA Form
  61. [SOLVED:] Macro to Delete Blank Sheets
  62. [SOLVED:] Seprate data with space after every 3 chars
  63. Sleeper: Problem downloading data from Web
  64. Sleeper: Have any of you experienced this problem with excel?
  65. [SOLVED:] Shut off Microsoft Warning
  66. [SOLVED:] File List with User customisations?
  67. [SOLVED:] Can I Hypelink to a specific worksheet in another workbook?
  68. [SOLVED:] Convert % value to text using IF
  69. [SOLVED:] Error 1004 if we don't want to save
  70. [SOLVED:] Resize Comment
  71. [SOLVED:] Vlookup macro not compiling?
  72. Sleeper: Hightlight each different number
  73. [SOLVED:] Check List, Add New Item
  74. [SOLVED:] Inserting Time in a cell
  75. [SOLVED:] Macro Help
  76. Sleeper: Pasting Links Part 2
  77. [SOLVED:] Prevent msg box when deleting a sheet
  78. Sleeper: A sheet tab
  79. [SOLVED:] MsbBox with vbYesNo determines whether sub should proceed
  80. [SOLVED:] Need help enlarging a range of cells..
  81. Sleeper: Help with Status Bar
  82. Sleeper: Running a VB Function From Excel
  83. Sleeper: Problem with Before_Close code
  84. [SOLVED:] Sorting for Unique records using VBA
  85. Solved: IP Address
  86. Sleeper: Open closed excel file
  87. [SOLVED:] Error msg: File is already opened
  88. [SOLVED:] Flexible copy-to range
  89. [SOLVED:] Select entire row excep cells in merged area
  90. [SOLVED:] Query on selection.column
  91. [SOLVED:] Delete all txt files within a Folder
  92. Sleeper: Copy vba macros
  93. [SOLVED:] Counting Used Cells in a Range
  94. Sleeper: Switch Form
  95. [SOLVED:] Number format
  96. [SOLVED:] UserForm Image
  97. Sleeper: Country settings changed via vba
  98. [SOLVED:] Autoshape Automation
  99. [SOLVED:] Formatting help
  100. [SOLVED:] Excel VBA to change properties of non-Excel file
  101. Sleeper: Trouble with Refreshing Pivot Table w/ Remote Data
  102. [SOLVED:] A Matching Problem
  103. Sleeper: Dodge-ball Team Sorting System
  104. [SOLVED:] Overflow Problem
  105. Sleeper: Excel to CSV bug
  106. [SOLVED:] VBA SaveAs xlTextMSDos creates (sometimes) quote marks
  107. Sleeper: Moving upward
  108. Sleeper: Autofilter Problem
  109. Solved: Delete The File Itself
  110. [SOLVED:] Cell looses format after number from User Form is placed in it.
  111. [SLEEPER:] Need help with Macro's and Userforms. :)
  112. Sleeper: Find in UDF
  113. [SOLVED:] Run Marco by click on a cell
  114. Sleeper: Compare and Calculate the Sum
  115. Open Lotus 123 Files and save as Excel
  116. [SOLVED:] Excel Properties
  117. [SOLVED:] how to startup excel with a form
  118. [SOLVED:] ISBLANK problem
  119. [SOLVED:] Sleeper: Using combo box in excel
  120. Sleeper: Transferring date and text data to an excel file
  121. Sleeper: Lock the screen
  122. [SOLVED:] Error after running code
  123. Sleeper: Automatically set merged cell height
  124. Sleeper: Date/Time picker control
  125. [SOLVED:] Go back to cell
  126. [SOLVED:] Find
  127. [SOLVED:] Unprotect and protect after macro run
  128. [SOLVED:] Advice on adding a row
  129. [SOLVED:] Adding comments
  130. [SOLVED:] Hyperlink query
  131. [SOLVED:] Compile error message
  132. Sleeper: How to Package Addin File for Excel
  133. [SOLVED:] Customising Right Click
  134. Sleeper: @ mdmackillop..need further help on previous request.
  135. Sleeper: Windows Registry
  136. [SOLVED:] Referencing cell through constant problem
  137. [SOLVED:] Macro wont run except...
  138. [SOLVED:] Macro to check dates and notify user
  139. [SOLVED:] Excel Conditional Formatting with a formula
  140. [SOLVED:] Text box to return cell value from other sheet
  141. [SOLVED:] Code to Sort, Replace and Count results
  142. Sleeper: Text problem
  143. [SOLVED:] Sharing variables between forms and modules
  144. [SOLVED:] Text Case Conversion Procedure "Proper Case" for Excel
  145. Sleeper: Ctr + Z after running macro
  146. Sleeper: Open Excel Workbook as read Only
  147. Sleeper: Open files in a folder one at a time
  148. [SOLVED:] Amortization calculator
  149. Solved: MISSING: Microsoft ActiveX Data Objects Record 2.8 Library
  150. [SOLVED:] Strange Errors/Breaks
  151. Sleeper: VBA Code error for If then else.
  152. [SOLVED:] Replace Formats
  153. Sleeper: Updating data in a spreadsheet with User Form?
  154. Sleeper: Select uneven columns
  155. [SOLVED:] Format a value
  156. [SOLVED:] Usage Of Array function
  157. [SOLVED:] Range with a variable
  158. [SOLVED:] Hide & protect sheet
  159. [SOLVED:] Input Box
  160. [SOLVED:] Difference between Auto Open and Workbook Open
  161. [SOLVED:] Pasting formulas into a dynamic range
  162. Sleeper: Validate a Date!??
  163. [SOLVED:] Macro to print multiple non-adjacent area in a worksheet.
  164. [SOLVED:] Help with date macro
  165. Advice: Google Desktop not compatible with Excel
  166. [SOLVED:] Segregation of Numerical & Text data
  167. Sleeper: How to activate an open workbook
  168. [SOLVED:] Counting and summing occurrence
  169. [SOLVED:] Check Windows version
  170. [SOLVED:] Formula Array in VBA
  171. [SOLVED:] If statement
  172. [SOLVED:] Divide texts into column
  173. Sleeper: Function for BOLD format
  174. [SOLVED:] Value from another workbook
  175. Sleeper: Cell Annotation - Formula to viewable updating text
  176. Sleeper: Merge styles
  177. [SOLVED:] Addling to a multi column listbox with VBA
  178. Sleeper: Numberformat, in^3 vs in?
  179. [SOLVED:] Date set to kill a ws
  180. Sleeper: Help to select date range w/ count
  181. Sleeper: Problem setting the Print Area
  182. [SOLVED:] Copy from one sheet to another?
  183. [SOLVED:] Does a path exist?
  184. Sleeper: Dodge-Ball-Team Sorting System
  185. Sleeper: Select range
  186. Sleeper: Selecting visible cells.
  187. Sleeper: Change interior color based on a check box
  188. [SOLVED:] Making "Things" on Charts Move With Charts
  189. [SOLVED:] Search and delete record, using macros
  190. [SOLVED:] Move focus to CommandButton
  191. [SOLVED:] Can VBA codes call a bat file?
  192. [SOLVED:] How associate a number to a day of the Week
  193. [SOLVED:] Sheet names
  194. Sleeper: Message Box Help
  195. [SOLVED:] Fill a list box with unique items
  196. [SOLVED:] How to make the range only as long as needs to be ...
  197. Sleeper: Delete a macro
  198. [SOLVED:] Import data from a web page to Excel
  199. Sleeper: Disable CellDragAndDrop for FillRight AND FillLeft
  200. [SOLVED:] How to use VBA to write a bat file and execute it?
  201. Sleeper: Excel and Microsoft Office Document Image Writer
  202. Solved: Excessive Windows in VBE
  203. [SOLVED:] Create desktop shortcut
  204. [SOLVED:] Copy, Paste and Transpose
  205. [SOLVED:] Toggle optionbutton (from forms)
  206. [SOLVED:] Counting blank cells with formulas in them
  207. Message Box trouble
  208. [SOLVED:] Naming AutoShapes - Bad Idea??
  209. [SOLVED:] Excel.exe has generated errors?????
  210. Sleeper: Encrypting VBA Code - Third party tools?
  211. Sleeper: Macro for Segregation of Text & Numer from range
  212. Sleeper: Unhide worksheet based on cell value
  213. [SOLVED:] Is there a way after macro runs to email.............
  214. [SOLVED:] User defined name (not linked to cell)
  215. [SOLVED:] Help with syntax to Run code in one XLS from another XLS
  216. [SOLVED:] How do I declare a module wide date that is in the form of say (3rd wednesday of the
  217. Sleeper: Toggle between two worksheets
  218. [SOLVED:] Return values from formula range
  219. [SOLVED:] Fade a splash screen
  220. [SOLVED:] Separate and Hyperlink to proper position of data
  221. [SOLVED:] Macros to Protect/Unprotect Worksheets and Workbooks
  222. Sleeper: Macro to email file through Lotus Notes (Solved)
  223. Sleeper: Macro to Open workbook and Update Links Automatically (Solved)
  224. prime numbers
  225. [SOLVED:] Action on every sheet
  226. Sleeper: Copy cell down
  227. Sleeper: Allow users to edit range - problem
  228. [SOLVED:] Make Code work on 3 columns instead of just one.
  229. [SOLVED:] Convert Array Formula to VBA
  230. [SOLVED:] Making an ActiveX control button inactive?
  231. [SOLVED:] Disable Macros
  232. [SOLVED:] Enter Key activates Command Button
  233. [SOLVED:] Copy worksheets
  234. [SOLVED:] Code Help
  235. Sleeper: Export table to Word
  236. [SOLVED:] Running a macro in another workbook
  237. Sleeper: If statements and Chart Series
  238. [SOLVED:] Multi-line range name assignments?
  239. [SOLVED:] Counting Blank Cells
  240. [SOLVED:] Problem with Range Box
  241. Sleeper: Doing Time.....
  242. Dependant Combo Boxes
  243. [SOLVED:] Data persistence without using sheet or external file
  244. comparing spreadsheet
  245. Sleeper: How to make weighted average in pivot tables
  246. [SOLVED:] Get value and color of cells with Access
  247. Sleeper: File Size warning
  248. [SLEEPER:] Working on a range
  249. [SOLVED:] Show or hide images, according to the value of a cell
  250. [SOLVED:] Macro's that open files with passwords