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

  1. Solved: Tree View Control in a UserForm
  2. Solved: Format Cell
  3. Solved: workbook vs worksheet
  4. Know when all user have closed the workbook
  5. Solved: VBA: Search, Summarise and Total
  6. Solved: Org Chart
  7. xldialogprintersetup Problem
  8. Solved: Convert formula to VBA
  9. Inserting Rows and keeping the same formats and continuing the formulas.
  10. Solved: treeView
  11. Solved: VBA editor syntax problem
  12. Solved: Again on treeView
  13. Solved: Button Height
  14. Advanced Filter/CopyTo
  15. Solved: comndbutton code
  16. Solved: Find Method
  17. Solved: Emailing workbook with message
  18. VBA Mouse Pointer Styles
  19. Solved: ??? Why ???
  20. Solved: MultiPage
  21. Solved: Regional Settings
  22. Solved: Auto fill shift in calendar
  23. Solved: Please Help: Formula not VBA
  24. Solved: Macro: Find word and bold
  25. Line Chart Help Needed
  26. Disable double in combobox
  27. Solved: Accessing Word by Excel VBA
  28. Solved: Comments Off
  29. Customize standard XL-icon on worksheet and workbook
  30. Solved: Get Initials...
  31. [h]:mm conversion
  32. Auto Group Imported Access Data
  33. Solved: Error Handling
  34. Solved: Help needed with to input formula with vba
  35. Solved: Annoying VBA
  36. Solved: Multisheet Search and Paste
  37. Solved: Call a Macro with 40 different CommandButtons
  38. Solved: Incrementing Excel Sheet Links
  39. Display Current Month Data
  40. Solved: Array
  41. Solved: Creating PowerPoint
  42. Solved: Date conversion from Linux format
  43. Solved: Weeknum() function
  44. SumIf Cells From Closed Workbook
  45. Insert worksheet into one or many workbooks
  46. Solved: handle to userform
  47. Solved: Conditional Format question
  48. Finding a cell then copying data 2 cells right
  49. VBA: Adding Character every 3rd character
  50. Formula Help
  51. Solved: finding non-zero values and populating into different tab
  52. Solved: Toolbar button to start a macro
  53. Solved: Message Box if TB Contains Certian Characters
  54. Count and print colored cells
  55. Solved: Hiding a row
  56. Solved: xlveryhidden
  57. Solved: Counting problem
  58. Solved: setting page breaks in a print macro
  59. Solved: New to this Board....looking for some macro help
  60. Solved: macro to create a directory
  61. File Sharing a VBA standalone app doesn't work...
  62. Printing & Emailing a Worksheet
  63. Place data of logfile in a sheet
  64. Solved: Adding another cell
  65. VBA Help.....where to start?
  66. New Release of VBA 6.40
  67. Solved: Working with a range of dates.
  68. Dynamic PowerPoint Creating by Excel
  69. Solved: Updating Project From Web-Site
  70. Solved: Populating List box with data from other excel file
  71. Changing ActiveCell in an autofilter VBA
  72. something is missing HELP PLEASE!
  73. Solved: Optimize Production
  74. Solved: Sorting Problem
  75. Solved: GetOpenFilename with default directory
  76. Solved: Randomly select from a range
  77. Solved: VBA - Insert Macro
  78. Solved: CommandButton
  79. Solver Question
  80. Solved: Worksheet tabs
  81. Indicators
  82. Copying data to different worksheet
  83. Dialogs(xlDialogSaveAs)- strange behaviour when setting default directory
  84. Solved: Optimizing VBA
  85. "Single Step" window
  86. Sum Range
  87. Date format during .csv import
  88. Solved: listbox navigation
  89. Solved: This one may get you thinking!!!!
  90. Solved: Populating the TreeView
  91. This one should get u thinking (Not quite solved)!!!!
  92. Bug on Excel Footer???
  93. Solved: Static Date Stamp
  94. create a directory then save the workbook into it
  95. Solved: search sheet and list results in a doc
  96. Solved: Why doesn't Dr Watson like my code? (NT, XL97)
  97. Solved: Disable print
  98. Solved: Browse open workbooks
  99. Solved: listbox problem
  100. Solved: goto record using listbox
  101. Solved: I've lost my macro recorder toolbar
  102. Solved: Custom List Being Ignored
  103. Solved: code not showing form
  104. Solved: "Read Only" workbook
  105. Solved: Name a worksheet after a cell
  106. Solved: Moving and storing values between two listboxes and excel sheet
  107. Solved: Resizing Excel Application
  108. Solved: multi listbox
  109. Solved: changing orientation of word doc from excel
  110. Solved: Expand TreeView and select a node by parameter
  111. Solved: Select Case
  112. Solved: "Save As" prompt
  113. Look up values of Excel in Access table
  114. Solved: Progress Bar
  115. Repair Feature?
  116. Solved: Hidding Command Bars
  117. Showing specific range when the specific value chosen
  118. Solved: Scroll Bars
  119. Updating and copying?
  120. Solved: Code review?
  121. Solved: Creating two buttons and code programmatically
  122. Using a &%$#%$ RefEdit box to work with a multi sheet range - solution or overkill?
  123. Multiple Sheets
  124. Solved: regexp question
  125. Solved: Setting a range of cells
  126. Solved: Active Sheet Save As???
  127. Solved: Handle with activating of nonexisting sheet
  128. Solved: Comparing cells from different files
  129. Solved: date based on # days from starting date
  130. Solved: Selected row--->other workbook?
  131. Solved: Not clearing contents in hidden cells
  132. Solved: Formula to extract info or VBA code
  133. Solved: Command Bars With Custom Face IDs
  134. Solved: CLOSE Event, random not closing
  135. Solved: Switching views when cell is changed
  136. Conditional hiding of rows
  137. Cell Reference Problem in vertical layout
  138. Solved: Copy columns to rows????
  139. Solved: drawing lines
  140. Solved: CountIf
  141. Solved: How to Code to accomplish this in Excel Chart?
  142. Solved: adding a picture
  143. Solved: UserForm disables keyboard - ???
  144. Solved: show full file path
  145. Solved: Calculation Problem
  146. Solved: Unhiding spreadhseets upon meeting a condition
  147. A simple question
  148. Solved: When is a Global Variable not Global?
  149. Solved: Import Files With Too Many Rows
  150. Solved: Password protection with exceptions
  151. Solved: Move a copy of worksheets
  152. Using a Macro to get fund data
  153. Solved: Command button moves after print preview?
  154. Solved: How do I open variable file in Excel?
  155. Solved: Download from web site
  156. Solved: untidy Worksheet_SelectionChange code
  157. Solved: Macro to transfer values
  158. Solved: VBA: text to formula conversion/calculation
  159. Solved: array not working
  160. Solved: randomize
  161. Macro to Change Properties in all Files in a Folder
  162. Solved: remove link to another spreadsheet
  163. Validation drop-down arrows not on active cell!
  164. data sort automatic??
  165. Solved: combobox populate
  166. Solved: ComboBox
  167. Solved: How to insert a Reference in a sheet
  168. Solved: Locking Drawing objects on screen
  169. Solved: Password protection with exceptions
  170. Solved: Copy Worksheets and Formulae
  171. Opening another version of Excel
  172. Print Macro Not Working
  173. Solved: Disable Macros
  174. Solved: Specify Export Path
  175. Solved: password before running macro
  176. Solved: Worksheet Protection with exceptions
  177. Solved: Save as new filename function
  178. Solved: zoom to used range
  179. Print Macro
  180. Solved: dates
  181. Solved: Problem after upgrade from Excel 97 to Excel 2000
  182. Solved: Strange Occcurance
  183. Excel Read Only Problem
  184. Solved: Count conditional formats
  185. Solved: Problem with code. Please help.
  186. Tab sequence works if enter data, but if I dont...
  187. Solved: Assigning a Macro to a Toolbar Button
  188. Outside of Excel ss
  189. Freezing Sheet Tabs - xl97
  190. Solved: Conditional formatting
  191. Solved: Error alert if a certain limit is exceeded
  192. Solved: Formatting multiple occurences of words.
  193. Solved: for the gurus of EXCEL I think......
  194. Solved: Remove the password protection on a file
  195. Solved: Macros take longer than usual
  196. Print UserForm with a Webbrower Control
  197. Using a link
  198. Solved: Subtotaling a report
  199. Solved: Conditional Formatting with VB
  200. Help refreshing data
  201. Making the next cell active
  202. Solved: Sum Except Last Register
  203. Solved: help with a loop error
  204. Solved: Ordering against a forecast according to lead-time
  205. Solved: VBA: Converting Worksheet_change sub into Addin
  206. need help with code to controll itemsvisibility in datafield/pivottable
  207. Solved: Help with Procedure to View Web Page
  208. Solved: Type Mismatch in Excel 2003
  209. Solved: Changing Font Color
  210. Solved: Save As?
  211. Solved: replace save with save as
  212. Solved: Custom toolbar problem
  213. Solved: Search PDF files
  214. Solved: Hiding rows depending on data in first cell
  215. Solved: strange format problem !!!
  216. Solved: evergoing calendar
  217. Solved: Average and plot help - NEWBIE
  218. Solved: Option Button "Linked Cell" Property
  219. Solved: problem with a do loop
  220. Solved: Linking filters
  221. Solved: strange sort problem
  222. Solved: copy if date => now() <= Now() + 7 ?
  223. Solved: Printing chart objects
  224. Testers wanted
  225. Staffing Roster Automation
  226. Solved: Insert Scroll bar from code
  227. Solved: problem with an if code
  228. Solved: Tab order Problem "for the Brave" Protected sheet!!
  229. Solved: Converting large decimals to hex
  230. Help with a combobox!
  231. Solved: Timed Sub
  232. Excel to word
  233. Solved: Improving Code to Convert HTML to Text
  234. Solved: Where to Store Auto_Open Macros?
  235. Solved: Creating new folder & saving copy as:
  236. Solved: how do I move a date exactly one month forward
  237. Solved: Problem with a increment
  238. Solved: Cannot Launch Data Form with Macro
  239. Solved: Remove Cancel button - Input boxes
  240. Solved: Improve Nested IF Formula
  241. Show userform, save > ...Illegal operation ?
  242. Solved: Problems with Save As
  243. Solved: Integer, Byte or Long for Columns?
  244. VSTO
  245. Help With Userform Search Box
  246. Solved: Show Value When Range is Not Empty
  247. Solved: Help! Problem with Web Service
  248. Solved: cap sensitive search
  249. VBA: Macro to copy data from a text file and place data in Excel
  250. Solved: Simple question