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

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