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

  1. Copy data from Multiple Sheets
  2. [SOLVED] Merge multiple .txt files into one .txt thru Excel VBA
  3. Solved: Hyperlinking photos from directory
  4. Create Sheet
  5. export word tables into excel
  6. Solved: Find key words in a column and color the row
  7. Array or Collection - building a file summary
  8. next number in column
  9. Sum unknown rows with know columns
  10. Copy data from several worksheets to one existing worksheet with VBA
  11. Solved: deleting blank rows in a specific range
  12. expression for the code "cells.find(..)"
  13. Help perfecting some VBA from a recorded macro
  14. Removing Punctuation Macro Also Removing Leading Zeroes
  15. Creating a control
  16. Solved: Hyperlinking to bookmarks in a word document
  17. Solved: Display Message after Submission on a Data Validation List
  18. Change format of Variable to Time
  19. filter data and than load it into master file
  20. Solved: Run time error 424 object required
  21. [Excel 2010 VBA] Get events of an object created on a Frame, OLEObjects.
  22. WRITE FORMULA TO WORKBOOKS HAVE PASSWORD (EXCEL 2007)
  23. Solved: AlphaNumber Formula
  24. Solved: VBA VLookup not working
  25. VBA Problem taking cell data from IE
  26. Solved: evaluate some numbers
  27. Pivot table multiple filters
  28. Reference a word doc embedded into excel
  29. invalid property value error with combobox
  30. Solved: Chr(34) returning ""
  31. SQL statements with VBA
  32. Shell with an array result - check items 1 by 1
  33. Who Can Solve This Problem?
  34. Solved: VBA code for number sequence excel
  35. Cumulative mismatch records to single one
  36. How to add calender controls button in toolbox
  37. Criteria Based web query in excel
  38. Solved: Enter Times Without the Colon
  39. Excel VBA - load and search a Word Doc?
  40. Back to user form
  41. Worksheet_Change and DDE
  42. Password encrypted
  43. How can I let the macro determine if the contents of a cell is numeric or text
  44. VBA Code for Calendar Date Button
  45. Cell Tab Order
  46. textbox to integer
  47. Run macro at different intervals based on cell date's distance from today's date
  48. [SOLVED] Infinite Loop problem
  49. Solved: VBA Code for Sum by condition for each date
  50. Solved: Incorporating dynamic ranges into CORREL function using VBA
  51. Solved: Simple Segregation of Sums
  52. Clear out static variables
  53. error when changing font color with VBA based on cell value
  54. regex function isn't working
  55. Email with updated spreadsheet attached
  56. Solved: Lotus Notes
  57. macro to generate next serial NO
  58. Hyperlink problem
  59. expression for offset()
  60. skipping ahead in for loop
  61. insert empty row where the content between two lines are different
  62. Solved: Msg Box on 1st of every month
  63. Copying from only cells with data in range
  64. Solved: trying to dynamically create a userform
  65. Solved: Print Selective Area
  66. check if workbook open - if not open it
  67. Adv Data Seperation
  68. Prevent Clear Contents
  69. pivot help
  70. if sheets("sheet1") doesn't exist, then a message box will appear
  71. Solved: VBA If statement using and OR function
  72. Solved: the last cell in each column
  73. VBA Generating List
  74. need vbd string to number
  75. Solved: Auto Numbering Alternative Column using VBA Macros
  76. cut, paste, blank cell....
  77. Solved: Vlookup help filling combo box
  78. Help to Create Addins XLA for user control access
  79. Open a File from a folder Excel Vba
  80. Increase row number
  81. Array to fill combobox
  82. Userform_activate from immediate window?
  83. Solved: Running a Function from a Worksheet
  84. Concatenate Data with Column Headings
  85. Solved: Need help to understand this code
  86. Problem Reading Text file with Excel Macro (VBA)
  87. How to use variable column number in vba
  88. Solved: Add amount everyday
  89. Solved: Pivot Table Source and Filter
  90. Solved: Code that returns the full path of a link
  91. Solved: Copying excel cell content into word template table
  92. Port to word doc
  93. Macro to LIST ALL FILES IN FOLDER and then IMPORT ALL LISTED FILES
  94. select columns A through D for each cell value in column A that equals a variable
  95. Excel Macro Code Run without Button Click
  96. Use a macro to stop to run other macros.
  97. Solved: Too next Together?
  98. Random
  99. Solved: Assign Cell Value to array
  100. Data Sequence like sheet1
  101. Problem with Macro printing code
  102. Solved: Silly Ques: What is the Underscore btwn listed variables?
  103. Runtime Error '9' Subscript out of range
  104. Error handler
  105. Solved: Too many nested loops in excel
  106. Solved: Controlling a webpage dropdown
  107. Interesting observation about evaluate command
  108. Web Query from Logon and password protected web page
  109. Copy non continuous ranges and paste it new word file
  110. Convert format cell to text
  111. [SOLVED] Compare Two Columns and return text
  112. Close ss with confirmation
  113. Solved: output excel rows to txt files
  114. Solved: Copy and Paste in next available row
  115. Highlight Cell if it contains a specific character in specific position.
  116. Help with VB in Excel 2010
  117. Mass file renaming
  118. Solved: copy only used rows to another sheet
  119. Advanced onsheet Goal Seek
  120. send mail automatically on a specific date
  121. Need for Speed
  122. First empty row in given range (i.e. C3:G16)
  123. Solved: Update current url
  124. find worksheet based on selection from dropdown list
  125. First experience with VBA - hoping to get tips on streamlining my macro!
  126. Open each file in ary and transpose range
  127. Today() to send email.
  128. SUMPRODUCT confusion
  129. Help w/ Comparing Lists using IF's and vLookup
  130. Conditional statement does not work
  131. VBA to open, copy data from one workbook to another
  132. Solved: Excel file only to open on designated computers
  133. My first VBA
  134. Solved: Can you determine row number from Activecell
  135. ActiveWorkbook.Path
  136. Opening CSV-files as new sheets in current workbook
  137. Solved: enable more options in userform with password
  138. Please kindly help!
  139. highlighting precedent cell
  140. Solved: Sorting
  141. Solved: Found data in another Column using Formula
  142. Open Excel and do vlookup.
  143. Detect Excel Version of a closed file.
  144. Solved: Sumproduct Question
  145. Command Bar Control Error
  146. ActiveSheet.ShowAllData
  147. Solved: Coloring alternate rows
  148. Possible via vba to check the datetime stamps on files in a directory?
  149. Setup column to require unique entry
  150. Solved: duplicate record count and paste in new sheet
  151. Populating combo box using dynamic range - run time error 1004
  152. Error handling
  153. unhide and activate worksheet based on entry in other cell
  154. Solved: Understand and Modify Code
  155. When there is an advanced filter, clear it.
  156. Solved: Need a tutorial on Array Redim Preserve
  157. Solved: SUM a range based on user selection
  158. VBA Security / Encrypt VBA Code
  159. How to fill the number in the cells.
  160. How to change the code to search by row instead of by column?
  161. Fill listbox then update same row
  162. Thank You All...
  163. Functions Within Functions...
  164. Leave only numbers in a column
  165. save as csv file format
  166. Solved: Naming a worksheet for all subs in project
  167. Solved: Excel Macro Copy cells and pastes them in another sheet
  168. Selection.OnAction = "macro1"
  169. Populating an array with a userform
  170. Search Multi workbook with multi sheet and copy
  171. Time Calculation
  172. Solved: Environ("USERNAME") - Can't find Project or Library error
  173. List of all Application. methods
  174. [SOLVED] Close Excel Window
  175. Vba To Fill Web Page Form
  176. saving tab as file
  177. Solved: Looping
  178. Compare Data in two excels
  179. Solved: It copy one row not all needed rows
  180. Series of IF conditions
  181. Trouble with Userforms
  182. Solved: Initiate .xlsm file with task scheduler
  183. Solved: SUMPRODUCT HELP
  184. Insert empty columns
  185. Solved: Reading a binary file into Excel with VBA code?
  186. Change cell color after using copy command
  187. Solved: Move every Nth cell up without affecting the rest of the columns
  188. Solved: Splitting addresses into multiple columns
  189. Excel 2007 automate calendar appointment in Outlook shared calender
  190. Import xml web page
  191. Solved: Legend.LegendEntries issue - Object doesn't support
  192. Solved: Copying Data from Multiple Excell Files - Range function problem Help
  193. Solved: VBA Coding not Updating in Excell Run`s
  194. Open all Excell files in subfolders without specifying Name of Files
  195. Passing variables inside the dynamically created form
  196. Macro very slow while generating output
  197. Solved: Save file and a standalone read-only version
  198. Solved: Copy Formula from cell above and Paste only values: help required
  199. Solved: Calling a user form
  200. Solved: Pop Up Window to Select Range
  201. exclude holidays when calculating between dates
  202. VBA Check for Duplicates in Multiple Columns from Userform
  203. Solved: controls combobox selection activating WebBrowser control.
  204. Solved: Color rows based on value
  205. Help Defining an ARRAY and c00 code
  206. Solved: Who can solve my matter
  207. Solved: Search document for words in keyword list
  208. Solved: Help with my code
  209. VBA comma method?
  210. Solved: Find last row
  211. Reading a binary file into Excel at certain hexadecimal addresses
  212. Solved: Entering same info twice
  213. Solved: Consecutive Numbers Define range
  214. Macro Excel
  215. Solved: Index for Macros
  216. Solved: EVENLY SPREAD PICK UPS ACROSS MONTH
  217. Why runs code twice in case of Mousedown event.
  218. Solved: Call cell by its name - not R1C1
  219. can't create object
  220. Unlock all VBA projects
  221. Copy Template to sheets
  222. Solved: Coloring rows
  223. Dropdown to change between spreadsheets
  224. Using hot button to export new Workbook
  225. Solved: Apply dates depend on Month/Year
  226. Macro to send email with multiple attachment
  227. Macro Recorder Error
  228. if workbooks("a") exist and is close, then open it.
  229. Solved: Comparing Array contents?
  230. Setting named ranges using a macro
  231. Solved: Splash Screen with no title bar "X"
  232. Solved: Autofill
  233. ExecuteExcel4Macro fails in Excel 2010
  234. If I put a password on my code is it safe?
  235. user form without excel
  236. Sleeper: Filter Languages Charactor Eng/Rus
  237. Solved: Assign a variable to sheet name
  238. Solved: Open PDF
  239. check and fill in the values to another sheet
  240. Format only the header data for all the sheets in workbook
  241. Solved: not every cell but every i cel
  242. Show avarage of cells with zero value in selected range
  243. PDF to word
  244. A VBA Question related to DATE
  245. Using Share Drive/Point to access Macros
  246. Solved: range
  247. Opening files simultaneously
  248. Autofill Macro from EXCEL to WORD
  249. Renaming the files in all the folders
  250. I need a macro file that could recognize the same rows With similar data and remove t