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. Excel VBA dynamic array in a class
  2. Take contents of cells and use them to compose an email - Text Body Problem
  3. Solved: Macro to Allocate charges to each client code
  4. Solved: On sheet change macro.
  5. Color for multi range
  6. Dynamic Array
  7. Filtering With VBA Macro
  8. Solved: Visual Basic Editor in Excel
  9. Solved: mergesheet with formula
  10. Copy a .jpeg
  11. Using "For Next" to a button name
  12. Need Help: Auto-acept To replace
  13. Create Table Dialog Problems
  14. Need to build CRC-16 CCITT calculator
  15. ByRef doesn't pass values in dialog initialization
  16. Solved: If Then code
  17. Solved: helpwith WorkSheet Selection_ change & command button
  18. Solved: help
  19. VBA Multidimensional Array Question Help
  20. Solved: Copy last 6 columns
  21. Updating Defined Named Lists (Difficult)
  22. Solved: Dynamic Ranges not working with Data Validation
  23. Editing Text file
  24. Solved: VBA Help Plz
  25. Solved: Compile names
  26. Solved: Embed and Extract .exe
  27. Need to know if a file is corrupt
  28. Solved: open workbook
  29. excel 2007 compare to excel 2010
  30. Solved: Workbook
  31. Screen Refresh
  32. Solved: easy time formula
  33. Macro to pull Duplicate ID # and Absent
  34. Creating and deleting pivot tables and charts with VBA
  35. How to get VBA to read a directory from a cell.
  36. how to continue original workbook macro after calling other workbook macro?
  37. Syntax for converting printing decimal number in English to Spanish
  38. Calculate Interest on monthly values
  39. Solved: Excel 2003 - Is it complicated to save to a shared network drive?
  40. Auto add row and copy formula
  41. Solved: change the font color automatically
  42. If file is not in use or open then execute macro
  43. Solved: Fractions
  44. Help creating a search button on excel
  45. Solved: assign value to array
  46. Filter worksheet data as per the value selected in Validation Listbox
  47. Lookup with interval
  48. Solved: Multiple small issues
  49. Solved: Excel 2003/07 - Is it possible to unshare a workbook using code?
  50. Solved: Excel 2003/07 - How do I assign a UNC path to a USB Drive
  51. Solved: Copying data from one workbook and then transposing and pasting to another workbook
  52. Use Triggered Event in all workbooks
  53. Solved: Cell value to be used for row definition...
  54. Solved: Global Variables and Functions
  55. Solved: Is MyUserForm in ThisWorkbook
  56. Chart on VBA Form
  57. Sheets.Copy inverts colors??
  58. Function fails to update values?
  59. Help Refreshing table filters when updating a value
  60. Solved: VBA Function to Automatically Update
  61. Solved: Refer to the Last Row
  62. 2 months and sumarize amount of missed clients with formula
  63. Email from excel via groupwise 8 using vba
  64. Solved: formatting IF's
  65. Macro checking if currency change is right
  66. Solved: how to open a .txt file using excel vba
  67. Userform Input Saved To Different Workbook
  68. What is data modelling in ms excel?
  69. Solved: Excel 2003/07 - Can I use vba to clear failed print jobs?
  70. Spreadsheets Don't always Refresh in Macro
  71. Shell Cmd Works on Some Computers, But Not Others
  72. yearfrac()
  73. Solved: Date Formatting
  74. Solved: Form data to spreadsheet....
  75. Solved: ListBox, Option, MultiSelect
  76. Is there an alternative way of doing conditional formatting using vba?
  77. Exit from main sub
  78. Setting Series Colours the same accross charts
  79. Solved: delete rows
  80. Need audio player to be embedded in form
  81. Solved: Hide a list box (form controls)
  82. Block textbox for numbers or text.
  83. Solved: Conditional Formatting Via Worksheet Event Code
  84. Updating Functions within a Sub
  85. Vba Code to filter a Column automatically
  86. Can't figure it out .... Weird Bug!!
  87. Solved: Finding the last empty column in a row?
  88. Code Problem Saving Data To Another Workbook
  89. Solved: How to get only specific information from a .txt file using macro
  90. Download attachments from outlook folders.
  91. oldvalue help
  92. Delete empty space at end of row
  93. Error with sumproduct
  94. Storing range object temporarily in code not possible?
  95. Solved: deleting a range based on cell value on another sheet
  96. Web Query & Userforms
  97. License Key (Or Something Like This)
  98. Select Sheet Tabs Dynamically
  99. Solved: textbox value = cell range
  100. Solved: Transposing data where some data is in merged cells
  101. Solved: How to add comments to a entire column
  102. Solved: VBA modules crash Excel
  103. Solved: interactive test in excel 2003
  104. Solved: Search and Attach file to email using VBA
  105. Code to move row data to columns
  106. could not load an object because it is not available on this machine
  107. Solved: read file with marker
  108. Extract Data under Hyperlinks from a webpage in excel
  109. Macro Data Input Message
  110. Solved: LHS and RHS of Comma
  111. Checking hyperlinks in excel macro
  112. Solved: Sumproduct for Months
  113. Solved: Trying to use Line Input, but only vbLF
  114. Help to modify: "Combine All Data From All Worksheets in All Workbooks" (mvidas)
  115. Solved: Why using Range() works but Cells() doesn't??
  116. Solved: Cycling through multiple files in a directory
  117. Mortgage Application Userform
  118. uncompress a (zlib-compressed) string using ZLib in VBA
  119. Snake Eyes Program
  120. How to save a excel sheet into .txt file using macro
  121. Variable Not Defined
  122. Solved: Excel 2003 to 2007 "ENABLE MACROS"
  123. Solved: Highlight row when a cell within it has been selected and 'un-highlight' when not
  124. Looping a Macro
  125. excel
  126. Solved: If with an OR or &
  127. Solved: SaveAsUI.... cleanup before close.
  128. Compile error
  129. Solved: Pause/resume execution
  130. Solved: Excel 2003/07 - Why does using Application.ScreenUpdating not hiding sheet select
  131. Solved: Creating CSV file: double-quote problem
  132. Solved: Excel 2003/07 - I need to Bold two portion's of a string?
  133. How to create a scaled down bar chart from a pivot table. Can this be done?
  134. Solved: Getting macro to work on network and local drive ??
  135. Solved: Need help with VBA syntax
  136. Solved: Set a variable as todays date minus X days.
  137. Solved: "erroneous" result with IF condition!!
  138. Solved: How do you insert Columns using VBA?
  139. Solved: If statement in an Array Formula
  140. To recover Spreadsheet
  141. Solved: open all file type
  142. Solved: Copy Data from Sheet 1 to sheet 2 with auto
  143. Solved: Count filled cells
  144. Setting a Range Equal to an Array
  145. Adding Records to an Excel table Vba
  146. How do I open hyperlinks in a new window?
  147. Solved: Call an AddIn - Compile Error
  148. Automatically send email
  149. Solved: How to trigger macros from Validation List?
  150. extract only specific words/lines from a txt file
  151. code for printers
  152. Not able to extract text from a webpage
  153. Macros that can do automatic calculations with v-lookups on large data sets
  154. Conditional Formatting with a Named Range
  155. Copy duplicate instead of deleting
  156. Expected End of Statement
  157. What do each of these VLookups mean?
  158. How to create a macro that updates a spreadsheet calculation
  159. Transfer Form Data To Worksheet
  160. Solved: Macro to calculate only in cells filled with blue color
  161. Copy files
  162. Solved: Elseif select case not working
  163. Filter Column B based on Column A values
  164. Count of blank values in Pivot table
  165. Trying to write code in a shorter way
  166. Solved: MsgBox
  167. run time error '438' - Object doesn't support this property or method
  168. find selected combobox item's row
  169. Match and copy values from one workbook to another
  170. Before send as attachment
  171. may be userform
  172. Some kind of lookup or macro??
  173. Solved: Restricting Access to Spreadsheet by Network User Name/ID
  174. Area under curve -Integral Sumproduct?
  175. get data from txt file
  176. Solved: Unhide 5 Rows below when entering date Row Above
  177. Solved: Saving a Workbook
  178. Solved: compare columns from two sheets
  179. Static Variable
  180. Using Variable Index with FormulaR1C1
  181. Solved: Data Input Restrictions
  182. Speed up the macro-page layout?
  183. combo box custom rowsource and data on the fly
  184. Mouse-click event
  185. Open and Delete all VBA Components -- on locked Files
  186. Random numbers in range
  187. Mysterious file growth on sorting
  188. Solved: Clear Cell Content
  189. VBA macros used update and transfer data from sql
  190. How do I get full Name into a Variable?
  191. Solved: TXTbox filter
  192. Solved: Query Data in Excel WorkBook and Return Results in Same Workbook
  193. Hide Rows and Columns
  194. Solved: Subtracting Totals
  195. VBA vs VB vs Other
  196. Solved: Formula too long for vba?
  197. Solved: Save Sheet as xls
  198. Solved: Employee Scheduler in Excel
  199. Matching imported hyperlinks to another cell
  200. search and compare
  201. Restricted Access to Folders
  202. Solved: Populating Userform under specific cells
  203. Adding lines that affect formula
  204. Loop
  205. different the Capital letter in 1st 5 character using VBA excel 2003
  206. Solved: need help with a check
  207. Solved: counting with text help
  208. Need macros or something similar
  209. Writing and understanding equations using excel
  210. Solved: insert picture
  211. Solved: combine contents from a column
  212. how to find next but a new word?
  213. Solved: Vlookup error
  214. Solved: Populate ListBox from Worksheet Data
  215. v-lookup to order a column in alphabetical order
  216. Solved: Date formula
  217. Excel Export to Webpage Form Fields
  218. Solved: Extract State names - excel function
  219. Solved: find number in string
  220. AutoFilter and Non Contiguous Ranges
  221. Resorting document using VBA
  222. Scroll bar continuing to change after one click
  223. Solved: Worksheet Consolidation of Rows that Meet Certain Criteria
  224. Create table from list
  225. Solved: Extract Multiple State or cities names - excel function
  226. Application.SendKeys not working
  227. Solved: Sort Problem 2003 to 2007
  228. workbook on server close
  229. Solved: Data Form
  230. Solved: Read in value to use as array size
  231. creating a macro on a button to search for a file
  232. Solved: extract data in row 1 of sheet 1 into sheet 2
  233. A macro used to migrate data from a csv file into ms excel 2007
  234. FIX code for search variable from copy excel cell or clipboard
  235. Run-time error: 9 Subscript Out of Range
  236. Solved: Userform to Userform
  237. Help Splitting levels from Pivot Table into a table.
  238. Solved: Changing Range for Formula
  239. Matching failed
  240. Solved: multiple if formula and checkbox
  241. Solved: Find & clear blank rows
  242. Error 70 Permission Denied
  243. Command Button To Save & Close
  244. Hide Any New Column Fields in Pivot Table
  245. Autosolved - basic working with PDF
  246. Close workbook
  247. Solved: Cells not being Locked correctly!
  248. Solved: cells from tables sumed + checkboxes
  249. Solved: Auto Fill
  250. Adjusting Page Layout for printing