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