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