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. ADO / Worksheet range display in userform
  2. Solved: enable or disable comboboxes based on textbox enter
  3. Solved: Specifying last row range
  4. Solved: VB to insert missing rows with average of rows around it
  5. Problem with AfterUpdate for Listbox
  6. conditional formating.
  7. Go to worksheet that is specified by user in a drop down list
  8. Solved: QueryTables Loop Question
  9. Highest Values to the New Sheet
  10. Event Workbook_BeforeClose
  11. Solved: Find duplicates on 4 column and copy result on another column
  12. Solved: if find data delete the row on another sheet
  13. Solved: Find all occurrences in col T
  14. Solved: Copy Data of duplicate item to first sheet .
  15. Compare Data and Tabulate Fields Using VBA
  16. From text file to excel spreadsheet
  17. VLookup Help
  18. Can't get .presentations.Open ThisWorkbook.Path & "\Pres.ppt" to work
  19. Loop through subfolders
  20. Stopping macro
  21. Solved: Copy all data on Sheet 1 to the latest blank row of sheet 2
  22. Vlookup entire row with match 2 criteria
  23. Not able to Add a Scenario
  24. Solved: VBA Print Code and Protected Sheet Problem
  25. Troubleshooting Function
  26. [SLEEPER:] How to enter inputs from VBA a interface to excel spreadsheet?
  27. Application-defined or object-defined error
  28. [SOLVED:] Dependent combo boxes in a User form
  29. Solved: FindAll from Textbox Search on Form and fill ListBox with 34 columns
  30. [VBA] Reading a file from the server
  31. Solved: nested looping
  32. call code
  33. swapping values array
  34. System Error &H80004005 (-2147467259) Unspecified Error
  35. VBA Printing Code Problem
  36. Solved: lookup and populate
  37. Error when rng.find is nothing
  38. Creating an outline based on data in column:
  39. Solved: .TXT Batch replacing Macros
  40. Help modifying code
  41. Protect cells at different intervals and allow to select certain range
  42. Solved: How to code to open a read-only file with a "No" option?
  43. Private Sub Workbook_Open() and links
  44. Fill List Box With Data From Two Or More Columns
  45. Moving folders using VBA
  46. [SOLVED:] How to get the series range of a chart ...
  47. Custom Report form Excel data to text file
  48. Solved: UserForm find not finding dollar amounts
  49. Solved: Display 1 empty row only
  50. Changing the code
  51. Help PLEASE
  52. Import and Update Outlook Claendar to Excel
  53. OnTime reschedule based on cell date days from today
  54. Iterate Columns using Solver and Goal Seek
  55. Solved: If and ElseIf Statement
  56. formula not working at column E of NE sheet
  57. Excel VBA, how to retrieve textbox title/label in word fillable form
  58. Solved: Search For String
  59. VBA coding help
  60. Index problems in for loops - excel vba
  61. Solved: Pulling data
  62. Failing to open existing workbook
  63. VBA Arrays - Faster alternative than Vlookup?
  64. Code VBA Excel slowly
  65. Find Multiple Text in Single Cell - Make Bold
  66. Copying all, not just content
  67. I need to copy a range of cells starting from a header row to "sheet2"..
  68. VBA-WebControl HTML Custom Change
  69. Unexpected Behavior of VBA Code
  70. Solved: run automatically each time the cell 'B5' changing information.
  71. Filter by color using checkbox
  72. Please explain this code to me
  73. Saving to a folder and prompting user to enter file name
  74. calculate numbers using a key with VBA
  75. Image Catalogue - VBA Code
  76. Compare the date range and pull the values
  77. Calculate Matches
  78. VBA To Send Email From Lotus Notes
  79. Simple Data Entry form
  80. Best method to detect 32/64-bit Program Files Folder?
  81. Which is better? Processing speed question
  82. Solved: Select line and send to specific fields to another worksheet
  83. Filter, Copy and Paste to New Tab
  84. Solved: Writing formula into cell with Macro. Inverted commas problem.
  85. suppressing warnings / data connections in word
  86. Help me - I'm still learning
  87. Solved: VBA Replace using regular expressions
  88. Solved: Change textbox forecolor if date is earlier then today
  89. Macro to count and give totals
  90. Combine text from different cell in to one of them
  91. Solved: Find All function works Intermittantly
  92. Convert Data
  93. concatenate rows in column b for every corresponding value in column A
  94. How to avoid pressing update button,delete button,confirm button by vba
  95. Display worksheet data in user form
  96. Solved: Insert an empty line between interval
  97. Spinbutton value
  98. Open word files in excel
  99. Create a custom calendar between two dates
  100. [SOLVED:] I am trying to truncate cells in a column from a specific character in a string
  101. Unable to set the FormulaArray properties of the Range Class
  102. [SLEEPER:] Chart Series Selected Index
  103. label caption
  104. [SOLVED:] Copy row and insert between existing rows with relative formula kept
  105. error
  106. VBA Help - Newbie
  107. Sorting two Arrays Together
  108. VBA not catching error
  109. Siebel
  110. Solved: Macros and cell references
  111. Create Break, Reset and Continue buttons in the Excel Sheet
  112. Trying to reduce execution time
  113. Duplicate values
  114. Solved: Match Transpose data to a column Using VBA
  115. Copying Excel data to Word, Only executes once. (Error 462)
  116. VBA Macro: sorting in Column A
  117. Solved: Data type mismatch on Regex replace
  118. Help me find example files? Imaging
  119. Excel 2010 to OutLook 2010 Meeting Request Problems
  120. Sum less than 999
  121. Creating a Timestamp
  122. problem with array formula
  123. Capturing data from a userform to specifice column rows in a worksheet
  124. Data missing in file downloaded using URLDownloadToFile
  125. Solved: Hidden Userform
  126. Ultimate VBA protection
  127. [SOLVED:] Macro to extract url from hyperlink and populate the url in the cell below?
  128. Solved: Can "Lock project for viewing" cause issues?
  129. Switching worksheets in another workbook
  130. VBA Conditional Formatting - code efficiency
  131. Solved: Deleting Rows
  132. Is it even possible?
  133. [SOLVED:] Sorting Different Ranges on Different Columns
  134. removing the double names by changing the current macro
  135. =IF function with 2 true results and 3 false results
  136. calculate a checksum
  137. SpellNumber as per Currency Selection
  138. Solved: Ammending a Copy/Paste between two workbooks macro
  139. Solved: Data_from_another_Spreadsheet
  140. Newbie - Simple code needed
  141. Help required, identify, copy and paste using VBA
  142. VBA winHTTP in async mode
  143. changing color of cells with vba
  144. sort range
  145. Can you use match within a countifs function?
  146. Solved: Compare 2 spreadsheets
  147. VBA module / sub / function tree
  148. Update the current Macro
  149. Saving textbox data from a userform to Sheet2 cells...
  150. Creating several buttons from a list in runtime
  151. Format Ranged Cells Based on Value - VBA help
  152. Need Outlook mails information by Excel VBA
  153. Sum cell values if highligted Red
  154. Using a filter to identify, copy and paste using VBA
  155. Solved: VBA
  156. OWC10 issues
  157. Solved: Unique record ID generator: please help!
  158. [SOLVED:] Changing several button properties only for the buttons in a list
  159. pulling excel variable into webform and submit
  160. Comparison of a set range of columns in Sheet2 to insert correct image to userform...
  161. Criteria for Sumif
  162. Solved: Add "<br />" before number.
  163. Incredibly Urgent Help - VBA Excel
  164. Vba code for parent-child
  165. Case in Case in If then .. else ... end if: compilation error
  166. Solved: Copy from sheet1 & paste to sheet2 in corresponding column
  167. [SOLVED:] Stopping a macro using a macro!
  168. Open Files that include todays date
  169. Solved: Code Selection Change is fired by Enter key
  170. Arrange (Cut and Insert Cut Cells) Rows using VBA Code
  171. Managing and copying data obtained from UserForm
  172. Flagging Rows based on Several Variables within the Row
  173. Performing Find loop on all Word documents in a folder, writing results to a Spreadsh
  174. Solved: Event Macro to add text to cell
  175. Solved: Using an Access form as a Dialog sheet?
  176. Simple one - one cell - another cell, both datetime cells
  177. Solved: COUNTIFS Formula not working in Excel 2007
  178. Help Troubleshooting a VBA Application
  179. Solved: Incremental counter that resets every year
  180. [SOLVED:] Populate a two column search result
  181. Run Time Error 7 Out of memory Issues
  182. Highlight current row & column revisited
  183. Solved: Change code to Private Sub Worksheet_Change (ByVal Target As Range)
  184. Sleeper: Changing the current macro using if Statement or offset
  185. unlock the vba project
  186. Problems with variables and properties
  187. Solved: Evaluate("INDEX vs Application.Index
  188. Start HTML parsing at an already open webpage
  189. Solved: VBA: Unusual LastRow Range
  190. ADOX :Object or provider is not capable of performing requested operation
  191. Solved: VLOOKUP or INDEX/MATCH ?
  192. Solved: Find specific word from text string and poulate in seperate cell
  193. Pivot Chart Macro Problem In Excel
  194. Solved: VBA Code Help please :)
  195. Solved: Branch to specific line in another macro
  196. Finding file name by numerical order
  197. Mental Math workbook - vba to copy down
  198. combine workbooks with same column count
  199. Macro works part does not change the picture
  200. VBA code comboboxes (skip blanks & avoid repeats)
  201. Solved: Find specific word from text string and poulate in seperate cell (continuation)
  202. Solved: Divide column based upon character count
  203. Active Cell formula to change automatically
  204. Solved: faster way to delete cells not containing certain word
  205. Importing Tables From Word Into Excel Spreadsheet Cells
  206. Basic problem needs help: undesired looping in alternate rows
  207. How to protect VBA if read-only?
  208. Excel sheet cell referencing.
  209. delete all the entries based on the user input
  210. Solved: Populate listbox based on sheet selected from a ComboBox
  211. Solved: Copy Paste from Dropdown
  212. Solved: mergeing all date in each row
  213. Deleting Worksheets Containing Dates Older than X
  214. Solved: select correct sheet if complied to 2 values on a selected worksheet
  215. Application Defined or Object Defined error
  216. Solved: Deinstall Add-in?
  217. Single Cell to ListBox
  218. Converting Word to PDF using VBA
  219. Solved: Combine data from row to one cell
  220. Show sum of textboxes in a textbox.
  221. Cant get the macro to click a button
  222. Find Function excel VBA Help
  223. Solved: Hyperlinks to sheet with single quote in name
  224. Set noteApp = CreateObject("notepad.Application") , failed
  225. Solved: Remove the comma of the first cell
  226. Filling table i e-mail
  227. Solved: if column B is empy delete the data on column A
  228. Adding progress bar to existing code
  229. Solved: Remove line break in cell
  230. Solved: Append function formula to range
  231. Populate ComboBox with text/value
  232. help needed to update and edit data from Userform to worksheet.
  233. range determined by cell value
  234. Check first 10 characters of every file in list
  235. Linking Cells From Two Worksheets - Advanced
  236. Variable Sheet name issue
  237. TurnOff AutoCalc on one sheet only
  238. [SOLVED:] Transpose ADO import
  239. Copying Column A to Column E and removing the 4th cell of each value
  240. Sub based on form control checkbox
  241. Combine over 100 workbooks into a single workbook
  242. Need some code tweaking. To scan text files to find certain figures
  243. Solved: Lock a row after a value is chosen from a drop down menu
  244. Search and highlight project help
  245. SQL Statement Help
  246. VBA to view QT Connection String
  247. VBA excel 2011 save as PDF
  248. Macro showing various errors in my code for charts.
  249. Excel Page Format-help pls.
  250. Worksheet Security based on Windows ID