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