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:] For Each Loop - Strange Behaviour (logic breakdown)
  2. If cell is blank, delete the row?
  3. [SOLVED:] How do I create a new column next to a specific column using VBA?
  4. Class approach for new controls questions
  5. [SOLVED:] change colour of lbl when hovvered
  6. Does
  7. Reference to header instead of hardcoding column letter?
  8. [SOLVED:] Auto creation of sheets based on Data sheet with a sample output shown next to it
  9. [SOLVED:] Separate Time HMS
  10. [SOLVED:] VBA - Paste Entire Row that meets criteria into Sheet2 without overwriting
  11. [SOLVED:] Searching a file for information
  12. [SOLVED:] Ensure selected cell is filled before proceed to VBA language
  13. [SOLVED:] Sort Automatic Sheet based other sheet
  14. [SOLVED:] Shorten the If statement and Capturing New Row Number
  15. VBA code to pick id and password for oracle from excel
  16. [SOLVED:] Find Multiple values and return value from another column
  17. [SOLVED:] combine values from multiple columns into a single cell in column
  18. Populate Combobox with Worksheet Names EXCLUDE hidden
  19. Need assistance with merging rows, please.
  20. Copy & Pasting Formula to Cells in Another Sheet
  21. [SOLVED:] Help on "Grouping" the remark in formula VBA
  22. Help to reduce the VBA code length
  23. Excel - E-mail via Lotus Notes
  24. Different Language Has Different Character Widths
  25. Convert Text Dates To DateSerial And Sort
  26. Finding out missing records from insert statement
  27. [SOLVED:] pdf print from multiple sheet
  28. recherche VBA
  29. [SOLVED:] Copy Data from a Workbook with multiple Worksheets to another Workbook
  30. Find Function and Merged Cells
  31. [SOLVED:] Run-time error 438: Object doesn't support this property or method
  32. Simple Data List Help
  33. [SOLVED:] Search repated word in excel using VBA
  34. pdf print from multiple sheet (issue)
  35. Help Consolidating Data Please
  36. How to pull airport flight time from web to excel?
  37. cannot find MenuSheet in Excel Add-in
  38. 2007 date formatting
  39. [SOLVED:] Placing an arrow and change its position
  40. [SOLVED:] Selected Listbox item select in sheet cell
  41. [SOLVED:] UF Image Event
  42. [SOLVED:] worksheet hiding depending on content of worksheet cell
  43. Combine Multiple Workbooks onto Master Workbook - Separate Worksheets
  44. Macro to loop in through Word files(.doc), find and delete a section, save and close.
  45. Insert Record from Excel to MySql using VBA
  46. [SLEEPER:] VBA to compare string and replace a sub string with other value
  47. [SOLVED:] Changing the properties of an embedded chart without select or activate
  48. 5 Years Annual Turnover calculated from a start date
  49. The Replace method - A newbie needs help!
  50. [SOLVED:] Adapt sub to execute from primary workbook
  51. Protect VBA Project one workbook through Another Workbook in VBA
  52. Save Workbook Macro Issue
  53. [SOLVED:] UF To Spreadsheet Help
  54. Simple Database Build
  55. Odd behaviour of a worksheet.
  56. Selecting range relative to found values - Multiple Instances
  57. [SOLVED:] Deactivate Add-in and save .xlsm as Add-in then activate the ADD-IN again
  58. Very weird problem - Excel 2007 Worksheet manipulation
  59. Import from Web - Code Interruption
  60. VBA loop and printing help
  61. [SOLVED:] Copy two ranges in one row to the one below, same format if possible... Little help?!
  62. [SOLVED:] Timing of UserForm Display
  63. ple.help .how to get multipule values from single lookupup value using vlookup in xl
  64. Import Data from Webpage
  65. [SOLVED:] UF Lookup Image Help
  66. Change cell value within a row depending on other cell values within same row
  67. Need help pulling info from a list
  68. [SOLVED:] How to re-display Excel after opening and closing a Word document
  69. Tracking changes of a cell value with a line chart
  70. [SOLVED:] Text code
  71. [SOLVED:] Circular Reference Error
  72. Add multiple series to graph using VBA
  73. Importing data from script-based web pages
  74. [SOLVED:] Loop for worbook and worksheet changes
  75. How can I copy and paste an entire sheet with pivot table and formats?
  76. Need formula converting RGB to vba backcolor
  77. [SOLVED:] Select only Unlocked cell
  78. [SOLVED:] Determine # of workdays
  79. VBA project help
  80. [SLEEPER:] Copy website content in to excel
  81. [SOLVED:] I get a boolean value instead of formula with my code =/
  82. Drop down list plus text box
  83. Worksheet Function In VBA
  84. help! i need a good soultion to a project i just got in school
  85. Add on additional range in Loop
  86. How to make a list of Files and folders of a directory in excel
  87. RowNext starting from a certain Row
  88. [SOLVED:] quick help on using a variable to define a range
  89. Getting a compile Error, Please help!
  90. Extract Hyperlinks from Word into Excel
  91. [SOLVED:] Importing CVS files in to a worksheet
  92. [SOLVED:] docking code pane
  93. Auto Copy a website table into excel
  94. Array Param Problem with AutoFilter
  95. [SOLVED:] Non-VBA question : Using OR criteria in an IF statement
  96. [SOLVED:] Repeat 12 time the data on column A to column B
  97. [SOLVED:] Combobox decides the picture to show
  98. [SOLVED:] Copy Worksheet with Embedded Chart Object to New Workbook - values and formats only
  99. Need code to run across an Array of sheets
  100. Specify Columns for HTML export
  101. [SLEEPER:] activate an already open workbook or open if not open
  102. [SOLVED:] Quality check of data in InputBox
  103. [SOLVED:] Create a List of Pivot Table Report Filter Selections on Worksheet
  104. Compare 2 columns and remove matching duplicates in both columns when found
  105. Dowload outlook email attachment to my pc folder
  106. [SOLVED:] How to use user defined function (bucket)
  107. Using Macros to change data in a spreadsheet.
  108. [SLEEPER:] Absolutely no help the way this system works
  109. Find Missing VBA Project References Code
  110. Referencing multiple userforms
  111. [SOLVED:] Variable reference cell value
  112. Cube Values Timing Out When Batch Printing PDFs
  113. Dynamic Dependent ActiveX Dropdown from Column Data
  114. [SOLVED:] To enter one space after single digit
  115. Excel 2013 erro 13 message
  116. [SOLVED:] Macro deletes text only in No Fill cells
  117. How to grab data from the site?
  118. Guidance on VBA Rota/Scheduler procedure/algorithm
  119. Macros with buttons, spin buttons, scroll buttons, etc.
  120. Randomize/shuffle a list of names
  121. Import Word document file name into Excel
  122. INFINITE LOOP PROBLEM!!!
  123. Hyperlinking
  124. [SOLVED:] Subtotal multiple blocks of data
  125. [SOLVED:] Show a message only once, using Application.OnTime
  126. Excel 2013: First Sheet and Last Sheet
  127. Choose Sheet AddIn
  128. On change event issues
  129. [SLEEPER:] .xml to excel conversion using vba
  130. Changing font on certain letters
  131. Using Excel to Connect to Oracle
  132. [SOLVED:] Naming A Shape and Connector Line After Its Creation"runtime" Excel VBA
  133. Force Macros Enabled And Close When Idle
  134. Importing Data From Web Page
  135. [SOLVED:] Issue recording Pivot tables
  136. lookup word then apply formula
  137. [SOLVED:] Looping through shapes by Name VBA Excel
  138. Copying data from another Workbook row wise
  139. [SOLVED:] Inserting a new Column
  140. [SOLVED:] Separating Names From this dynamic list and summing them into Preset Cells VBA Excel
  141. dynamic range lookup
  142. [SOLVED:] Using excel to connect to ERP SOAP webservice
  143. Userform in VBA and DATEDIFF function
  144. Slow
  145. Advanced Formula
  146. if Dependent is not on the same sheet, then the cell will be given red colour
  147. [SOLVED:] Find VBA Multiple criterias
  148. Sorting GPS marks
  149. [SOLVED:] InStr exact match
  150. Macro for drop down menu based message box
  151. Macro for drop down menu based message box
  152. [SOLVED:] Applying icon to commad BAR not button (user defined add in)
  153. [SOLVED:] Macro exits sub after calling macro from another workbook (Application.Run)
  154. [SOLVED:] Saving Files As Read-Only
  155. [SOLVED:] Multiselect Listbox Help
  156. compare columns of two workbooks and add to master workbook
  157. Randomly Select 4 Column Ranges and Copy and Paste to Another Worksheet
  158. [SOLVED:] How make defined range move upon sort?
  159. [SOLVED:] Count textbox values greater than 0
  160. Replacing text with a image
  161. [SOLVED:] Have I got the wrong documentation?
  162. [SOLVED:] Using VBA With OOo
  163. [SLEEPER:] Automate calculation using First in First Out way
  164. Excel - Use Dropdown menu populate a column
  165. [SOLVED:] StopWatch or Timer Class Module
  166. [SOLVED:] Inaccurate results from formula
  167. [SOLVED:] need help with counting sheets with specific names plus adding sheets after them
  168. [SLEEPER:] Resize userform VBA
  169. Get list<T> from c# dll and access to its items
  170. COPY AND PASTE VALUE - CELLS WITH SPECIFIC VALUES USING A MACRO
  171. I Need Vba Code Copy Of Cell And Paste To Other Cell
  172. [SOLVED:] Delete duplicates (based on the same line multiple columns)
  173. VBA LOOP Macro
  174. Comunicate between 2 userforms
  175. Sleeper: Tricky For Loop Code
  176. [SOLVED:] add header/footer to new word document from excel
  177. [SOLVED:] Comparing lists of values, & adding unique values to the 1st blank cells of a range
  178. Need Help on : Application.Filesearch
  179. Open an email Lotus notes and copy the content to excel
  180. Monitor Folder code goes into a loop
  181. [SOLVED:] Similarly named textboxes - loop
  182. [SOLVED:] Merging Duplicate in Column A
  183. Need help creating a loop macro that spits out a master data file
  184. [SOLVED:] Where To Put Code
  185. [SOLVED:] Change Row Color based on Cell String Match
  186. [SOLVED:] VBA IF functions (Help)
  187. [SOLVED:] Intersect - very basic problem
  188. VBA chess game, userform
  189. How to create a formula for a drop down list??
  190. [SOLVED:] Copy to the latest blank row
  191. [SOLVED:] Special Characters
  192. [SOLVED:] Weird Cell formatting
  193. [SOLVED:] Problem with move more thab 65536
  194. [SOLVED:] VBA code works in office 2007 not in office 2010(embeds an attachment in excel)
  195. [SOLVED:] CDATA with values from the active worksheet
  196. Unique Rank Question
  197. VBA userform - decimal separator
  198. Help with "Array fuctioons"
  199. Free Standing Alternatives to Excel Database
  200. Import External Data
  201. macro to lookup record on current row and mark completion date to corresponding recor
  202. Why a variable of type Range does not accept Nothing when cutting range of cells?
  203. Excel VBA with Pivot Table
  204. [SOLVED:] Macro works in Excel 2003 but not in Excel 2007/2010
  205. Paste data from word table into excel sheet while skipping hidden columns
  206. [SOLVED:] Lookup value in table with two criteria in rows
  207. [SOLVED:] hrefs from an ordered list <ol> on a webpage in Internet Explorer
  208. Compare 2 sheet and paste the resault on sheet3
  209. Web Query refresh issue
  210. Best Tutorials / Courses / Reading to Master Excel
  211. VBA Code to change Color in range of Cells.
  212. [SOLVED:] Use Contents of ComboBox in Vlookup and Save to Data Table
  213. If no error, write the word "ok" to a cell?
  214. [SOLVED:] Strange behaviour ListBox.Selected(index).
  215. HELP - Copy Variable Sheet Range from multiple sheets to Summary Sheet
  216. extract data from txt file
  217. How to use vlookup and countif together in one formula?
  218. [SOLVED:] List all Open Window titles in column A
  219. [SOLVED:] Moving automatically generated page breaks
  220. Automatically generating custom timeline on separate tab (Excel 2010)
  221. Unlocking all Excel (2007) cells by default
  222. [SOLVED:] Problem Word Wrapping VBE Code
  223. New to VBA. Getting a Compile Error. Please help.
  224. Requesting a macro for printing an Excel sheet automatically as PDF on daily basis.
  225. VBA Conditional formatting if one cell equals another cell in value
  226. [SOLVED:] Get an automatic sequence in a formula
  227. Input Box is popping too much.
  228. [SOLVED:] Find Method w/ VALUE error
  229. Who has ever met this?
  230. [SOLVED:] help needed to adjust a macro
  231. Function isn't working on button click
  232. Find a unique value with a condition across 2 lists, add it to the less complete list
  233. [SOLVED:] Conditional Compilation Quick Question (Well, at least hopefully)
  234. Ribbon Change which works as an ADD-IN
  235. Excel CalCulation Issue
  236. [SOLVED:] Referencing a Userform in a module
  237. [SOLVED:] Create a Loop - Help!
  238. [SOLVED:] Linking/merging two worksheet_change functions
  239. Sleeper: Look up & return
  240. [SOLVED:] Convert Cell Value in a range of cells
  241. [SOLVED:] When does a Workbook become a member of the WorkBooks Collection?
  242. [SOLVED:] clean a row if it doesn't start with a number except _
  243. [SOLVED:] if find the matched data in another work workbook copy the complete row
  244. [SOLVED:] When running a macro, Excel suddenly stops responding
  245. compare 2 sheet and all column if find duplicate will delete on sheet 2
  246. [SOLVED:] Cannot get xlSaveDialogAs or GetSaveAsFilename to work as required
  247. xml download "argument not optional"
  248. [SOLVED:] I am Having a challenge with ThisWorkbook.Close
  249. 400 Error
  250. [SOLVED:] Need help to calculate average of those cells between two blank cells