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: create a named range with a changing area
  2. Solved: want to remove #div/0 error by vbnull string
  3. [SOLVED:] Counting Cells Where Formula Does Not Return ""
  4. [SOLVED:] Column number conversion: hex to dec and dec to hex
  5. Solved: Print 2 pdf VBA error
  6. Solved: Autofilter using date
  7. linking ranges into dropdown and option boxes
  8. Solved: Search for first open cell in Row
  9. Solved: Different Passwords for all Users to view W/sheets 1 master password
  10. VBA for copying and pasting and insertion of rows
  11. Error Generation during copypaste macro run
  12. Solved: check file for xls and xlsx extensions
  13. Solved: Downloading Excel File from Website
  14. Solved: index/match with more than one match
  15. Solved: Creating a drop down list with source from another sheet
  16. Solved: Delete workbook on date....
  17. Solved: Alphanumeric Sort
  18. Solved: Using is empty on a range
  19. Solved: VBA Userforms and Cell based formulas not getting on together!
  20. Solved: Adding and Naming a Worksheet using VBA
  21. Moving Data from one table to another based on value input
  22. Solved: Highlighting Option Buttons
  23. Data And control operations from a closed workbooks being applied on report
  24. Solved: Cut Paste data into different sheet
  25. [SOLVED:] check lengh of the values and move to next sheet
  26. [SOLVED:] Loop not looping properly
  27. Solved: Active Cell Help
  28. Solved: How to bring back Recording / Stop Recording floating tool bar
  29. Please help to tweak my VBA codes
  30. Solved: Formula For Less Than / Greater Than
  31. insert array formula into range based on option button selection
  32. Solved: Text Import - cell format issue
  33. Solved: Run time error 1004
  34. Solved: VBA Hyperlink Problem
  35. Solved: Insert Image from file
  36. Solved: VBA Sort
  37. Solved: multiply statusbar
  38. Solved: Deleting Worksheets without OKing "Warning Message"
  39. [SOLVED:] Solved: Check if Sheet Name Already Exists
  40. [SOLVED:] Dynamic Controls
  41. Solved: Drop down lists tutorial
  42. Solved: help with copy and paste
  43. copying data from a closed workbook
  44. Solved: Create A Short Cut Key in Menu
  45. Solved: Autofilling a formula within row parameters
  46. Solved: Subtracting Named Ranges from combo box selection
  47. Solved: Interesting Auto-Number Problem VBA
  48. Solved: rearranging Code, separating OffsetResize
  49. Solved: Index Match Formula - Odd Behaviour
  50. Email code problem, stopped working
  51. ScrollBar value * call Macro
  52. Combobox vs protected sheets
  53. Solved: Vlookup in VBA - problems
  54. Solved: YesNo Box - Options Query
  55. Solved: Covert number to absolute value
  56. Solved: VBA issue with named ranges across workbooks
  57. Solved: Long vs Double data type
  58. Read Only view of a worksheet
  59. Solved: Copy content of upper cells
  60. Solved: Create folder & export sheet, not working
  61. Solved: TextBox Deleter Mystery
  62. Solved: Changing code (connecting range to dropdown selection)
  63. Solved: Named cell reference
  64. copy rows to worksheet two and PDF to print
  65. Solved: Problem with textfile save
  66. [SOLVED:] Exporting select data to a .cvs
  67. Solved: Run-Time Error "13" - Type Mismatch
  68. Combine 2 Codes
  69. Solved: Using vlookup with changing end array column
  70. Solved: Deleting rows as if by magic!!
  71. Excel chart alert (32000 pts)
  72. Copying range value without cellformula
  73. Data changed when imported
  74. Creating Timestamps
  75. Annoying privacy warning
  76. Solved: Automatically Save As when file opens
  77. Solved: Want to apply code to all sheets but wont work
  78. Solved: if cell="yes" then colour row yellow? how could do this?
  79. Sum If Same Row in data table contains criteria
  80. Get txt files from a folder to master file in different sheets
  81. Solved: Employee Rota: Worksheet_SelectionChange not working
  82. CHART Formula Change VBA
  83. How to make an input form?
  84. Updating series for all charts on Worksheet
  85. Running a Function or macro of child file from a Master file
  86. Cascading Lists via VBA
  87. Solved: Select numerous cells from active cell
  88. Invoice
  89. [SOLVED:] Date format incorrect from Text File
  90. Solved: Search Macro and Merged Cells
  91. Userform in Defult text box
  92. Solved: write log of changes in workbook
  93. Solved: how to wrap pages in multipage control
  94. Thank You VBA Express.
  95. Scrollbar
  96. How to extract data from Oracle Database into Excel Spreadsheet via VBA code
  97. Solved: Simple delete entire row
  98. Separating prices by month
  99. Deleting All Shapes Deletes Data Validation Forms
  100. Naming ranges of cells using cell content
  101. Solved: Print Preview
  102. Finding average of a range with macro
  103. Solved: Loop and Compare cell value & value returned from ado query
  104. filter based on active cell
  105. Listbox items from an array
  106. Solved: EXCEL communicating with hyperterminal
  107. Comparing data against table of values to output new data.
  108. Get help for telling me how to code VBA to pass argument from Userform to worksheet
  109. VBA Strongly Typed Arguments
  110. How to line up input boxes on forms?
  111. How to deal with quotes within a string
  112. Column Formatting Works in one instance, but not another
  113. Preparation of excel spreadsheet data for google motion charts api (VBA?)
  114. How do I disable inserting of rows?
  115. VBA Code to Automate Grouping
  116. Returning Arrays From Functions
  117. Source Control Of Spreadsheets
  118. Solved: Copy/Import based on Column Header Name
  119. Error message for missing data in userform
  120. Pass date as parameter
  121. Solved: Split Control
  122. Getting user to log changes before workbook is closed.
  123. Solved: vlookup not cooperating with other code
  124. Pivot Table Macro to lock manual filter/remove blank rows from datasheet
  125. Running a function of another file
  126. Sleeper: The opposite of TRIM
  127. Professional Looking UI Forms
  128. Icon Librarys
  129. Bot
  130. Option Button first IF not working.....
  131. How to open Other file types
  132. Referenzen permanent verfügbar machen
  133. Solved: vlookup problems, even formatted as numbers
  134. How To Use Vertical Spacing - Make Equal
  135. [SOLVED:] Macro to make linegraphs
  136. Solved: Prevent duplicate data entry?
  137. My Macro stinks
  138. Closed: My Macro keeps crashing!
  139. Select/De-select items in list box
  140. Tracking Deadlines with Excel and Groupwise
  141. Solved: Calendar Control
  142. Error when passing data from Excel into Access (Office '97)
  143. Using Template To Produce Reports Where Number Of DataItems Changes - Advanced.
  144. Excel 2007 Pivot chart - showing filters on pivot area
  145. Copy from a cell and insert in another on a new line with a date
  146. Finding String2 in String1
  147. Trapping UserForm Events In A Seperate Class
  148. Solved: Pattern match to find worksheet name
  149. Maximum users of an Excel File?
  150. Solved: clicking on option button
  151. Selected Cell Color / Personal.xlsb
  152. How do I check if a word file is open from code?
  153. Functions
  154. problem comparing cells based on a condition
  155. Update specific data in one sheet with NEW data from another?
  156. move items in column up/down by criteria
  157. Solved: Get cell reference from one cell
  158. Solved: Copy range from multiple excel files in one file
  159. Solved: Insert a formula if a different cell is not blank
  160. Unable to copy, paste; Right click disabled
  161. Excel 2007 and if statements
  162. Solved: Sync ListViews items
  163. Copy to first filtered row problem
  164. Solved: Find a sheet name
  165. Self Destruct VBA Code
  166. Match value in two columns & delete non-matching rows
  167. Solved: Check list of folder files
  168. Decent Grids
  169. Disabling ActiveXControls Prompt
  170. Paste Combo Boxes so Cell Link is always in same row
  171. Solved: Macro to add value to cell based on previous available cell valu
  172. Solved: Sheet Calculate Event Not Working
  173. VBA Statements work in debug, but not otherwise.
  174. Using Progress Bars
  175. Delete Copied Data
  176. Looping through a range code
  177. Incorporating lastrow variables into sumproduct formula
  178. Solved: UserForm KeyDown Button Forces cursor to jump to next textbox
  179. Solved: Excel Update Links Problem
  180. Solved: Code to find a given string in a worksheet
  181. [SOLVED:] Database Connectivity Using Singleton Pattern
  182. Making a cell noneditable based on dropdown value in another cell
  183. autofilling formulae across columns
  184. Hiding sepecific column on based of condition
  185. Solved: Remove blank series from a chart using VBA ?
  186. Generate a message to Save and Not Open when downloading a file
  187. [SOLVED:] Need Help Trying to Unlock Certain Cells
  188. Do Loop Help
  189. Forward stepwise regression using VBA
  190. Working on Code efficiency...
  191. Capture Printer from Printer Dialog
  192. RibbonX code
  193. Solved: Error 1004 in Transpose macro
  194. Wrapping UserForm Modules.
  195. Solved: Hide Unhide Worksheets based on Name
  196. Help With Formula
  197. Public Variables don't work
  198. Unable to copy excel spreadsheet to another spreadsheet
  199. Solved: Data Validation , multiple selection same cell
  200. Solved: find, copy and paste
  201. VLOOKUP or HLOOKUP
  202. Solved: Changing Arrangement of Text in a cell
  203. Solved: Moving Rows with repeated value to different Tab
  204. Remove zero chart labels
  205. Solved: import data from another workbook
  206. Solved: Hyperlink - full address from displayed text
  207. Copy and Paste Range in the body email
  208. Solved: Dynamic code based on cell values
  209. VBA for Pivot Tables Help (Dates)
  210. Is it possible to create VBA or even VB just by entering data into a worksheet?
  211. File Lister
  212. Combine 2 or more Cells into 1 Cell VBA
  213. Userform input value to macro
  214. Workbook OPEN Event Code - Update Links
  215. Solved: How to chk on duplicated cell values & show msg box
  216. Varying the cell range around a sum formulae
  217. Passing a UDT member/element
  218. Can Excel 2007 help with website accessibility?
  219. Solved: Macro to Add Link to Each Worksheet?
  220. Solved: Prevent Sql injection in User Form
  221. Solved: Centralized Log Manager
  222. Solved: Limit length of input text box..
  223. Add subject, body, and attachments to emails thru excell/groupwise
  224. Solved: Detect if workbook is Read Only
  225. Shifting data in cell from a work book to another based on some condition.
  226. Special macro for range goal seek
  227. First & Last name comparisons
  228. Solved: wb close and form close
  229. Refresh pivots on close AND on data being entered
  230. Process works in debug
  231. Solved: UserForm change width- Left Border?
  232. I need help with a click proceedure attached to a dynamic label
  233. Print specific pages of PDF in Excel using VBA
  234. VBA Code Help
  235. Solved: useform help filling list from DB VBA
  236. Stop Excel from Updating Formula to external Workbook when copying the formula
  237. Extracting highest value correlations and series names from Correlation Matrix
  238. Solved: SUMIF "criteria"
  239. Solved: Calculate cell
  240. Solved: Formula Problems
  241. Solved: Inserting data from Excel into Access
  242. Sub string help
  243. Using an Excel Spreadsheet as a DataSource using DAO
  244. Excel VBA to print the entire Workbook single sided
  245. Problem toggling details
  246. Solved: Move excel files to a difference folder if sheet name is not "Payment Request"
  247. Report Macro
  248. Problem importing data from an xml file
  249. Solved: Copy a Chart into another Sheet without Links
  250. Solved: using "--"