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

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