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

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