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. sorted data
  2. Solved: Formula results are different then Pivot Table
  3. Solved: VBA Assigning Variable / Runtime Error 1004
  4. Solved: Supressing '#N/A' in WorksheetFunction.VLookup
  5. tab colour
  6. Combinations
  7. ANNIVERSARY DATE
  8. Solved: Sales forecast
  9. Check box control on a worksheet
  10. Solved: cell.adress question
  11. Solved: number format 0.00 €/m²
  12. Macro to do logic based on other column
  13. Solved: .FormulaR1C1 = "=" & Formula_A
  14. Solved: copy paste doesn't work
  15. Solved: TextBox: Entering Date in specific format
  16. Excel VBA. Calculating worktime with different overtimes
  17. [SOLVED:] Optionbutton deselection erases range value
  18. Solved: Copy/Paste All Cells on a Non-active worksheet
  19. Need a reference on where I can hire a local vba Excel expert to work on a project
  20. how to remove some range of cell only,
  21. [SOLVED:] Further variation of Index/Match
  22. Toolbare with option
  23. Solved: Concatenate If in an Array
  24. Custome objects and Collections Classes. Help Please!!!
  25. Selecting a range of sheets using crit in my Criteria
  26. Solved: Printing Problem
  27. Macro help - "Force Use Macros" plus "Auto Close"
  28. Strange formula - now sure how it works
  29. Automatic Cut/Paste to new sheet at every month end
  30. Solved: Trouble Storing Worksheet in a Variable
  31. [SOLVED:] Rounding in units of 0.5
  32. Error handling: #REF!
  33. do not display hide worksheets in data validation list
  34. Solved: Array Formula not recognizing Imported Data as a Number
  35. Solved: Validation data - excluded from list
  36. Solved: VBA - Value Copy Multiple Criteria
  37. Noob with a (probably) simple one
  38. Find problem
  39. [SOLVED:] Question on Hpyerlink
  40. cells colour
  41. Consolidating multiple sheets onto one "parent" report sheet.
  42. Adding a chart
  43. Excel Chart Object Name
  44. Solved: display msgbox once
  45. Edit objects
  46. Delete rows when the code gets deleted.
  47. checking string in IF Loop
  48. VBA for combo box
  49. Is it possible to write vba code to create a conditional format on cells?
  50. "FindNext" function
  51. Solved: Using Excel To Send Emails Through Lotus Notes
  52. Retrieving Data from another Worksheet
  53. Solved: Login Prompt
  54. Solved: Positioning UserForms
  55. Solved: TRIM in VBA
  56. [SOLVED:] Is it Vlookup or Sum Product ?
  57. Excel + Access Help
  58. Solved: need dynamic range
  59. option button macro
  60. Solved: Need to loop thru a folder of workbooks and extract customer addresses
  61. comparing the 2 excel
  62. Solved: Enter the next consecutive number
  63. Listbox active workbooks and copy data
  64. using Excel function TRIM rather than VBA function TRIM
  65. Clear contents in the last populated cell
  66. email different sheets to different people - code needs changing
  67. Is it possible to transfer data from ms access to excel using vba code?
  68. Solved: Conditional Formatting only when value is present
  69. Solved: Import a Silhouette & select X & Y coordinates then do a vlookup Based on the value
  70. Solved: Loop through controls and add data from cells
  71. Searching from a list in Excel, extract Phone#'s from contact's in outlook 2003
  72. Solved: Make sure numbers are increasing
  73. Navigating Through a Recordset (Adding a Record Counter)
  74. Create 1 Public Sub for 5 textboxes
  75. Solved: POP UP Message when a criteria is met
  76. Menu tree
  77. Formatting a column into "text"
  78. data model in excel
  79. Solved: Excel, append & retrieve numbers in a txt file with next number in increments one
  80. Using iMacros in a loop with input from Excel
  81. Solved: how do i get the the name of the user who opened the file?
  82. Using vba to open website
  83. Solved: Locate values from List
  84. [SLEEPER:] Extract rows to new worksheet and save as new workbook
  85. Excel Problem
  86. Solved: Selection Rows CountA?
  87. Solved: Code not updating all worksheets
  88. SSN Format
  89. Update code in 220 objects
  90. SUM IF in vba and result in message box
  91. Solved: Problem with copy/paste "Formats"
  92. Using Yes No Message Box
  93. Excel 64bit issue with Winsock UDP connection
  94. Automatic Macro execution
  95. Insert Hyperlink from External Source to a Protected Sheet
  96. VBA Chart fill area
  97. Excel 2003 VBA coding and "pop up button" help
  98. Excel 2003 VBA coding tweak
  99. Read external data from dynamic text range, then calculate stats
  100. Solved: Two listboxes on same userform problem
  101. File (path to a folder) not found
  102. creating a data base using Excel & VBA
  103. Print workbook - disable
  104. How do I close an instance of Quickbooks in VBA?
  105. Sum Values in defined target
  106. Solved: need a magic formula to ..
  107. Write data to sheet 2 if sheet 1 is full
  108. "Window" menu item
  109. VBA Help needed total newbie
  110. DOM: Searching only the tags embedded within one particular div tag
  111. Macro help required if possible
  112. Excel keeps switching between 'ready' and 'chart updating'
  113. Solved: Clear Red Interior if Text is Red
  114. excel addin problem
  115. count the no. of A
  116. VBA Copy & Paste
  117. Excel 2007/2010 - Can I have workbook specific disabling of row inserting?
  118. System Error: &H8001010D (-2147417843) An outgoing call cannot be executed...
  119. VBA code below
  120. Filter Sheet With text on cell
  121. VBA array difficulty
  122. Is it possible to use vba to automate a count on recurring data?
  123. Solved: Input Box Validation please help
  124. Solved: Find maximum value in a column
  125. Excel stopwatch needed
  126. max value of another textbox
  127. Open web Page and clink on a link within the page
  128. Set Cell Value As Variable?
  129. How to turn any URL input into file name
  130. pervent only one sheet from deletion
  131. Sumif
  132. Creating charts using VBA: problem with intervals
  133. Report from excel database ??
  134. Ado DB connection in Excel
  135. Solved: Create new folder with name and date
  136. Solved: VBComponents - how to retrieve "Sub" or "Function" exactly
  137. Need help with default save script from 2010 to 2003
  138. Return control after application.run
  139. [SOLVED:] Split cell contents into multiple rows
  140. Solved: Selecting a Rows with Data
  141. using conditional formatting
  142. Solved: Mortgage loan spreadsheet problem
  143. Finding special charecters in excel
  144. formula for logical condition
  145. Solved: Code prevents formulas working!
  146. Solved: Merge Workbooks
  147. Sending Excel Cell Data via E-Mail
  148. Solved: Why does code need On Error Resume Next?
  149. SaveAs Command to Overwrites a Excel File
  150. Detecting a cell change
  151. Data Input Form Workbook
  152. How to select option in pop-up list????
  153. excel VBA and post for ASP.NET
  154. Solved: display multiple labels as $0.00
  155. Solved: use input box chara to create new woorksheet name
  156. [SLEEPER:] Run-time error '13' on comparing arrays help needed
  157. Is it possible to upgrade Excel and perform File Remediation using vba?
  158. clear contents formula
  159. Solved: Ignore Countif If Cell Contains a Value
  160. Solved: Disable all saving
  161. Is that possible to excute code by using Keboards "CTRl+Eneter"
  162. Highlight The Selected.
  163. VBA code-Signature code failure
  164. Cut and paste the challenge
  165. Error using Find function
  166. Solved: Insert row above next empty cell within a column
  167. Solved: Question About copy Selection
  168. Basic question about Application.enableevents
  169. highlight the cell with "peter"
  170. Solved: Excel - Change font color if invoice number is out of order.
  171. Solved: disable protected sheet message
  172. Problem switching between Excel and Word
  173. Sleeper: Input Mask
  174. UDF to calculate average according to condition, ignoring blanks
  175. Solved: Specific cell selection
  176. Compile Error
  177. Update only the latest data from Excel to Access table
  178. Extract data from PDF
  179. VBA Select Case
  180. Help with clear contents
  181. Is there a formula or statement that works out percentage rates in Excel?
  182. Solved: Search for text in IE
  183. Last row of the worksheet
  184. [SOLVED:] How to print from sheet active to the another sheet
  185. Loop the code
  186. Worksheet Delete
  187. Transpose single column array
  188. Solved: Stop CommandButton moving or rename button
  189. Solved:
  190. Request for review
  191. Solved: Select Row problem
  192. Help defining and setting variables
  193. Permutations
  194. Solved: Decrease qty thru msgbox
  195. Loop Help
  196. VBA to export 2 worksheets at a time
  197. For loop trouble
  198. Printing Copies with VBA
  199. Solved: Only copy selected sheets
  200. VBA code to run on specified time
  201. Solved: Nested IFs
  202. Solved: Directory Path
  203. VBA match, copy , paste and append
  204. Solved: need to contain clearing of row within a range
  205. [SOLVED:] Spinbutton and date textbox
  206. Mortgage spreadsheet concept problem
  207. Action when result of formula changed
  208. Solved: Help with loop please
  209. Solved: Columns to Rows keeping data integrity
  210. Solved: userform label format
  211. Solved: Macro to go to first worksheet in any workbook
  212. Solved: Delete after first space
  213. Copy Data to the Serial Number Row
  214. [SOLVED:] Simple Formatting
  215. Solved: spinbutton on date textbox
  216. Inserting an image based on the option choosen
  217. Disabling multiple textboxes
  218. Label Calculation
  219. Solved: .text to .value
  220. [SOLVED:] Finding text on ie that's next to what you search
  221. Timed VBA Mail code
  222. Solved: Set the Data / Group and Outline / settings..
  223. Cannot get the protection code to work with the rest
  224. Excel workbook "access denied"
  225. Delete the repeated code
  226. Office 2003 Combobox_Enter
  227. Solved: Disable Form Control Button/Code
  228. Solved: The Art of Conditional Formatting!
  229. Solved: Text to columns (With only the first bit of text)
  230. Solved: Create and Edit a Scheduled Task from Excel
  231. Solved: Check the clipboard for Data before paste?
  232. Comparing values from Different worksheets
  233. Need to preventt xlsm file from being converted to xls
  234. Dynamic chart-Modify series formula from vba
  235. Multi sheet macros.
  236. Solved: calculate difference between 2 excel files
  237. Solved: VLOOKUP multiple criteria
  238. Business Days
  239. Modify code to also remove cell borders
  240. Disable Fn Alt and Ctrl Keys
  241. vba password recovery
  242. Copy and Paste between Instances of Excel
  243. Change Column Content
  244. [SOLVED:] How to populate array with collection?
  245. Excel Macro to delete rows if cell matches List of Values
  246. [SOLVED:] find all combinations (no repeats)
  247. Excel 2007 VBA SOAP Web Services Integration
  248. Excel Edit Mode Bug?
  249. Solved: How To Sum Worksheets
  250. bar chart with stacked option