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

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