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