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