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. Convert to For Next loop
  2. [SOLVED:] LastRow from a specific Cell
  3. VBA Help
  4. Put linear trendline equation into cell
  5. Problem about sort horizontal with Function.
  6. Problem about Loop through files sort by Date.
  7. Logit VBA Debugging
  8. [SOLVED:] Hide Column Target Cell Clicked - From a List
  9. Checking For Commands From Central Server
  10. Outlook Calendar In Excel
  11. [SOLVED:] Auto Save Excel File as PDF
  12. Email Range Of Cells
  13. [SOLVED:] Show/Hide a Textbox Based on Value of a Combo Box in a USerform
  14. Sum with weeknumbers of a given date
  15. [SOLVED:] Loop through sheets based on cell contents
  16. operations copy and paste file from Adobe Reader
  17. How To Copy just the value in Excel.
  18. Search data in 4 Contiguous cells within a selected area
  19. Amending Code To Reference value (Email address) In Cell
  20. Can I "cancel" Workbook_WindowDeactivate?
  21. [SOLVED:] For If Statement with Two Ranges
  22. convert column to matrix
  23. Hyperlink With Special Characters
  24. Cycling through sheets with loop
  25. Help adding font size / color / etc to my macro
  26. [SOLVED:] How to Combine a Save As PDF macro and an E-Mail send macro???
  27. Problem about function reference
  28. How To Copy excel to powerpoint
  29. How select next blank cell in row and add timestap
  30. SAVEAS with location
  31. Delete all AllowEditRanges in workbook
  32. Copying cells from worksheet that varies in cell range and number of pages.
  33. [SOLVED:] Automatically Update TextBox on Other Sheet
  34. Match to master
  35. Delete Entire Row Based on a Selection
  36. Run time error 429 - ActiveX component can't create object.
  37. Information about Transferring Data In Excel.
  38. Problem about a variable value In excel.
  39. Chart - Plot has different size
  40. Out of Memory error on close tries to open protected VBA
  41. Search List, Find Sheet, Return Value
  42. Autofill Across Columns with "Centered Across Formatted (3 Columns)" Quarterly Dates
  43. [SOLVED:] Please Help me
  44. Search for postcodes in a PDF document and list them in a excel worksheet
  45. Open all pdf one by one from a folder using followhyperlink
  46. Questions about conditions in excel function.
  47. Need help of members with spreadsheet allows users to manipulate.
  48. Macro for executing commands from cmd prompt
  49. Macro to count repeat occurrences from closed WB and paste total counts in new WB
  50. Adapt macro that copies excel to ppt
  51. Sleeper: Open Hyperlink File From Cell - Follow Hyperlink
  52. [SOLVED:] CheckBox on UserForm to show Full list or Part list according to Criteria
  53. VBA Coding to send a common email to different email addresses based on cell values
  54. Issues about source in excel 2010.
  55. Question about create Macro manage information.
  56. Use WinHttpRequest#responseStream for SOAP Request
  57. When Limit has reached in Excel, send to Sheet2
  58. loop, vba
  59. Insert Excel cell range in Shell command
  60. Insert row automatically?
  61. add payment button vba code
  62. [SLEEPER:] Exit User Form Button
  63. Find duplicates with VBA
  64. Copying multiple ranges to Word
  65. [SOLVED:] Initialize modeless FYI Userform but focus never leaves sheet
  66. Download from FTP
  67. Saving to different folders based on part numbers in B1
  68. [SOLVED:] Help with VBA password in commanduttons
  69. [SOLVED:] INDIRECT Row Reference and Increments
  70. ie.navigate to follow links from A1 to A2000
  71. VBA an MSGBOX
  72. VBA Multiple Attachments
  73. Pasting excel tables one after the other from excel into a word document
  74. Meaning of iLastColumn = .Column + .MergeArea.Columns.Count - 1
  75. Excel VBA Database
  76. Macro: Sheet 1 populates Sheets 2 & 3 with unique records only. (stuck)
  77. Sleeper: VBA to group matching data and copy for printing
  78. Problems Initiating a User Defined Function UDF - Using Application.caller.row
  79. How to login with vba
  80. Can't select and activate cells during BeforePrint event
  81. VBA code to Copy/Insert + Delete rows by criteria
  82. VBA: Apply loop to existing code
  83. Save Worksheet as PDF and Attach in Outlook
  84. Extract data from LinkedIn
  85. All VBA Code Stopped Working
  86. Error 53 "file not found"
  87. [SOLVED:] Help to create a date range chart based on a date wthin the data
  88. Copy and rename files without overwriting files
  89. From Sheet.add to Workbook add method
  90. Multi-choice of the listbox to many controls(textbox)
  91. VBA Simple Code Help (Formatting FDM)
  92. [SOLVED:] Problems using ComboBox
  93. Looking for help with VBA code please?
  94. Gantt Chart
  95. [SOLVED:] Need VBA code for Copy+insert / Delete rows & columns by criteria
  96. Code guidance please
  97. Sort All Sheets In Workbook
  98. [SOLVED:] Individually generate email content and attached all files from folder based on cell
  99. [SOLVED:] Copy first 5 characters of Course Name to Column A
  100. [SLEEPER:] VBA code to rename folders
  101. Unable to read last line from VBA plink stdout
  102. [SOLVED:] Set Variable of column number to Multicolumn ListBox
  103. Sleeper: Copy Paste as Values & Save as new sheet
  104. Copy Missing Data to Main Worksheet.
  105. [SOLVED:] Sorting Sheets in a specific order
  106. [SLEEPER:] Populating checked items in worksheet1 to worksheet2
  107. VBA Checkbox buttons
  108. HTML click not consistently working
  109. Passing Data from UserForm to Sheet makes excel to crash (Why?)
  110. Auto-resize Shape_width
  111. Loop through Vlookup
  112. [SOLVED:] Using Workbook from FilePicker
  113. Sleeper: Help with combining these macro snippets?
  114. Need VBA Code to close userform
  115. VBA Command button
  116. Excel File-1 copy the value & compare with Excel File-2 and Save it in Excel File-1 ?
  117. Pivot > Showall data in rows field
  118. [SOLVED:] Fix calculation of minimum date
  119. [SOLVED:] Hide rows between 2 strings
  120. Open Images Folder Mac OSX
  121. Workbook Password Protect
  122. Need help with a VBA code for distributing data
  123. Validation Tool- Lookup for Mis-Match and send email out
  124. Why data labels gone when i paste the chart to other workbook and change the range?
  125. Copy select data on USERFORM
  126. [SOLVED:] Combo box filtering?
  127. [SOLVED:] Send attachment via outlook
  128. Macro to conditionally insert rows not functioning as intended
  129. [SOLVED:] UDF to convert column Letter to Number and return the Largest column as Number
  130. [SOLVED:] Match two rows using VBA
  131. [SOLVED:] Require VBA Macro logic for Multiple ID and Matching Columns data.
  132. Stock Length Calculator
  133. Copy select data to different column
  134. Copy line by index number and past in another worksheet
  135. [SLEEPER:] Embed an "open file" dialogue box to userform, Excel 64 bit version
  136. VB script to filter and update value in different sheet
  137. Generate random values between two number and specific string
  138. Hitro Macors
  139. Match two rows across various columns using VBA
  140. Stopping or breaking userform or code causes VBA to flip through all userforms
  141. [SOLVED:] How to check whether Cells contains specific number?
  142. Resetting Dropdown list in all sheets (Excel Workbook)
  143. Hyperlink Issue
  144. [SLEEPER:] Convert Vlookup to VBA
  145. How to conjuct all the excel value into one cell?
  146. [SOLVED:] How to get Last Digit from Text
  147. Copy data from one sheet to another based on a certain criteria
  148. [SOLVED:] Identify column header name based on a colored cell
  149. VBA Express Certification?
  150. Trying to extract all data from word docs into excel docs
  151. [SOLVED:] Run-time error 91
  152. [SOLVED:] Match and Vlookup method
  153. Google map Travel Planner #1
  154. [SOLVED:] Left Right Function Help
  155. Can VBA be used to search a folder of .docx's for text strings and copypaste to Excel
  156. [SLEEPER:] Codigo VBA para fecha matar o arquivo temporário.
  157. Delete rows except the last one with same numerical value
  158. [SOLVED:] Code to match to cells using a mapping
  159. [SOLVED:] Unhide Worksheet on Selection of Cell
  160. [SOLVED:] Trouble using selected range to define a for loop
  161. [SOLVED:] On Open: "This action will reset your project, proceed anyway?"
  162. [SOLVED:] Macro to create list of hyperlinks to all files in chosen folder including subfolders
  163. [SOLVED:] Remove Apostrophe from string
  164. [SOLVED:] Add shape only if shape doesn't already exist
  165. SUMPRODUCT in VBA
  166. Ping tester in Excal
  167. Run-time error '462': The remote server machine does not exist or is unavailable
  168. Help me insert subtotals on I:L my vba code below. It sorts and insets a blank row
  169. Data Formating - Macro to copy header row and paste to multiple columns.
  170. [SOLVED:] Assign Shape Macros - From List
  171. Need help with this macro to have it work with Alpha Numeric data
  172. [SOLVED:] VBA to create a mapping
  173. [SOLVED:] Group Shapes Rename Them - Loop Through Worksheets
  174. [SOLVED:] Find and replace
  175. [SOLVED:] Find Text Within A String
  176. "MSACCESS.EXE" process issue - How to terminate this process correctly
  177. VBA code disaappeared.
  178. [SOLVED:] Forms 2.0 library
  179. [SOLVED:] Conditional Compile Question
  180. Open workbook with dynamic filename
  181. Concat date and time in one cell
  182. [SOLVED:] Find a Value in a Cell and Delete some of the text
  183. Adding Code to Workbook_BeforeOpen
  184. Open multiple password protected workbooks in a folder
  185. [SOLVED:] Split files and attach them to an email
  186. [SOLVED:] Create multidimensional array from several non adjacent table columns
  187. Problem in Executing the Code
  188. The BIG DATA Challenge - Match cells on BIG DATA Sheet (LOOP take 4 Hrs !)
  189. Copy Leading Numeric Values, then Remove
  190. Update data entry for all future months (not a single month)
  191. Logging other PC programs via VBA excel
  192. Drag Drop Reorder part of Row .. Excel
  193. Help me to correct the vba
  194. trying to finish my vbaproject barcodescanner
  195. Syntax for Evaluate SumProduct in VBA
  196. [SOLVED:] trying to pull dynamic webquery data
  197. Make userform stay on top of all windows when macro is fired
  198. VBA: Help me write a code in vba
  199. Formula working wrong, I can't identify why.
  200. Copy and pasting time calculations
  201. Email alert not firing with VBA even though the condition is satisfied.
  202. Learning VBA Variables
  203. Random Sequencing
  204. Rename Current PDF file name using Excel Sheet List
  205. [SOLVED:] Search with Criteria on Userform
  206. i want to validate users entered value with existing range in another sheet
  207. [SOLVED:] Add 1 row below a selected cell using a user input box
  208. VBA help to convert unstructure data to structured data
  209. Data Validation
  210. [SOLVED:] Exporting Worksheet Code Modules - Export Code As Worksheet Name
  211. [SOLVED:] Looping For Duplicates In 2 Dynamic Columns (Odd Issue)
  212. [SOLVED:] Returning Description Based on Field Value
  213. [SOLVED:] Why is "1D050" numeric?
  214. [SOLVED:] Need Help constructing a vba counts rows between data and. Please
  215. create workbooks based on a given template using data in a table
  216. how do I save as .xlsx using xcell compiler
  217. [SOLVED:] SPLIT STRING issue with array if element not found
  218. Loop for certain text in cell - delete cells and shift up
  219. avoid iterations
  220. Help with duplicate matches when using Index(Match(
  221. Sum if Index Match with multiple criteria
  222. Copy down text in columns until next part number - VBA Code
  223. [SOLVED:] Declared Variable not selecting the correct range
  224. Need help reconstructing macros on this file in my description please!!!
  225. VBA code to sort, compare, and line up two lists of data.
  226. [SOLVED:] Delete any row which does not have any cells which are conditionally formatted
  227. obtain distinct rows based on three columns
  228. [SOLVED:] Start Loop Rows From - Row 10 on wards - Listing Files
  229. [SLEEPER:] Vba one to one and many highlighted
  230. hide and protected sheet macro not working
  231. [SOLVED:] VBA - Extracting 3 Text Lines From Text files
  232. Removing duplicates from multiple columns
  233. Help VBA using excel function help
  234. Vba help for a lookup table
  235. [SOLVED:] QR-reader to Excel (with time stamp)
  236. Multiple column select in VBA
  237. [SOLVED:] Combining two sets of data into one - vlookup, comparing part numbers - advanced VBA
  238. Data validation
  239. Retrieve value based on selection
  240. Select Case Function on a CommandButton/ToggleButton
  241. Merging columns
  242. Moved: VBA: Picture in Word-Header? Position?
  243. [SOLVED:] VBA Paste As Values
  244. Toggle to Hide Rows
  245. Matching multiple values from different column
  246. [SOLVED:] Filling in blank cells with data from another workbook - VBA
  247. VBA help
  248. ListBox on Userform doesn't refresh
  249. Filtering out a specific range and pasting it a row below
  250. new logic need to add to the code