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

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