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

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