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

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