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