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 174

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