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