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