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

  1. Word Table formatting from excel vba
  2. Excel/AutoCAD Assistance Needed!
  3. Solved: Not important, error with the ISBLANK function
  4. Solved: Print PDF Range
  5. Need to show progress bar while executing the macro
  6. Remove duplicates, but keep the first one
  7. Solved: Please Help me to create a macro!
  8. I need code automatically copy and paste
  9. round function in excel
  10. Solved: replacement for Application.FileSearch
  11. Method 'Range' of object '_Worksheet' failed
  12. Updating from 1997 to 2007...
  13. Renaming excel sheet in specific format
  14. Solved: How to Hide the Sheets Bar in a excel File?
  15. 8192 areas error message
  16. Application-defined or object-defined error
  17. Solved: determine how long user was on a sheet
  18. CC more than one person on email
  19. copying text that exceeds the width of the page to the line below
  20. Dropdown List from Table w/o Duplicates (NON VBA)
  21. Solved: Please Help" Create auto hyperlink folders"
  22. VBA code to copy files from one location to another based off of creation date
  23. Solved: How to create a macro to unprotect the sheet?
  24. Get data without opening Excel?
  25. A Custom UI code to do ...
  26. Code to move data forward and back, using a checkbox
  27. Printing dates
  28. Solved: Extra Series ("File") in Chart with VBA Code
  29. Calculating Endtime/Duration
  30. Color background detection in a cell
  31. Solved: change printer setting
  32. Solved: List box value from an active cell.
  33. Copying files from FromPath to ToPath VBA Code inclduing sub directories
  34. Keeping a userform on top of another when using taskbar button.
  35. Import text from word document into excel
  36. Solved: Data picker and commandbuttons control
  37. Solved: Search for Values and copy certain columns to different worksheet
  38. How to use READYSTATE_COMPLETE
  39. ADODB.Connection : Sourcefile + if condition = error
  40. Solved: VLookup In VBA
  41. Solved: Match 2 fields and paste 2 values
  42. Solved: Range object acting up in 2007
  43. Referencing a closed external workbook - VBA
  44. Solved: VBA Excel Close Non Active File
  45. Copy to another sheet with find variable range
  46. How to solve this security alert message?
  47. How to Disable the ...
  48. Passing variables to a specified control
  49. Solved: prevent errors with multiple user input simultaniously.
  50. VBA run-time error 438
  51. Solved: splitting a part of text into another column after last space
  52. Solved: Update summery cells using indirect function
  53. Pasting from Excel to word
  54. Refresh listbox
  55. Call a function in another Excel 2010 AddIn (.xlam)
  56. Solved: Merge two codes
  57. Solved: task scheduler to run vbs script
  58. Compare two columns values with another two columns of same sheet
  59. Adding a value to the first instance of duplicate values in a column
  60. Macro help - highlight dupe cells
  61. Retrieving Computer object information from AD
  62. date display
  63. A simple code to move data with a Button
  64. VBA copy template worksheet to multiple new worksheets based on a range
  65. Solved: Track Cell Changes
  66. Solved: Error 1004 when copying and pasting with multiple sheets selected
  67. Scrolling through a list box with a mouse wheel
  68. Solved: how can i make this arry work
  69. Create report from data
  70. Consolidate Workbooks Into Summary Sheet
  71. how to save a backup file
  72. Merging Macros
  73. Looping through dim'ed objects - can it be done?
  74. VBA Code For Web Login Not Working
  75. Solved: Switching between Userforms
  76. Solved: How to read Excel or Word file (multi-word phrases) into Array
  77. Only once error 91
  78. Position cursor
  79. copy and paste in certain location in word
  80. create a permission on FIREWALL
  81. Solved: Selecting Cells
  82. Solved: Opening And Printing A Word Document
  83. Passing values between userforms on different workbooks
  84. Solved: Generalize code
  85. Worksheet change copy row &paste above macro
  86. Solved: Custom Text Format
  87. Calculations using excel vba
  88. Helper column
  89. Putting temporary data in a Combobox
  90. paste cell offset to right???
  91. CopyFromRecordset Decimal Values are copied as much longer decimals values
  92. Solved: check duplicate data in different worksheets
  93. Copy and Paste Values at 1 min intervals
  94. Solved: Help with conditional formatting
  95. un joining text in cells
  96. Solved: Userform to Spreadsheet help
  97. Hyperlink file based on cell text
  98. Solved: Error on code to copy from excel and paste to word
  99. Solved: Conditional Format help
  100. Reference cell that has the fax number
  101. Solved: Sumproduct and Countif error if there is a blank cell
  102. Getting Trendline formulae - results OK when stepping thru code, missing when running
  103. Copying values from one column and inserting below the values of another
  104. Automate logon to intranet sites
  105. Deduct Partial Vacation Hours Taken from a Date or Date Range
  106. vba code moving data of row from one sheet to another & vice versa
  107. Solved: Looping through a two dimensional array, displaying element values, having problems
  108. Copying results from dropdown to separate sheets
  109. Find N, leave blank and move down
  110. Automation Error Run-time error '-2147217871 (80040e31)'
  111. Solved: Edit Cells finding the last row
  112. conditional formatting help
  113. hide/unhide textbox
  114. Solved: Application hanging for apparently no good reason
  115. Delete sheets with execption
  116. Solved: Loading and unloading forms
  117. Solved: Sorting Issues.
  118. Incremental number for saved files
  119. Copy rows to 2 sheets using criteria
  120. Solved: VBA code to turn the formula into value
  121. Unique List and tally from Rows
  122. Sometimes Simpler is better
  123. Excel VBA Chart.Axes(xlValue).MajorUnit
  124. trouble with modestly large integers
  125. Compare Dates and Clear Cell Contents
  126. help needed for column retrieval from various sheets.
  127. Retrieve highest number from an array
  128. How to average a column in vba?
  129. Read/Export table from Outlook mail body to Excel using VBA
  130. Get Column Letters (Excel 2010)
  131. Solved: Resizing a range based on matching values.
  132. Expert Needed Macro Assist
  133. Combining Multiple Workbooks only grab 1st sheet
  134. Solved: Move from first sheet to first sheet +1
  135. Complicated Charting Issue
  136. Autofill column to last row
  137. dynamic chart in excel, size changes - desperate for help please!
  138. Solved: AutoRefresh 5-7 Pivots within a Workbook.
  139. open workbook - check date and percentage - send email
  140. Adjusting MyPath Variant to point to specific folder
  141. I need help with creating a Macro!!
  142. accepting and storing a user/password temporarily?
  143. Move selected columns data from UserForms listbox to different ranges in Worksheet
  144. Solved: Searching and Copying
  145. copy values to another worksheet in next down cell
  146. Expand 2 Columns to Multiple Columns with unique ID Rows
  147. Solved: Import data from closed WB to textbox in userform
  148. More efficient code for copy/paste between workbooks
  149. Need way to invoke macro at a different workbook the current
  150. Solved: Using Index and Match with Dates
  151. Sum Base %
  152. Get data from closed workbook
  153. Solved: VBA to convet to IF(ISERROR formula
  154. Solved: Spinner Button
  155. Solved: search for words in all caps in Excel
  156. Unable to access the link for the Add-in
  157. Solved: Text to Columns
  158. Help with web adresses and vba
  159. Auto deletion of worksheets based on multiple criteria, and automatically returning v
  160. Selection Printing either Landscape or Portrait
  161. Auto Extracting Recording From RTF to EXCEL using VBA
  162. Solved: Check if File Is Open
  163. Solved: Selection Caps Locks
  164. Solved: Show top ten closest match amount
  165. Could not change the cell color using VBA
  166. Help Creating a Macro
  167. Solved: Copy & Paste in same cell
  168. Macro to group rows
  169. Target prices
  170. How to populate an array with results?
  171. Email validation in vba
  172. Solved: Create pdf attachment from Url in cell and send via Outlook
  173. Save WordDocument as PDF using Excel 2010
  174. Solved: Find N, Insert N and Shift down
  175. Issue with custom Menu - how to have it only in one Excel file?
  176. Solved: VBA indenter
  177. VBA Shared workbook
  178. Getting a handle on internet explorer instance
  179. application.hide and opened file by two users
  180. Solved: Userform Text Field Format
  181. VBA code that sums column "C" in all active worksheets
  182. Macro to email file location
  183. Solved: Pivot help
  184. Solved: Pivot table column totals
  185. Solved: Creating an Array via a Range
  186. Dynamically Update Defined Names Range
  187. Solved: Code Not Cycling Workbook
  188. Solved: Ranges are the Worst...
  189. Defining Ranges Using VBA
  190. MS Excel Macros to Update Spreadsheet automatically
  191. Solved: make workbook close if in use by other user
  192. Tool to clean up VBA code
  193. Solved: Copy column and paste into rows
  194. Match and copy, unique condition
  195. Sum a range with values & blanks then paste product into a cell
  196. Solved: VBA Sort
  197. Regression
  198. Lock Column Cells If Cell Equals
  199. I Need vba code clear cells
  200. Solved: .Application.Visible = False
  201. SolverAdd ignores certain constraints
  202. Solved: Incorporate VBA With Copy and Paste
  203. Solved: subscript out of range
  204. Need to copy part of active spreadsheet and save to desktop
  205. VBA Autosort Exclude Text Value
  206. Solved: Find value in column "A" on one tab to another tab and replace the value in column "B
  207. Solved: Need help with a Macro to copy cells in column G & H if cells in col K & L are blank
  208. Solved: Icon software
  209. Showing Sheet content in WebBrowser control
  210. Excel Macro
  211. Item Property of Files Collection
  212. Run-time error '1004 Application-defined or object-defined error
  213. Solved: Hide UserForm & Stop Closing Excel
  214. VBA PASSING VARIABLE
  215. UserForm Caption text with a cell ...
  216. Repeat Rows at Bottom of Worksheet
  217. Solved: Write-Once only rights
  218. Shape Selection Dynamically
  219. Solved: Sort Macro
  220. Solved: VBA Delete Error 400
  221. Excel Asking for DSN
  222. Solved: Need a quick Indirect() reference
  223. Excel 2007 - Change Default Format Data Labels Option
  224. Import text file format to excel difficulty
  225. Solved: Reloading a combobox with found data
  226. Solved: Using Formulas matrix in VBA and drag down
  227. Excel 2013 Compatibility
  228. How to apply a Formula in a whole column...
  229. VBA Excel - PPT loses textbox at Slides.Add !
  230. Solved: Pie chart series rotation
  231. Automate a process to run every hour
  232. find large numbers and delete
  233. Setting the Name for a Dynamic UserForm
  234. Forcing input format for dates?
  235. Solved: Autofill column with the values from next column ...etc
  236. Userform label Text link...
  237. VBA to auto-remove missing Refernces
  238. [SOLVED] Solved: force pastespecial values
  239. Excel / VBA Left Function (Fine-tuning)
  240. Calculation Speed
  241. Change object properties for previously created objects
  242. Macro not working in Excel2013
  243. ELSE without IF error
  244. Consolidate Worksheets(and new added sheets) into 1 Worksheet+sum by date & customer
  245. Some fun with message box????
  246. Solved: popup when calling function
  247. Splitting data in a cell to multiple
  248. Need help in collating data from multiple excel files
  249. Solved: Delete Cell Content based on criteria
  250. Solved: Excell crashing for apparently no good reason