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. [SOLVED:] Excel macro, combine cells based on same merged row i different column
  2. [SOLVED:] Run-Time error '91' Object variable or With variable not set
  3. Charts and forms freeze after VBA macro execution
  4. [SOLVED:] Macro For Re-Coding Variables after a Specified Cut-off
  5. [SOLVED:] i want VBA to display values greater than or equal to the given number
  6. [SOLVED:] Improving Cell Change Macro
  7. Delete columns in spreadsheet based on list of column names specified in listed range
  8. Sleeper: Create table array for Vlookup with match and count to next blank row
  9. Need Help to modify this Macro
  10. Sleeper: Can anyone help me with this code ?
  11. Combining three different tables in a chart
  12. [SOLVED:] Calling a function
  13. vba import data from another workbook with auto filtered of specified name
  14. Move to right column after return when I press enter
  15. List (Sort by) Birthday Anniversaries in .txt file
  16. Filter and sum the column values
  17. [SOLVED:] RUNTIME 13: TYPE MISMATCH ERROR
  18. Based on Cell value, from next cell has to move to 2nd row
  19. [SOLVED:] TABLE OF CONTENTS NOT USING TABS
  20. [SOLVED:] URGENT! GETTING DATA FROM ONE WORKBOOK TO ANOTHER USING VARIANT
  21. run time error '9' subscript out of range
  22. Map cells based on text
  23. VB Code Help " Error Variable not Defined " and Run time Error "438""
  24. Extract data from string to new sheet
  25. How do I check values on 4 columns simultaneously on two different workbook?
  26. [SOLVED:] Match code is not returning the desired field
  27. [SOLVED:] automating calculations and adding to existing table
  28. Find specific cell and insert page break - repeat till end of sheet
  29. [SOLVED:] DATE VALIDATION IN TEXTBOX
  30. [SOLVED:] Extract Matching Cell Values in Two Columns and Paste in New Columns
  31. insert sum formulas based on worksheet data
  32. [SOLVED:] VBA to provide search data from text box value
  33. Listbox.Column
  34. [SOLVED:] loop thru every sheet and filter out a specific name and create a new sheet
  35. insert sum or =+ formula based on value in another column for variable rows
  36. Heading Row Returns NULL
  37. Need to delete a workbook
  38. MULTIPLE FIND AND REPLACE FROM USERFORM INPUT
  39. [SOLVED:] Log to generate tracking numbers
  40. Need help writng macro to insert Spanish accented characters into a line of text
  41. [SOLVED:] Event Handler for external DLL events not triggering
  42. Macros to highlight three or more consecutive numbers entered in a set row
  43. match cells based on a string provided
  44. [SOLVED:] Source and target cells specification in a macro
  45. Search for Numbers
  46. [SOLVED:] Find string in multiple rows
  47. VBA to copy paste data in Master File........and adjust row as per data size..
  48. Excel VBA UserForm not working. Need help pls!
  49. [SOLVED:] HELP GETTING DIMENSIONS OF A VARIANT ARRAY
  50. Update data from one sheet to another sheet with header mapping
  51. [SOLVED:] ADDING A SHEET USING VBA BUT GETTING ERROR
  52. Hide / Unhide Rows and Columns based on selected cell value (drop-down)
  53. Number of days inventory held
  54. [SOLVED:] RUN TIME ERROR FOR A VARIANT! DONT KNOW MY MISTAKE HELP
  55. Restructuring of data without a standardized format
  56. Converting countif to frequency
  57. Help Creating Macro for Selection, copying ranges
  58. Listing Conditional Formatting on Separate Sheet or Workbook
  59. [SOLVED:] Saving Current Worksheet as Text in Current Directory
  60. Excel Macro Copying Information From Many Folders
  61. Force Excel Macro With Some Sheets Remain Hidden
  62. XLSX to XML Macro
  63. Show Sheets which have links to other sheets
  64. Add rows to existing table
  65. XLSX-XML Conversion through Macro
  66. VBA from access to excel
  67. [SOLVED:] Sending Email Drafts from secondary outlook email account
  68. Copying an active range
  69. [SOLVED:] Protected cells - want to enable comments
  70. VBA - Merging and Bordering of cells if condition met....
  71. Transferring Data from Multipage Userform to Separate, Subsequent Rows in Excel
  72. VBA - Unhiding a Worksheet and setting Sheet1 as current view
  73. Modifying COMport Code
  74. Run-Time Error 13
  75. Pull data from overall sheet to new sheet based on criteria
  76. Replace multiple repeated texts in multiple word documents from excel with excel vba
  77. [SOLVED:] FINDING LAST ROW IN COLUMN NOT WORKING
  78. Insert Two Blank Row if Condition Met
  79. VBA - Seperating Column data based on Criteria.....
  80. Select case using a collection of values
  81. [SOLVED:] Using an array to transfer file names into workbook with multiple sheets
  82. VBA Help - Run-time error '-2147417848 (80010108)': Method 'Value' of object 'Range'
  83. How to Merge Two Worksheet_Change Codes
  84. Copying spreadsheet into 120 sub-folders
  85. [SOLVED:] Copy/Paste Loop is only transferring rows 1,2, and 4, but not row 3?
  86. Ranking with conditions
  87. VLookup VBA Code & Elseif troubles
  88. VBA loop copy & paste range to same worksheet name of another workbook
  89. [SOLVED:] HARD:MADE A FUNCTION - HOW DO I LOOP THAT FUNCTION IN MY SUBROUTINE????
  90. Inset formula into last cell of table column
  91. RUNTIME 13: TYPE MISMATCH ERROR
  92. [SOLVED:] HELP!! GETTING MULTIPLE VARIANTS INTO ONE RANGE!!!!
  93. [SOLVED:] Pass the range from userform to sub of module
  94. [SOLVED:] HOW TO ADD 2D NAMED RANGES WITH SAME DIMENSIONS?
  95. Can't start edit or remove macros
  96. VBA code (macros) understanding
  97. [SOLVED:] Help With VBA Document Counter
  98. [SOLVED:] Automated Login Results in URL Change After More Than One Use
  99. trying to count total rows based on group of values in another column
  100. Object required on .Find
  101. [SOLVED:] Event Before refresh pivot cache
  102. Multi Find and Replace VBA Script Macro Not Working
  103. VBA - Select Case Error
  104. VBA - loop help in Seperating the data......
  105. [SOLVED:] need help with filtered table
  106. Get COM Addin list of functions
  107. [SOLVED:] conditional month()
  108. Pass variable from module to the userform.
  109. VBA sorting error
  110. Bug? with activeX combobox
  111. [SOLVED:] Trying to code this VBA macro but it's beyond my knowledge
  112. [SOLVED:] Adding links of files, seperating filenames with Split() - Error: Object variable or
  113. [SOLVED:] Merge specific word files from excel VBA
  114. VBA - Textfile Skip line Help in Looping
  115. '1004': Application-defined or object defined error (VBA)
  116. VBA Help: Email attachment via folder or direct-link
  117. Dynamically adding and positioning check boxes to wrap inside frame
  118. RUNTIME 438 ERROR WHEN CLICKING IMAGE
  119. How to hide textbox in userform by option button?
  120. INSERTING MULTIPLE PICTURES THAT MEET CRITERIA
  121. [SOLVED:] Copy value of active cell to another worksheet
  122. Searchable dropdown list (data from two columns)
  123. VBA Code Required to autosize image - I can pay via. Paypal or other method...
  124. [SOLVED:] Cross Referencing Filenames Using an ID and "Charting" Results Across Columns
  125. Search, find, hide columns - VBA
  126. Need to select a workbook which changes names everyday
  127. Excel Data Files
  128. Arrange Data Properly
  129. VBA to copy specific columns from word table to Excel
  130. VBA vlookup in file a with data from file b
  131. [SOLVED:] Trying to set color to a range
  132. Transfer of data between two workbooks using name of worksheet?
  133. [SOLVED:] Comparison isn't finding as true; but values sent to MsgBox show it should be....
  134. Cant count integer partitions by recursive function.
  135. [SOLVED:] Working with Dates in VBA
  136. [SOLVED:] Attach event to multiple ComboBoxes
  137. [SOLVED:] Filter and Sort with Multiple Headers
  138. Run-time error code "438"
  139. [SOLVED:] Suggestions regarding speed and efficiency
  140. Lock Cell/Cell Range based on Cell value
  141. [SOLVED:] Progress bar...%
  142. Send reminder emails based on date in column, after finding last email correspondance
  143. [SOLVED:] Is there code similar to "If Not Application.Intersect" & "If Not Intersect(Target..
  144. [SOLVED:] How to create a public array in class module?
  145. Copy and paste if cell contains specific text
  146. [SOLVED:] Perform calculations on a field that has already been added to pivot table
  147. Select and Edit certain type of ChartObject in VBA
  148. [SOLVED:] Need advice on VBA Conditional formatting Formula : Run-time error '5'
  149. Copy paste the data by vba
  150. extract data from a row with a lot of data
  151. [SOLVED:] “Application.Speech.Speak”, to announce the greetings.
  152. Add current selection to filter in VBA
  153. [SOLVED:] Turning 100 Data points into 6000 using VBA HELP!
  154. [SOLVED:] Multiple drop down selections in the same cell
  155. Run time 424 object required
  156. Possible to clean up my formula
  157. Double data and runtime error when running macro
  158. [SOLVED:] Excel Freezing Up When I Run Sub
  159. How to get msgbox output with spaces between every three numbers?
  160. Extra Screen for Laptop usinig Android Phone
  161. [SOLVED:] Loop sheets that begin with given chars
  162. [SOLVED:] Vba to calculate the number of days from today to the 1st of the month.
  163. VBA: Copy and Paste if criteria met
  164. I am having an issue with macro assigned shapes
  165. Employee number according to timetable sequence
  166. Several questions about the collection.
  167. [SOLVED:] Edit Excel Links in PPT Using VBA and Early Binding
  168. Summarized data based on timetable sequence
  169. VBA Merging duplicate -cells issue
  170. Conditionally put - sign
  171. [SOLVED:] Data Comparison
  172. [SOLVED:] Using a string in names of dublicates
  173. extract data from Excel Columns to an Output sheet
  174. Scanning Input not considered a Change
  175. [SOLVED:] Modify a macro to remove blanks from a worksheet
  176. [SOLVED:] Userform TextBox Loop Syntax
  177. [SOLVED:] Dynamically passing value to Sub using buttons
  178. Bold and color numbers in specific format with special character
  179. Is there a way to write this "for" loop?
  180. [SOLVED:] Overflow Error when using Format()
  181. [SOLVED:] All VBA Worksheet_Change Events Not Working
  182. VBA to check for PR SAP attachment
  183. Can't calculate long recursion
  184. VBA help in creating a dependent and source views
  185. [SOLVED:] HELP NEED TO MAKE CODE GENERIC LOOPING THROUGH CELLS TO IMPORT DATA
  186. [SOLVED:] Formula to return two multiple lookups in one cell ?
  187. [SOLVED:] If/Then/Else, Search & Set Active Cell VBA Help
  188. Excel Hyperlink when click ,automatically compose a message in outlook
  189. [SOLVED:] Loop through all open Workbooks in all Instances
  190. [SOLVED:] HELP GETTING SUM OF COLUMNS IN A RANGE
  191. check macro execution / speen
  192. User form in PowerPoint to feed Excel database
  193. [SOLVED:] Increment number based on two criteria
  194. [SOLVED:] Help speeding up macro
  195. [SOLVED:] Find word and delete else exit Sub
  196. Removing Rows Based On One or More Cell Values
  197. [SOLVED:] Extract amounts from text strings using VBA
  198. [SOLVED:] Compare and copy
  199. Pivot Table Creation Error
  200. IF LOOP FOR LOOP AND IMPORTING FROM ANOTHER WORKBOOK
  201. Coding Excel User Form
  202. Search whole row for
  203. Copy and Paste loop
  204. Suggestion for Best Practice
  205. VBA - Copy Multiple Columns as per mapping sheet union help
  206. How to put a named range in one workbook to another and call a button VBA
  207. [SOLVED:] Deleting Queries and Connections not working in O365 version
  208. VBA script/code to email range of data from an excel spreadsheet
  209. Get Unique list of cells in a Column for loading a Combobox
  210. Trouble Changing Active Cell After Pasting To 2nd Workbook
  211. Can I use vba to add hyperlink shortcuts to folders
  212. [SOLVED:] Extracting 8 digit PO from Field
  213. Excel file needs help
  214. [SOLVED:] Find Function
  215. [SOLVED:] how to make filter from data base and show count in VBA tool
  216. [SOLVED:] how to marge multiple sheet into one sheet
  217. [SOLVED:] how to use both userform and other excel
  218. How to pull data from a Sheet to create a Context Menu? How to combine two VBA codes?
  219. problems with printing
  220. [SOLVED:] vba tool for admin database maintain & analysis
  221. Filter Data Based on Dates + other criteria & copy to another sheet
  222. Defining range from First Cell to Last Used Cell
  223. [SOLVED:] i need Vba code that creates an input mask for a password ***** in an input box
  224. Retrieving all files in folder or subfolder containing specific text
  225. [SOLVED:] Trouble Assigning Error Bars with Array
  226. How to adjust the size of the `Note` after opening it?
  227. [SOLVED:] Find All, Copy & Paste to Next Blank in Sheet
  228. How to backup settings of Microsoft Office which are in registry branches?
  229. VBA - Open each file from directory in ascending Order
  230. Copy last 20 rows (or all if less than 20)
  231. Checking the values in Sheet1 with multiple entries in Sheet2, Write the output
  232. Using an addin to package all my source code
  233. [SOLVED:] VBA To Re-lock a specific cell after 30 seconds
  234. Find currency and add/debit according to amount
  235. Undo/Redo or CTRL+Z – CTRL+Y »» does not work for my own macros
  236. [SOLVED:] how to use userform to operate pivot table
  237. [SOLVED:] Countif and Count on visible rows
  238. [SOLVED:] Edit textfile vba
  239. HELP! VBA Problems
  240. [SOLVED:] .TextToColumns doesn't seem to work reliably.
  241. [SOLVED:] Need help getting results of macro displayed, starting at row 5 column B thru F
  242. Starting from specific place in a row
  243. [SOLVED:] Sumif multiple criteria
  244. [SOLVED:] Prompt user for date and user to Open file
  245. [SOLVED:] Copy and Paste
  246. Help to make VBA Model in Excel run quicker
  247. Very Very Very Very Complex excel formula required...
  248. split text in different cells after each underscote "_"
  249. Find previous day balance.
  250. Moving Sent Items To Another ARCHIVE Sent Folder.